Hi, is it possible to use TNS entries defined in the tnsname file to connect to an Oracle database ? We have a failover clause specified and we can't use it in Talend. I made a search in the forum and in the documentation but wasn't able to find anything Thanks
Moreover, the use of tns facilitate the configuration management. The server we use for Talend has the oracle client and the dba push a new tnsnames.ora to the server. If we use a configuration file or a table to store those data, we have to change it too. Thanks
According to DBD:racle documentation on CPAN it is perfectly possible to use the tnsnames.ora definition with a Perl job (and I have already done it with an earlier version of TOS, but it's not possible with TOS 2.4.x, unless we make some slight changes)
Try editing the JDBC connection string and use the address_list option. eg. jdbcracle:thin:@(description=(address_list=(address=(host=myhost1.domain.com)(protocol=tcp)(port=1521))(address=(host=myhost2.domain.com)(protocol=tcp)(port=1521)))(connect_data=(service_name=myservicename)))
Hi jholman, I' ve tried to use your suggestion editing the parameter 'String of Connection' in Metadata --> Db Connection --> Create Connection. The connection is checked successfully, but Talend don't save the text of parameter. Do you know this behavior? Can I use a work-around?
is it possible to use TNS entries defined in the tnsname file to connect to an Oracle database ? We have a failover clause specified and we can't use it in Talend. Do we have a solution to the above mentioned project. I am using java as a language in talend