azuremariadbazure-data-factorymariadb-10.4

Connection to Maria DB from ADF is not getting succeeded

I am trying to connect with on-premise MariaDB from the Azure Data Factory.

The IPs are whitelisted from the MariaDB side with self-hosted IR and when we try to connect to the database it throws the timed-out error.

Any idea what could be wrong here? Is there any detailed documentation regarding the MariaDB Connection from ADF?

enter image description here

enter image description here enter image description here Tried with port 22 as well as default port 3306.

I had gone through the MS Document and followed the steps to get connected. https://learn.microsoft.com/en-us/azure/data-factory/connector-mariadb?tabs=data-factory

Below is the Telnet result from the IR enter image description here

Does the whitelisting happen properly and Connection is fine from IR? If yes what could have gone wrong here?

Solution 
  • ERROR [08001] [Microsoft][MariaDB] (1004) The connection has timed out while connecting to server: **** at port: 22.

    As per this, the default port for MariaDB is 3306. You have mentioned 22 as the port number. That may be the reason for getting the above error. Once you replace 3306 instead of 22 in the port number, the linked service test connection will be tested successfully, as shown below:

    Enter image description here