Hello,
I'm currently working on connecting a PostgreSQL database as an external database using Integration Studio in OutSystems. I have successfully connected the same PostgreSQL database using Integration Builder, but I'm facing issues when trying to do so in Integration Studio.
Problem Details:
When I use Basic Configuration, I get the error:
In Advanced Configuration, I am asked to fill in the Configuration Parameters field. The description provided is:
I tried to input parameters that fit this description, but I keep encountering the error:
Questions:
Screenshots:
Any guidance or examples would be greatly appreciated.
Thank you!
Please replace 'DataSource' with 'Host' so that the connection string looks like
user id=bookstore_owner;password=<hidden>;Host=ep-hidden-tree-a1Ixjw1h.ap-southeast-1.aws.neon.tech;Database=bookstore;sslmode=require;
Reference : https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
Hi Siya,
Thank you so much for your response and for providing the correct path for the configuration parameters. I really appreciate your help.
Your suggestion to replace "DataSource" with "Host" worked perfectly, and I was able to pass the connection test with the following configuration parameters:
Host=ep-hidden-tree-a1lxjw1h.ap-southeast-1.aws.neon.tech;Database=bookstore; SSLMode=Prefer;
Additionally, through some attempts, I found that "DataSource" can be replaced with either "Host" or "Server," and setting of SSL should be "SSLMode=Prefer" even though the system message suggested using "SSLMode=require".
Your guidance was incredibly helpful in resolving this issue. Thanks again for your help!
Hi Toffu,
you can refer below post.
https://www.outsystems.com/forums/discussion/14992/the-postgresql-database-connector-by-ardoric/
thanks
cv