With the IBM® Db2® connector, you can use commands in a chain to perform structured query language (SQL) operations in a Db2 relational database. For example, with this connector, you can:
- Execute SQL commands, including a
- Retrieve details about a table in Db2
- Insert records in the Db2 database
To enable the connection to IBM Db2, the connector uses Java database connectivity (JDBC), secured with basic username and password authentication. To set up the connector, you'll need:
- A designated integration user set up in IBM Db2 for the connector
- The integration user's username and password
- The JDBC connection's URL, such as
- To connect to an on-premise instance of IBM Db2, a GroundRunner for the connection
Note: To connect to a cloud instance of IBM Db2, use the default CloudRunner.
Set Up the IBM Db2 Connector
- From Chains, click Connections and Add Connection .
- Under BizApp Connection, select IBM Db2 and the runner to use with the connection.
- Under Basic Info, enter a unique name and description to help identify the connection.
- Under Properties, enter the connector's details:
Property Details Username Enter the username of the connector's IBM Db2 integration user. Password Enter the password for the Username property. Connection URL Enter the URL for the JDBC connection with any optional properties appended with a semicolon, such as
Note: Typically, the port for IBM Db2 is
50000; however, this may be different for your environment. To use the default port for the database server, omit the
portvalue from the connection URL.
Note: All sensitive credentials are automatically encrypted and stored at Advanced Encryption Standard (AES)-256 encryption. For security purposes, avoid including user credentials as optional properties within the Connection URL input.
- Select the environments to use with the connection, and click Save.
- To test the connection, create and run a chain with the connector's Get Table Definition command, and verify it returns a valid output.
If the connection to IBM Db2 fails:
- Verify the integration user's authentication credentials
- Check the URL for the JDBC connection, including its server and port
If the connection fails to perform a command, verify its inputs—such as its SQL syntax or table—are valid.