Is their any feasibility to Accessing on premise Maria DB via SSL-based authentication in ADF

Question

Is their any feasibility to Accessing on premise Maria DB via SSL-based authentication in ADF

Kiran Kumar Maddipati 45

Is their any feasibility to Accessing on-premise Maria DB via SSL-based authentication in ADF or is it possible to connect directly using ADF Maria DB connector and SHIR

Harishga 6,005 Reputation points Microsoft External Staff

2023-12-19T07:09:46.0066667+00:00

Hi@Kiran Kumar Maddipati
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Harishga 6,005 Reputation points Microsoft External Staff

2023-12-20T07:37:32.74+00:00

Hi@Kiran Kumar Maddipati
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Kiran Kumar Maddipati 45 Reputation points

2024-06-20T08:09:49.37+00:00

Hi @Harisha G
is there any way to connect without using SHIR

Accepted answer

0 additional answers

Your answer

Harishga 6,005 Reputation points Microsoft External Staff

2023-12-19T07:09:46.0066667+00:00

Hi@Kiran Kumar Maddipati
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Harishga 6,005 Reputation points Microsoft External Staff

2023-12-20T07:37:32.74+00:00

Hi@Kiran Kumar Maddipati
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Kiran Kumar Maddipati 45 Reputation points

2024-06-20T08:09:49.37+00:00

Hi @Harisha G
is there any way to connect without using SHIR

Answer 1

Hi@Kiran Kumar Maddipati
Welcome to Microsoft Q&A platform and thanks for posting your question here.

Yes, it is possible to access an on-premises MariaDB database via SSL-based authentication in Azure Data Factory. You can use the Self-hosted Integration Runtime to connect to the on-premises MariaDB database.

To connect to the on-premises MariaDB database via SSL-based authentication, you need to obtain the SSL certificate and configure the connection string accordingly. You can download the SSL certificate from the MariaDB server and save it to a local drive.

Need to configure the connection string in the SHIR to include the SSL certificate path and other SSL-related parameters. You can refer to the Azure documentation on [how to configure SSL connectivity in your application to securely connect to Azure Database for MariaDB.

Once you have configured the connection string, you can use the ADF MariaDB connector to connect to the on-premises MariaDB database via the SHIR.

Reference links
https://learn.microsoft.com/en-us/azure/mariadb/howto-configure-ssl
https://learn.microsoft.com/en-us/azure/data-factory/connector-mariadb?tabs=data-factory

I hope this helps! Let me know if you have any further questions.

Share via

Is their any feasibility to Accessing on premise Maria DB via SSL-based authentication in ADF

0 additional answers

Your answer