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."
Asked
Active
Viewed 273 times
2 Answers
0
Good day sir!
To tell you the truth that I never met your problem, but I google 'Verify hostname and port number', and got some message that I thought may do some help.
Here is the link:https://knowledgebase.progress.com/articles/Article/9334
Wish you to solve your problem soon.

wanttoh
- 637
- 1
- 5
- 9
0
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.

Daxesh Radadiya
- 73
- 2
- 9