Forum Discussion

thebroberts's avatar
thebroberts
Frequent Visitor
3 years ago

Unable to connect to Postgres server requiring SSL

I am trying to connect to Azure Database for PostgresSQL. The server requires a secure connection. I have "Encrypted connection" set to Encrypted, but when I attempt to connect to copy data I receive...
pipelines
thebroberts's avatar
thebroberts
Frequent Visitor
3 years ago

Hello - 

 

In "old" Azure Data Factory, I have a parameterized linked service connecting to Azure Database for PostgreSQL:

 

I use this linked service in a pipeline to copy data to ADLSg2.

 

I am trying to recreate using the new Pipelines in Fabric. The Postgres connector does not show the same configuration options as ADF:

No matter how I set the "Encrypted connection" drop-down, I cannot connect, and get an error about SSL:

`28000: SSL connection is required. Please specify SSL options and retry.`

 

I did also try this in Dataflows 2.0. I was able to make the connection and import some PostgreSQL, but we would like to use Pipelines as we do today.