I'm trying to create a new Metadata DB Connection in Open Studio 5.1.1
DBType: Oracle RAC
Db Version: Oracle 10
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.
Thanks in advance.
I tested it on v5.1.1 and it works. You must have some wrong settings, please see my screenshot.
The server URL:
change it to fit your database.
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!
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?
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?