Share via


DB2

Microsoft Connector for DB2 integrates Azure applications with resources stored in an IBM DB2 database. Connector supports SELECT, INSERT, UPDATE, and DELETE operations.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions and Integration Service Environments (ISEs) except the following:
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
     -   US Department of Defense (DoD)
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://www.ibm.com/analytics/db2
Privacy policy https://www.ibm.com/privacy

Known issues and limitations

CCSID 65535 data returned as binary

Note that accessing CCSID 65535 data will be returned as binary. The CCSID scheme is documented here and documents the meaning of CCSID 65535 on Page 38, Figure 11.

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Shareable

Default

Applicable: All regions

Parameters for creating connection.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
Server string Server True
Database string Database True
Authentication string Authentication type
Username securestring Username True
Password securestring Password True
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Delete row

Deletes a row from a DB2 table

Get row

Retrieves a single row from a DB2 table

Get rows

Retrieves rows from a DB2 table

Get tables

Retrieves tables from a DB2 database

Insert row

Inserts a new row into a DB2 table

Update row

Updates an existing row in a DB2 table

Delete row

Deletes a row from a DB2 table

Parameters

Name Key Required Type Description
Table name
table True string

Name of DB2 table

Row id
id True string

Unique identifier of the row to delete

Get row

Retrieves a single row from a DB2 table

Parameters

Name Key Required Type Description
Table name
table True string

Name of DB2 table

Row id
id True string

Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Retrieves rows from a DB2 table

Parameters

Name Key Required Type Description
Table name
table True string

Name of DB2 table

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By
$orderby string

An ODATA orderBy query for specifying the order of entries

Skip Count
$skip integer

Number of entries to skip (default = 0)

Maximum Get Count
$top integer

Maximum number of entries to retrieve (default = 256)

Select Query
$select string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get tables

Retrieves tables from a DB2 database

Returns

Body
TablesList

Insert row

Inserts a new row into a DB2 table

Parameters

Name Key Required Type Description
Table name
table True string

Name of DB2 table

Row
item True dynamic

Row to insert into the specified table in DB2

Returns

The outputs of this operation are dynamic.

Update row

Updates an existing row in a DB2 table

Parameters

Name Key Required Type Description
Table name
table True string

Name of DB2 table

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Name Path Type Description
Name
Name string
DisplayName
DisplayName string

TablesList

Name Path Type Description
value
value array of Table