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
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
Get tables
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
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
Definitions
Table
| Name | Path | Type | Description |
|---|---|---|---|
|
Name
|
Name | string | |
|
DisplayName
|
DisplayName | string |
TablesList
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value | array of Table |