topic Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud in Connectivity & Data Prep

Can't connect to PostgreSQL Database with Qlik Sense Cloud

Foxwhite92 — Wed, 23 Mar 2022 18:56:55 GMT

Hi,

I am trying to connect to a local postgre Database from my Qlik sense Cloud application, but it doesn't work.

I have this error message :

ERROR [08S01] [Qlik][PostgreSQL] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? could not connect to server: Cannot assign requested address Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

Please help me to solve this issue, without being able to connect to my database, I can't do anything with Qlik.

Thank you.

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Francisco_Fernandez — Thu, 24 Mar 2022 08:34:27 GMT

Hello @Foxwhite92 ,

Is your database externally accesible?

I would suggest allowing the IPs detailed on the following link:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm

If your database is not accesible from the internet I would suggest checking Qlik Data Transfer, since it will allow you to upload the data directly to the cloud.

https://www.qlik.com/us/products/qlik-data-transfer

https://www.youtube.com/watch?v=9LCCg5ppgKI

Best regards,

Francisco

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Foxwhite92 — Thu, 24 Mar 2022 17:50:46 GMT

Hi @Francisco_Fernandez

Thank you for your answer.

To be honest I don't know if my Database is externally accesible. I have just install postgreSQL on my computer and create a Database with SQL command.

Can you tell me where I need to add this IP adresses ?

Thank you for your help.

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Foxwhite92 — Thu, 24 Mar 2022 17:51:18 GMT

Hi @Francisco_Fernandez

Thank you for your answer.

To be honest I don't know if my Database is externally accesible. I have just install postgreSQL on my computer and create a Database with SQL command.

Can you tell me where I need to add this IP adresses ?

Thank you for your help.

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Akshesh_Patel — Thu, 23 Jun 2022 16:55:28 GMT

Hi,

If the database is not accessible via the internet then we won't be able to connect that directly to the SaaS.

You need to use the Qlik Data transfer to transfer the local data to a saas.

Thanks

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Foxwhite92 — Thu, 23 Jun 2022 19:07:26 GMT

Hi @Akshesh_Patel

Thank you for your answer. Unfortunatelly and I can't use the Qlik Data trasnfert solution.

Is it possible to configure my Database so that it is accessible from the internet. By adding for example the IP address of Qlik ?

Edit : I saw that it was possible to add the IP addresses in the config file of Postgre. But I don't know what is the IP address of the QLIK server. I only know the URL.

Thank you

Re: Can't connect to PostgreSQL Database with Qlik Sense Cloud

Akshesh_Patel — Mon, 27 Jun 2022 17:57:39 GMT

Hi,

There is no specific IPs in SaaS, the only requirement is that your database should be accessible by the internet. But you might need to consider whitelisting this Ip's: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm?_ga=2.196944421.840344352.1656352077-1527048612.1653060637

Thanks