#Db2 json query example how to#

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.įor more information about the network security mechanisms and options supported by Data Factory, see Data access strategies. 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. If your data store is a managed cloud data service, you can use the Azure Integration Runtime. 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. To troubleshoot DB2 connector errors, refer to Data Provider Error Codes. It utilizes the DDM/DRDA protocol.ĭB2 connector is built on top of Microsoft OLE DB Provider for DB2. 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. ① Azure integration runtime ② Self-hosted integration runtimeįor a list of data stores that are supported as sources or sinks by the copy activity, see the Supported data stores table.

This DB2 connector is supported for the following capabilities: Supported capabilities It builds on the copy activity overview article that presents a general overview of copy activity.

#Db2 json query example how to#

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