question

NathanCarns-0092 avatar image
0 Votes"
NathanCarns-0092 asked PRADEEPCHEEKATLA-MSFT edited

Ingest from local MariaDB server to Synapse

Hi.

How would I got and connect Synapse to an instance of MariaDB Server I'm running locally? I installed MariaDB server but when I want to connect to Synapse, the connection fails. I tried researching what to exactly put in the required fields when creating the connection but I couldn't find anything on it.

I'm assuming the Server Name should be localhost, port should be 3306, Database Name should any DB I create, User name should be root (I tried my name as well but it didn't work), and my password. Connection fails.

Any idea of what I should do? Should I configure something locally first? Is there somewhere I can extract the connection info from MariaDB Server?


Thanks.







azure-data-factoryazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT edited

Hello @NathanCarns-0092,

Thanks for the question and using MS Q&A platform.

When you say the connection fails- could you please share the complete error message or the screenshot of the error message which you are experiencing?

Prerequisites:

Supported: This connector currently supports MariaDB of version 10.0 to 10.2.

If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

Steps to connect local MariaDB server to Synapse/ADF:

Step1: Gather the details of the local MariaDB:

112021-image.png

Step2: Create the MariaDB linked service.

Note: You can use the server name as localhost or the Hostname of the local machine, port:3306, DBName, UserName and password.

111977-image.png

Step3: Successfully create the dataset from local MariaDB linked service.

111910-adf-mariadb.gif

For more details, refer to Copy data from MariaDB using Azure Data Factory.

Hope this helps. Do let us know if you any further queries.


Please "Accept the answer" if the information helped you. This will help us and others in the community as well.


image.png (56.9 KiB)
image.png (129.7 KiB)
adf-mariadb.gif (1.4 MiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.