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 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

Operation ID:

DeleteItem

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

Operation ID:

GetItem

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

Operation ID:

GetItems

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

Operation ID:

GetTables

Retrieves tables from a DB2 database

Returns

Body

TablesList

Insert row

Operation ID:

PostItem

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

Operation ID:

PatchItem

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