question

RobertPerry-3602 avatar image
0 Votes"
RobertPerry-3602 asked SaurabhSharma-msft commented

Unable to connect to Epicor CMS DB2 with Azure Data Factory

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
connections.png (101.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RobertPerry-3602,

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

0 Votes 0 ·

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

0 Votes 0 ·

Hi @RobertPerry-3602,
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

0 Votes 0 ·

0 Answers