topic Creating a new Oracle DB Connection in Talend Data Catalog

Creating a new Oracle DB Connection

shawnling — Wed, 22 Aug 2012 18:07:50 GMT

I'm trying to create a new Metadata DB Connection in Open Studio 5.1.1
DBType: Oracle RAC
Db Version: Oracle 10
Server: DWMARTD2
String of Connection: DWMARTD2
When I click on the "Check" button, I got "Connection Failure. You must change the Database Settings." After I click on the "details", I got "impossible to initialize the connection".
I have no problem to connect to the server in TOAD on the same machine.
Please help!
Thanks in advance.
Shawn

Re: Creating a new Oracle DB Connection

Anonymous — Thu, 23 Aug 2012 10:05:52 GMT

Hi
I tested it on v5.1.1 and it works. You must have some wrong settings, please see my screenshot.
The server URL:
jdbc racle:thin:@(description=(address=(protocol=tcp)(host=192.168.30.19)(port=1521))(connect_data=(service_name=talend)))
change it to fit your database.

Re: Creating a new Oracle DB Connection

shawnling — Thu, 23 Aug 2012 16:50:09 GMT

Thanks for your quick response, Shong.
I still have a few questions on this one:
1) For the "Server field", do we always need such a long URL? If so, Talend may change the field label to Server URL instead of "Server". Otherwise, user may assume it's just a server name.
2) Do we need to specify the exact IP address for the "host"? Will Open Studio be able resolve a server name to IP address?
3) It seems that the "String of Connection" is always the same as "Server" field. Do we really need both fields here?
Cheers!

Re: Creating a new Oracle DB Connection

shawnling — Fri, 24 Aug 2012 19:43:49 GMT

Finally, I figured out the easiest way to find the info based on Shong's suggestion.
I used "tnsping" to get the whole connection string. Then, you can get all the info you need for the connection setup.
Cheers!

Re: Creating a new Oracle DB Connection

Anonymous — Thu, 21 Jul 2016 02:55:14 GMT

I am facing a weird problem.
when I give the connection string as mentioned above and then check, it works fine. After that when i click the connection either in profiling or from MDM the service_name is being empty and the connection fails.
I dont know why the service_name becomes empty once i come out of the connect screen. Can anyone help me?
Thanks.