Azure Synapse ADF connection to DB2 using SSL certificate

Question

Azure Synapse ADF connection to DB2 using SSL certificate

Charles Thivierge 4,171

We have a Synapse workspace and we need to connect to DB2 (version 11.5.9) using SSL certificate through SelfHosted Integration Runtime.

From the SelfHosted IR, i have installed DBeaver to test the connection to DB2 and everything work well. But from ADF it's not working. Is there any procedure to create the Linked Service to connect using a SSL certificate ?

Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator

2025-03-27T19:06:33.6466667+00:00

@Charles Thivierge

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.
Charles Thivierge 4,171 Reputation points

2025-03-28T09:53:49.9333333+00:00

Hi, thanks for your answer. It works! :)

By the way, on the Self-Hosted Integration Runtime VM, the only thing we had to do is to add the slef-signed certificate into the Trusted Root Certificate Authority
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator

2025-03-28T16:46:20.81+00:00

@Charles Thivierge

Glad to know that the below suggestion helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator

2025-03-27T19:06:33.6466667+00:00

@Charles Thivierge

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.
Charles Thivierge 4,171 Reputation points

2025-03-28T09:53:49.9333333+00:00

Hi, thanks for your answer. It works! :)

By the way, on the Self-Hosted Integration Runtime VM, the only thing we had to do is to add the slef-signed certificate into the Trusted Root Certificate Authority
Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator

2025-03-28T16:46:20.81+00:00

@Charles Thivierge

Glad to know that the below suggestion helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

@Charles Thivierge

To connect Azure Data Factory to DB2 using an SSL certificate through a Self-Hosted Integration Runtime, you need to follow these steps to create a Linked Service:

Install the SSL Certificate - Ensure that the SSL certificate is installed on the Self-Hosted Integration Runtime machine. The certificate must be a publicly trusted X509 v3 certificate.

Create the Linked Service - In your Azure Data Factory or Synapse workspace, navigate to the "Manage" tab and select "Linked Services." Click on "New" and search for the DB2 connector.

Fill in the required properties:

Server - Specify the DB2 server name and port (e.g., server:port).
Database - Provide the name of the DB2 database.
Authentication Type: Set this to "Basic."
Username - Enter the username for the DB2 database.
Password - Enter the password, ensuring to mark it as a SecureString or reference a secret stored in Azure Key Vault.
Certificate Common Name - If using SSL, provide the common name for the certificate.

Test the Connection - After configuring the Linked Service, test the connection to ensure everything is set up correctly.

Make sure that the Self-Hosted Integration Runtime is configured to trust the SSL certificate, as this is crucial for establishing a secure connection.

For more details, please refer the following documentations:

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.

Chandra Boorla 14,510 Reputation points Microsoft External Staff Moderator

2025-04-01T17:14:54.75+00:00

@Charles Thivierge

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure Synapse ADF connection to DB2 using SSL certificate

0 additional answers

Your answer