The Db2 data source provided by Alibaba Cloud DataWorks is a data hub that allows you to read data from or write data to a Db2 database by using Db2 Reader or Db2 Writer. Before you read data from or write data to a Db2 database, you must add the Db2 database to DataWorks. Then, you can use the codeless user interface (UI) or code editor to configure a data sync node to read data from or write data to the Db2 database. This topic describes how to add a Db2 data source.

Prerequisites

A resource group for Data Integration is created to run the data sync node.

You must use a resource group for Data Integration to run the data sync node. When you add a Db2 data source, you must test the connectivity between the data source and the resource group to ensure that the resource group can connect to the data source. We recommend that you use an exclusive resource group for Data Integration. For more information, see Exclusive resource groups for Data Integration.

Background information

Workspaces in standard mode support the data source isolation feature. You can add data sources separately for the development and production environments to isolate the data sources. This helps keep your data secure. For more information, see Isolate a data source in the development and production environments.

Procedure

  1. Go to the Data Source page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region in which the workspace you want to manage resides. On the Workspaces page, find the workspace, move the pointer over the More icon in the Actions column, and then select Workspace Settings.
    4. In the left-side navigation pane of the page that appears, click Data Source to go to the Data Source page.
    Note You can also go to the Data Sources page in Data Integration to add a data source. However, you can add a data source on the Data Sources page in Data Integration only to the production environment.
  2. On the Data Source page, click Add data source in the upper-right corner.
  3. In the Add data source dialog box, click DB2 in the Relational Database section.
  4. In the Add DB2 data source dialog box, set the parameters.
    Db2 data source
    ParameterDescription
    Data Source NameThe name of the data source. The name can contain letters, digits, and underscores (_) and must start with a letter.
    Data source descriptionThe description of the data source. The description can be up to 80 characters in length.
    EnvironmentThe environment in which the data source is used. Valid values: Development and Production.
    Note This parameter is available only when the workspace is in standard mode.
    JDBC URLThe Java Database Connectivity (JDBC) URL of the Db2 database, in the format of jdbc:db2://ServerIP:Port/Database.
    User nameThe username that is used to connect to the Db2 database.
    PasswordThe password that is used to connect to the Db2 database.
  5. Test network connectivity.
    Connectivity
    1. Click the Data Integration tab.
    2. Select the resource group that you want to use.
      • We recommend that you use an exclusive resource group for Data Integration. If you do not have an exclusive resource group for Data Integration, you can click Create Exclusive Resource Group for Data Integration to purchase one by following the on-screen instructions.
      • If you want to use a custom resource group, click Advanced to view these resource groups and select the resource group that you want to use.
    3. Find the resource group that you want to use and click Test connectivity in the Actions column.
      A sync node uses only one resource group for Data Integration. If you want to test the network connectivity between multiple types of resource groups and the data source, you can select the resource groups and click Batch test connectivity.
  6. If the data source passes the network connectivity test, click Complete.

What to do next

After the Db2 data source is added, you can configure a data sync node to read data from or write data to the data source. Before you configure the data sync node, you must learn how to configure Db2 Reader or Db2 Writer that will be used by the data sync node. For more information, see DB2 Reader and DB2 Writer.