Unable to connect to Epicor CMS DB2 with Azure Data Factory

Robert Perry 1 Reputation point


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:


here is the connection we're using in SSIS:

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