97
Views
3
Comments
Solved
Issue with PostgreSQL Configuration Parameters in Integration Studio
Service Studio Version
11.54.68 (Build 63426)
Platform Version
11.29.0 (Build 43552)

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:

  1. When I use Basic Configuration, I get the error:

    • "Connection String test failed: XX000: connection is insecure (try using sslmode=require)" However, there's no option to set sslmode in Basic Configuration, so I switched to Advanced Configuration.
  2. In Advanced Configuration, I am asked to fill in the Configuration Parameters field. The description provided is:

    • "Configuration parameters must be separated by a semi-colon ‘;’. When configured, username and password are automatically added to the generated connection string. Configuration example: DataSource=<db>;Integrated Security=no"
  3. I tried to input parameters that fit this description, but I keep encountering the error:

    • "Connection String test failed: Keyword not supported: datasource Parameter name: keyword"

Questions:

  • Why is the DataSource keyword not supported in the Configuration Parameters field?
  • Can you provide an explanation or a correct example of how to format the Configuration Parameters for a PostgreSQL connection?

Screenshots:

Any guidance or examples would be greatly appreciated.

Thank you!



2019-01-07 16-04-16
Siya
 
MVP
Solution

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

2024-07-30 09-53-03
Toffu

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!

2024-03-22 09-17-23
Chandra Vikas Sharma
2019-01-07 16-04-16
Siya
 
MVP
Solution

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

2024-07-30 09-53-03
Toffu

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!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.