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
Write Table now available in Qlik Cloud Analytics: Read Blog
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
441 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)) ) )

441 Views
0 Likes