PostgreSQL Connector vs Postgres Federated SSL Error

I have two accounts setup:

  1. the native PostgreSQL Connector
  2. the Federated PostgreSQL connector

I can successfully query and retrieve data from the Federated PostgreSQL connector but when I put the same credentials into the native PostgreSQL Connector and try to run a custom query against it, I get the error:

Error setting up SQL connection. The server does not support SSL.

I have configured the native PostgreSQL connector field of "Certificate Type" to "No certificate." I wouldn't know where to find the certificate if I had one. Regardless, it doesn't make sense that the Federated PostgreSQL connector doesn't ask for certificate details and connects just fine while the native PostgreSQL connector chokes.

Any thoughts or guidance?

Tagged:

Answers

  • I'd recommend logging a ticket with Domo Support for them to look into their connector.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**