Oracle connection string as end point

[desmondchew]

I referred to the link https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Tutorial/AddSourceOra_samp...m to setup Oracle database as my end point. However it failed in verification.

Under connection string: hostname:port/service_name

I added

hostname:1521/servicename

Where does Qlik replicate picks up the oracle service name?

[Steve_Nguyen]

the service name is from your TNS :

• port: (optional) This is the TNS Listener Port number for the computer with the Oracle database that you are using. If you do not enter a port number the default Oracle TNS Listener port is used.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Oracle/OracleDB_Target_Dia...

https://stackoverflow.com/questions/33907809/where-is-tnsnames-ora#:~:text=on%20this%20post.-,tnsnam....

[desmondchew]

Apparently Qlik Replicate doesn't pick up any tnsnames.ora. I specific the following strings in the connection string box and manage to get it setup.

Please replace HOST, PORT and SERVICE_NAME to your environment.

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=servername) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service.domain.com)))

It works for me.

Regards
Desmond

[Heinvandenheuvel]

>>  Qlik Replicate doesn't pick up any tnsnames.ora.

Replicate just passes everything on to Oracle OCI which can look up TNSnames.

If you used the instaclient, then the TNSnames is looked for in that install directory, not the usual home\network\admin

https://www.oracle.com/database/technologies/faq-instant-client.html