topic Talend Data Integration Oracle DB Connectivity in Talend Studio

Talend Data Integration Oracle DB Connectivity

Anonymous — Mon, 12 Dec 2016 10:18:44 GMT

Hi Team,
I am trying to connect Oracle 11g from Talend, but i am receiving error ORA-12154.
Whereas with the same credentials i am able to connect through SQL Developer.
I am using to Connect through Connection Type : TNS and Connection Identifier : XXXXXX along with my user id and password

Can some one help how can i use the same in Talend and what option to select in talend DB type?

Re: Talend Data Integration Oracle DB Connectivity

wcfsmart — Mon, 12 Dec 2016 16:11:25 GMT

Hi harryhkwtd,
I'm note sure it's possible to use TNS with talend.
For me, I use "Oracle with Service Name" or "Oracle with SID", then choose oracle version, fill the login, pwd, server, port ...
Are you trying to create a connection ?
I hope this will help you
Nice day
wcfsmart

Re: Talend Data Integration Oracle DB Connectivity

Anonymous — Thu, 22 Dec 2016 15:48:46 GMT

Hi wcfsmart,
Thanks a lot for your reply.
Here in my current project, the oracle team just gave these parameters to connect only with TNS and connection identifier.
NO i am trying to create a connection, just login to oracle .
Now i am finding it difficult to map the equivalent option in Talend whether i should use connect by : custom or OCI or SID or service name
In my other assignments, i have been provided with user id & pwd parameters to log in and it worked pretty well 100%.
I am still facing the same issue and not resolved.
Thanks for your inputs,
Harryhkwtd