Topic
When setting up a connection between Nintex Apps for Salesforce and an external PostgreSQL database, there are a few prerequisites to be aware of.
Documentation here: https://docs.skuid.com/latest/appdev/en/data/sq
Prerequisites: https://docs.skuid.com/latest/appdev/en/data/sql/#prerequisites
Instructions
If you encounter this error when testing your connection:
Skuid could not connect to the Data Source.
Please check all configuration values and make sure the Data Source can be accessed from Skuid's web servers in your region.
{"message":"JWT Authorization error. Error: x509: inner and outer signature algorithm identifiers don't match"}
you may need to Create and add a JWT signing certificate.
After you have completedc the step above, if you encounter this error when testing your connection:
Unsuccessful
Nintex Apps did not receive an expected response from the connection. Please check all configuration values and make sure the connection can be accessed from the Nintex Apps web servers in your region. Error making proxy request to connection
you may need to allowlist the ip addresses specified on the connection's configuration page.
Once you've done both above steps, if you encounter this or other errors:
Nintex Apps did not receive an expected response from the connection.
Please check all configuration values and make sure the connection can be accessed from the Nintex Apps web servers in your region.
You will need to review the SSL requirements for your database and ensure they align with the SSL settings you have configured in the Nintex Apps datasource connection. Some databases will need this enabled, and others need it disabled.
Additional Information
Troubleshooting other common SQL issues: https://docs.skuid.com/latest/appdev/en/data/sql/#troubleshooting
Data Source Objects: https://docs.skuid.com/latest/appdev/en/data/sql/#data-source-object-configuration