Before pipelines can run as part of a project, you must add a data connection for each data source and target database. You also select the associated access method (for example, ODBC or JDBC). When you add a data connection, it is saved to the repository and is available to use when you create a pipeline.
- When adding data connections for relational databases, ensure that the relational source files are properly configured before you run a project.
- When you configure a connection to a database management system (DBMS), you are prompted to supply a user name and password to authenticate your connection. Therefore, only you will have access to the DBMS data connections you add.
- You can test the connection as you add it. This allows you to confirm that the values you enter are valid and you have the proper credentials to access databases, directories, and file systems.
- Agents are change capture processes that reside on the z/OS server. Before adding a Db2 for z/OS JDBC connection, ensure that you have configured and started one or more capture agents on the z/OS server because you will be prompted to select or specify an agent during the procedure.
To add a source connection, follow these steps:
- On the main navigation menu, select .
- Select the project that you want to use to create your continuous replication pipeline.
- Click +Create Pipeline to open the Create Pipeline wizard.
- As a second step in connections, click Add Source. The New Replication Connection dialog opens.
- For replication connection, enter a unique name for the data connection. Note: If you enter a name that already exists in the repository, you cannot save the connection. The name cannot exceed 200 characters. For replication data connections, spaces in the name are not supported and hyphens ( - ) are the only special characters supported.
- For Description, enter a brief description of the data connection.
- For connection type, click the drop-down list and select the type of connection you are adding. If you select a DBMS, specify the associated data Access method.
- Specify the properties for your selected connection.
- Click Test to verify that your credentials are valid for the properties you entered. Note: If the Test button is unavailable, make sure you have entered values in all required fields.
- Click Save to add the new connection.