Microsoft Connector for DB2 is an API app for connecting applications through Azure App Service to resources stored in an IBM DB2 database.

Connector supports a set of connector-specific Web API operations and industry-standard Open Data Protocol (OData) operations that are accessed with HTTP GET and POST verbs. Connector Web API operations consist of two types: administration and database.

• Connector Web API database operations include processing parameterized and non-parameterized Structured Query Language statements: INSERT, UPDATE, DELETE, SELECT, and custom-defined statements.
• Connector industry-standard OData RESTful APIs include processing parameterized and non-parameterized Structured Query Language SELECT statements.

Connector includes a Microsoft Client for DRDA supporting industry-standard Distributed Relational Database protocol and formats, defined for use by DB2 clients and servers, to connect to remote DB2 server computers across a TCP/IP network connection. Client supports DB2 for z/OS V11 and V10; DB2 for i V7R2 and V7R1; DB2 for Linux, UNIX and Windows V10.5 and V10.

Connector supports Azure hybrid connections to on-premises DB2 servers using the Azure Service Bus Relay.

Connector is compatible with logic app actions (SELECT, INSERT, UPDATE, DELETE).

Connector supports Swagger representation of Connector RESTful APIs, making it easy to understand the command syntax, parameters, and examples for using Connector Web and OData APIs.