https://community.qlik.com/t5/Talend-Studio/how-to-connect-to-oracle-DB-using-TNS-names-programmatically/m-p/2335652#M104192 <P>how to connect to oracle DB using TNS names programmatically without using TNS file name which requires wizard actions.</P> Sat, 16 Nov 2024 00:19:12 GMT ahmed_adel 2024-11-16T00:19:12Z https://community.qlik.com/t5/Talend-Studio/how-to-connect-to-oracle-DB-using-TNS-names-programmatically/m-p/2335652#M104192 <P>how to connect to oracle DB using TNS names programmatically without using TNS file name which requires wizard actions.</P> Sat, 16 Nov 2024 00:19:12 GMT https://community.qlik.com/t5/Talend-Studio/how-to-connect-to-oracle-DB-using-TNS-names-programmatically/m-p/2335652#M104192 ahmed_adel 2024-11-16T00:19:12Z https://community.qlik.com/t5/Talend-Studio/how-to-connect-to-oracle-DB-using-TNS-names-programmatically/m-p/2335653#M104193 <P>If you have to switch databases/environments on the fly, there are 2 ways of doing it:</P><P>1) Have a different set of contexts that point to different environments</P><P>2) Use Connection type as 'Oracle Custom' where you will be able to build your Server information as a JDBC string. </P><P>Ex for your reference: DB_SERVER=jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE=yes) (ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=xxxx)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxx)(PORT = xxxx)) (LOAD_BALANCE = YES)(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxxxxxxx)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)) ) )</P> Mon, 05 Apr 2021 21:17:55 GMT https://community.qlik.com/t5/Talend-Studio/how-to-connect-to-oracle-DB-using-TNS-names-programmatically/m-p/2335653#M104193 tnewbie 2021-04-05T21:17:55Z