Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bhoomi_walmart
Contributor
Contributor

Add 2 host name in oracle

I want to add 2 host name while creating new connection(from data load editor) with oracle in

like this jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edc.prod.he.com)(PORT=61290))(ADDRESS=(PROTOCOL=TCP)(HOST=cdc.prod.he.com)(PORT= 61290))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=usmppp1_usmpppdbp1_ro.gec.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(LOAD_BALANCE=ON)(DELAY=5))))

Labels (1)
2 Replies
Chirantha
Support
Support

Hey Bhoomi,

 

  1. In the Data load editor, click on Create new connection and select Oracle.
  2. In the Create new connection window, enter the connection details, including the connection string you provided in your message.
  3. Click on Test Connection to verify that the connection is working correctly.
  4. Click on Create to create the new connection.

For more informaiton please refer to this article

Bhoomi_walmart
Contributor
Contributor
Author

Hi Chirantha, I have 2 host name in my string 

1. HOST=edc.prod.he.com

2. HOST=cdc.prod.he.com

As we don't have option to add string directly in qlik.

How i can add 2 host in one connection?

Capture2.PNG