topic Re: Oracle connection string as end point in Qlik Replicate

Oracle connection string as end point

desmondchew — Tue, 22 Feb 2022 15:26:37 GMT

Under connection string: hostname:port/service_name

I added

hostname:1521/servicename

Where does Qlik replicate picks up the oracle service name?

Steve_Nguyen — Tue, 22 Feb 2022 16:54:31 GMT

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.

desmondchew — Wed, 23 Feb 2022 00:38:57 GMT

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 — Wed, 23 Feb 2022 22:55:24 GMT

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