TLS SSL connection between Oracle database AWS EC2 instance and Qlik SaaS

oraqlikreport — Wed, 19 Mar 2025 23:02:17 GMT

Hello All,

I am new to Qlik, and looking to setup TLS/SSL connectivity between Oracle Database (which is AWS EC2 instance) and Qlik cloud SaaS.

On Qlik, I could see "BASIC" and "Oracle Wallet" option.

Based on Qlik documentation: for wallet option we need to provide zip file which includes .sso file, and tnsnames.ora.

Based on Oracle documentation, such client credentials zip file can be downloaded from OCI console for autonomous database and it contains few other files like java keystore and java truststore, ojdbc.properties etc.

So please confirm if this Oracle wallet option can be used in case of Oracle DB EC2 instance at all? Alternatively, would it work if I manually create the files required in the final zip file and upload it in Qlik for data connection.

Would you please guide me in this regard, is there any specific steps document which I can refer to?

I would appreciate any assistance in this, thank you.

Re: TLS SSL connection between Oracle database AWS EC2 instance and Qlik SaaS

oraqlikreport — Wed, 11 Oct 2023 09:09:03 GMT

Got the solution/workaround which is as follows:

In our case as client side was Qlik SaaS. We were not comfortable to whitelist qlik cloud ip addresses and expose production db servers to external IPs. We had to setup windows server with direct access gateway and after that I just had to provide .sso and tnsnames.ora file and it worked out fine.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-setting-up.htm

Hope this helps someone in future.

Cheers,

Kalpesh J.

topic Re: TLS SSL connection between Oracle database AWS EC2 instance and Qlik SaaS in Data Movement & Streaming

TLS SSL connection between Oracle database AWS EC2 instance and Qlik SaaS

Re: TLS SSL connection between Oracle database AWS EC2 instance and Qlik SaaS