Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,171 questions
Unable to connect to Epicor CMS DB2 with Azure Data Factory
Robert Perry
1
Reputation point
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:
here is the connection we're using in SSIS:
Any help would be appreciated.
{count} votes
-
Saurabh Sharma 17,366 Reputation points Microsoft Employee
2022-04-14T23:53:48.087+00:00 Hi @Robert Perry ,
Thanks for using Microsoft Q&A !!
If I understand correctly, you are not able to connect to IBM DB2 server from Azure Data Factory using DB2 connector.
You might be getting this error DB2 version is different from the supported ones by ADF DB2 Connector as mentioned over here.
As per the above documentation DB2 connector supports the following IBM DB2 platforms -- IBM DB2 for z/OS 12.1
- IBM DB2 for z/OS 11.1
- IBM DB2 for z/OS 10.1
- IBM DB2 for i 7.3
- IBM DB2 for i 7.2
- IBM DB2 for i 7.1
- IBM DB2 for LUW 11
- IBM DB2 for LUW 10.5
- IBM DB2 for LUW 10.1
Can you please check the version of the IBM DB2 platform you are using?
If that's not the case, could you please share DB2 version which you are using.Thanks
Saurabh -
Robert Perry 1 Reputation point
2022-04-18T13:57:03.157+00:00 Thanks Saurabh
That may be the case, but then why can't I connect to SAP?
Edit 4/18/2022 10:50 AM CST:
Our Epicor CMS system is on an IBM DB2 V7R2M0, aka IBM i 7.2
-
Saurabh Sharma 17,366 Reputation points Microsoft Employee
2022-04-22T21:29:58.053+00:00 Hi @Robert Perry ,
ok, if that's the case, then I suggest you to please open a support ticket so that an engineer can look into your environment. Please let me know if you have any limitations opening a support ticket and I will help you providing a one-time free support ticket.Thanks
Saurabh
Sign in to comment