How to Connect MariaDB to Fabric via a data pipeline

[ScottValentine]

Here is how you would connect MariaDB to Microsoft Fabric, I initially tried this with ADF using the self-hosted integration runtime, where I connected to MariaDb on an Azure VM.  Doing this gave me the choice of having the MariaDB connector out of the box. 

Unfortunately, Fabric does not have this option, to get around this I installed the data gateway on my Azure VM hosting MariaDB, you can follow install instructions from here, How to install a data gateway

To set up a data pipeline with MariaDB from Fabric I had to set up an ODBC connection

Then enter the details of the MariaDB using a ODBC string with the version of driver on the MariaDB hosted VM

e.g. DRIVER={MariaDB ODBC 3.2 Driver};SERVER=172.16.0.11;PORT=3306;DATABASE=MariaDB;

Select the on-premise data gateway and authentication method. 

You should now be able to connect to MariaDB and pull in your desired tables or files via a data pipeline

[Anonymous]

Hi @ScottValentine ,

Thank you very much for sharing!

What you have shared about how to connect to MariaDB data source using ODBC connector in Fabric Data Pipline is very helpful for us.

Please mark a reply that you find helpful. Once you mark your post, more people will be able to see what you have shared.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.