Share via

Copying Data from IBM DB2 to Azure SQL, using Data Factory

Jonas Emanoel 1 Reputation point
2022-09-08T21:41:38.727+00:00

Hi everyone, hope you are doing fine out there!

I've been trying to create a link between an IBM DB2 database (client's database) to Azure Data Factory so I can copy data from the IBM DB2 to my Azure SQL Database.

I found an article related to this connector-db2 but unfortunately, I can't connect to the database. It's showing an error: 5v9tvLx

Note that I have the server name, the port, the database name, the password...

Just to mention:
When I connect to their database using an WinSql product, for example, I need to connect to their VPN on my computer first, and then connect to their database.

Does anyone know what I could do to solve it?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Takahito Iwasa 4,851 Reputation points MVP Volunteer Moderator
    2022-09-08T22:41:45.917+00:00

    Hi, @Jonas Emanoel

    Where are you hosting your IBM DB2?
    I think you need to check if the integration runtime can access it first.

    The documentation below requires network reachability to the IBM DB2 instance when using the Azure Integration Runtime. In that case, no DB2 driver is required.
    For certain private networks, you can also use a self-hosted integration runtime.

    https://learn.microsoft.com/en-us/azure/data-factory/connector-db2?tabs=data-factory

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.