topic Re: Add 2 host name in oracle in Connectivity & Data Prep

Add 2 host name in oracle

Bhoomi_walmart — Thu, 06 Jul 2023 12:08:51 GMT

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

Re: Add 2 host name in oracle

Chirantha — Mon, 10 Jul 2023 08:22:53 GMT

Hey Bhoomi,

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

For more informaiton please refer to this article

Re: Add 2 host name in oracle

Bhoomi_walmart — Mon, 10 Jul 2023 10:41:47 GMT

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?