Not able to Write in postgress SQL through Qlik write back Table using Qlik Atomation ?

[FaizanMirza]

Hi Qlik Community,

I'm encountering an issue while trying to implement a WriteBack functionality from Qlik to a secure PostgreSQL database. Here are the details:

Current Setup:

• Using Qlik WriteBack table
• Target: Secure PostgreSQL database (not publicly accessible)
• Successfully connected using PostgreSQL connector block

Issue: When attempting to write to the database, I'm receiving the following error:

SQLSTATE[08006] [7] connection to server at "server-name", port 5432 failed: timeout expired 
(SQL: SELECT MAX(modified_date) FROM db)

What I've tried:

• Established connection using PostgreSQL connector block
• Confirmed the database connection is successful initially
• Verified the WriteBack table configuration

Questions:

1. How can I resolve this timeout issue while maintaining the security of the PostgreSQL database?
2. Are there any specific configuration settings I should adjust in the PostgreSQL connector?
3. Is there an alternative approach to implement WriteBack functionality with a secure PostgreSQL database?

Any guidance or best practices would be greatly appreciated. Thank you in advance!

Best regards,