Share via

Connectors or replicators available for IBM DB2- AS400 with Microsoft for Synapse

Hanuman Devineni 31 Reputation points
2023-09-01T13:21:16.6466667+00:00

Is Microsoft offering Replicators to copy the data from IBM DB2 to SQL Server or Synapse

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,561 questions
Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 83,066 Reputation points Microsoft Employee
    2023-09-04T06:53:17.42+00:00

    @Hanuman Devineni - Thanks for the question and using MS Q&A platform.

    From the official Microsoft document, specifically, this DB2 connector supports the following IBM DB2 platforms and versions with Distributed Relational Database Architecture (DRDA) SQL Access Manager (SQLAM) version 9, 10 and 11. It utilizes the DDM/DRDA protocol.

    • 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

    This article Copy data from DB2 using Azure Data Factory or Synapse Analytics outlines how to use the Copy Activity in Azure Data Factory and Synapse Analytics pipelines to copy data from a DB2 database.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest