I wanted to connect to Yellowbrick(YB) database (Postgresql) as a source in the Azure Data Factory. The YB instance is on the cloud. And I had set the encryption to 'No Encryption'. In the server name, if I pass the domain name, then the error I get is "Socket closed." If I pass IP address, the error I get is "Verify hostname and port number."
Okay. So my Yellowbrick database is an on-prem database. So, all I did is created a Self-Hosted Integration-Runtime for my database location and then used it in the data factory and it worked fine.