Connect DB2/Maximo from azure synapse

Chandrashekar S 11 Reputation points
2022-07-12T06:50:20.957+00:00

Hello All,

I want to import data from DB2(Maximo) using azure synapse. Getting error while creating linked services. Maximo is hosted on cloud so Azure IR might suffice. Appreciate any kind of help at the earliest.

219727-image.png

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,103 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,041 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 37,051 Reputation points Microsoft Employee
    2022-07-13T09:24:52.987+00:00

    Hi @Chandrashekar S ,

    Thank you for posting query in Microsoft Q&A Platform.

    It looks like issue related to having proper integration runtime to connect with DB2 store.

    If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

    If your data store is a managed cloud data service, you can use the Azure Integration Runtime. If the access is restricted to IPs that are approved in the firewall rules, you can add Azure Integration Runtime IPs to the allow list.

    You can also use the managed virtual network integration runtime feature in Azure Data Factory to access the on-premises network without installing and configuring a self-hosted integration runtime.

    For more information about the network security mechanisms and options supported by Data Factory, see Data access strategies.

    Hope this helps. Please let us know how it goes.

    ---------
    Please consider hitting Accept Answer button. Accepted answers help community as well.