Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ahmed_adel
Contributor
Contributor
‎2021-04-04 05:20 AM

how to connect to oracle DB using TNS names programmatically

how to connect to oracle DB using TNS names programmatically without using TNS file name which requires wizard actions.

Labels (3)
Labels
566 Views
1 Reply
tnewbie
Creator II
Creator II
‎2021-04-05 05:17 PM

If you have to switch databases/environments on the fly, there are 2 ways of doing it:

1) Have a different set of contexts that point to different environments

2) Use Connection type as 'Oracle Custom' where you will be able to build your Server information as a JDBC string.

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)) ) )

566 Views
0 Likes