This section contains details for IBM Db2 connections.General information
| Field | Description |
|---|---|
| Data source | IBM Db2 |
| Supported versions | 4.27.25 |
| Connection string | jdbc:db2:// |
| Packaged? |
|
| Certified? |
|
| Supported features | |
Estimate job |
|
Analyze data |
|
Schedule |
|
| Processing capabilities | |
Pushdown |
|
Spark agent |
|
Yarn agent |
|
Parallel JDBC |
|
| Java Platform version compatibility | |
JDK 8 |
|
JDK 11 |
|
Yes
No
Minimum user permissions
In order to bring your Db2 data into Collibra Data Quality & Observability, you need the following permissions.
- Read access on your Db2 tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
Recommended and required connection properties
| Required | Connection Property | Type | Value |
|---|---|---|---|
| Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Connection URL | String | The connection string path of your Db2 connection. When referring to the example below, replace the Example |
| Driver Name | String | The driver class name of your Db2 connection.
|
| Port | Integer | The port number to establish a connection to the datasource. The default port is |
| Limit Schemas | Option | Allows you to manage usage and restrict visibility to only the necessary schemas in the Explorer tree. See Limiting schemas to learn how to limit schemas from the Connection Management page. Note When you include a restricted schema in the query of a DQ Job, the query scope may be overwritten when the job runs. While only the schemas you selected when you set up the connection are shown in the Explorer menu, users are not restricted from running SQL queries on any schema from the data source. |
| Source Name | String | N/A |
| Target Agent | Option | The Agent that submits your Spark job for processing. |
| Auth Type | Option | The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
| Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
Authentication
Select an authentication type from the dropdown menu. The options available in the dropdown menu are the currently supported authentication types for this data source.
| Required | Field | Description |
|---|---|---|
| Username | The username of your Db2 account. |
| Password | The password of your Db2 account. |
| Script | The file path that contains the script file that the password manager uses to interact with and authenticate a user account. Example /tmp/keytab/db2_pwd_mgr.sh |
| Param $1 | Optional. An additional parameters to authenticate your Db2 connection. |
| Param $2 | Optional. An additional parameter to authenticate your Db2 connection. |
| Param $3 | Optional. An additional parameter to authenticate your Db2 connection. |
Limitations
Because the DATE_TRUNC does not exist in Db2 for z/OS operating systems, the date visualization graph under the Time Slice component on the Select rows step in Explorer will not load.