Unable to connect to Epicor CMS DB2 with Azure Data Factory

Robert Perry 1 Reputation point
2022-04-13T13:35:23.84+00:00

Hello,

I am moving from an Azure VM(with SQL Server) to an Azure SQL server. My source systems are varied including SQL server, SAP, Epicor CMS DB2, etc. Using Data Factory I have no problem connecting to any of my source systems that are on SQL Server. The problem arises when I try to connect to any non-SQL Server source such as DB2. All of my source systems are able to be brought in, via SSIS, onto the old environment.

They're all part of the same Vnet:

192772-connections.png

here is the connection we're using in SSIS:
192699-ssis-cms-connection.png

Any help would be appreciated.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
{count} votes