Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article outlines how to use the copy activity in a data pipeline to copy data from IBM Db2 database.
Supported configuration
For the configuration of each tab under copy activity, go to the following sections respectively.
General
For General tab configuration, go to General.
Source
The following properties are supported for IBM Db2 database under the Source tab of a copy activity.
The following properties are required:
Connection: Select an IBM Db2 database connection from the connection list. If the connection doesn't exist, then create a new IBM Db2 database connection.
Additional connection properties: Specify additional connection properties which will be used in IBM Db2 database connection to set advanced options. Additional connection properties are provided as a dictionary of key-value pairs, for example, Package collection. For more information, see this article.
Use query: Select Table or Query.
If you select Table:
- Table: Specify the name of the table in the IBM Db2 database to read data. Select the table from the drop-down list or select Enter manually to enter the schema and table name.
If you select Query:
Query: Specify the custom SQL query to read data.
Under Advanced, you can specify the following fields:
- Additional columns: Add more data columns to store source files' relative path or static value. Expression is supported for the latter.
Mapping
For Mapping tab configuration, go to Configure your mappings under mapping tab.
Settings
For Settings tab configuration, go to Configure your other settings under settings tab.
Table summary
The following tables contain more information about a copy activity in an IBM Db2 database.
Source information
| Name | Description | Value | Required | JSON script property |
|---|---|---|---|---|
| Connection | Your connection to the source data store. | < your IBM Db2 database connection > | Yes | connection |
| Additional connection properties | Additional connection properties, provided as a dictionary of key-value pairs, for example, Package collection. For more information, see this article. | • Name • Value |
No | connectionProperties |
| Use query | The way to read data from IBM Db2 database. Apply Table to read data from the specified table or apply Query to read data using queries. | • Table • Query |
No | / |
| For Table | ||||
| schema name | Name of the schema. | < your schema name > | No | schema |
| table name | Name of the table. | < your table name > | No | table |
| For Query | ||||
| Query | Use the custom SQL query to read data. | < SQL queries > | No | query |
| Additional columns | Add additional data columns to store source files' relative path or static value. Expression is supported for the latter. | • Name • Value |
No | additionalColumns: • name • value |