Connection to a 3rd Party MySQL DB in ADF with SSL Keys and Certificates

Question

Connection to a 3rd Party MySQL DB in ADF with SSL Keys and Certificates

Siva B 121

I am trying to set up a connection to the MySQL database from ADF with a provided SSL Keys and client certificates.
I have 3 keys to upload for connection but can't figure where and how to upload and even the documentation is not clear.

There are no answers on the internet of how to do it and the current documentation provides only "specify the full path" statement, which is not enough. what is the full path.
It doesn't even have Azure Key Vault option there.

This is a priority and Please suggest on how to use the SSL keys and certs in ADF MySQL connector. If it is not supported, please suggest a workaround. It's really important for us to connect to that MySQl DB at any cost.

ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-02T09:34:37.197+00:00

Hi @Siva B ,

Thanks for posting question on Microsoft Q&A platform.

As I understand your ask, you want to access MySQL using Self Hosted Integration runtime by 3 keys.
You need to logon the machine where SHIR is installed and put the .pem file to local folder. Then go back to ADF portal and add the property in "Additional connection properties" section to specify the cert path connector-mysql

Another link on additional connection string properties: linked-service-adf-azure-mysql

I am also checking with my internal team with this option. Will update you accordingly.

Thanks for your patience.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-06T06:42:50.96+00:00

Hi @Siva B ,

Thanks for your patience.

We are checking internally and will update on the same.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-21T16:53:52.91+00:00

Hi @Siva B ,

Apologies for the inconvenience.

I am yet to get response from the internal team regarding clear addition of option in ADF linked service for addition of SSL keys and certificates.

I will keep you posted as soon as I receive a timeline.

Thanks for your patience.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-10-04T05:38:50.447+00:00

Hi @Siva B ,

Many thanks for your persistent patience.

As discussed with internal team about the option in ADF linked service for addition of SSL keys and certificates, it is stated that

Because of ADF security, we want custom certificates to be installed by User and take responsibility for it in shared responsibility model.

It is hence recommended putting right certificates on SHIR then connecting to 3rd party MySQL as stated in above comment.

If it is an urgent matter, and you need to know how to install certificates locally and connect to MySQL, I request you to open a support ticket.
Here is how you can do that: how-to-create-azure-support-request

Please let us know if you are able to raise support ticket, do reply in case of any issue.

Anticipating your reply. Thanks!

ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-02T09:34:37.197+00:00

Hi @Siva B ,

Thanks for posting question on Microsoft Q&A platform.

As I understand your ask, you want to access MySQL using Self Hosted Integration runtime by 3 keys.
You need to logon the machine where SHIR is installed and put the .pem file to local folder. Then go back to ADF portal and add the property in "Additional connection properties" section to specify the cert path connector-mysql

Another link on additional connection string properties: linked-service-adf-azure-mysql

I am also checking with my internal team with this option. Will update you accordingly.

Thanks for your patience.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-06T06:42:50.96+00:00

Hi @Siva B ,

Thanks for your patience.

We are checking internally and will update on the same.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-09-21T16:53:52.91+00:00

Hi @Siva B ,

Apologies for the inconvenience.

I am yet to get response from the internal team regarding clear addition of option in ADF linked service for addition of SSL keys and certificates.

I will keep you posted as soon as I receive a timeline.

Thanks for your patience.
ShaktiSingh-MSFT 5,681 Reputation points Microsoft Employee

2022-10-04T05:38:50.447+00:00

Hi @Siva B ,

Many thanks for your persistent patience.

As discussed with internal team about the option in ADF linked service for addition of SSL keys and certificates, it is stated that

Because of ADF security, we want custom certificates to be installed by User and take responsibility for it in shared responsibility model.

It is hence recommended putting right certificates on SHIR then connecting to 3rd party MySQL as stated in above comment.

If it is an urgent matter, and you need to know how to install certificates locally and connect to MySQL, I request you to open a support ticket.
Here is how you can do that: how-to-create-azure-support-request

Please let us know if you are able to raise support ticket, do reply in case of any issue.

Anticipating your reply. Thanks!

Connection to a 3rd Party MySQL DB in ADF with SSL Keys and Certificates

Activity