Not able to connect to azure postgres db from azure data factory when SSL is enabled

Question

I'm new to Azure Data factory and i'm trying to create data set that connects to azure postgres db where SSL is enabled, but i get the below error, any idea how to solve this error without disabling SSL on postgres.

when i try to add sslmode=Allow to connection parameters, i get this error

set ssl mode to required, not allowed. set min ssl to tls 1.2 on pg side. — Cninroh, Jun 13 '22 at 22:16

Steve Johnson · Answer 1 · 2021-03-17T06:24:04.233

0

You need to select EncryptionMethod option in link service. As MSDN shows,

Update:

I haven't met your error. I can connect successfully via integration run time. The following is my setting, you can have a try.

In Azure Database for PostgreSQL:

Link service:

edited Mar 17 '21 at 06:24

answered Mar 16 '21 at 03:02

Steve Johnson

8,057
1
6
17

Thanks for the response , i did this and created private endpoint as well as custom integration run time, and now i'm getting time out errors – user2249979 Mar 16 '21 at 11:03
@user2249979 I updated my answer. Hope it can help you. – Steve Johnson Mar 17 '21 at 06:24
I have different configuration for Azure Database for PostgreSQL, where public access is denied – user2249979 Mar 17 '21 at 08:52

Not able to connect to azure postgres db from azure data factory when SSL is enabled

1 Answers1