Configuring Db2 for LUW workspace data connections

During workspace creation, under Connection Type, click Db2 for LUW.

Connecting to the source database

In the Source Settings section, you provide the connection information for the source database.

Providing the connection details

To provide the connection details for the source database:

1. In the Server field, provide the server where the database is located.
2. In the Database field, provide the name of the database.
3. In the Port field, provide the port to use to connect to the database.
4. In the Username field, provide the username for the account to use to connect to the database.
5. For Password, you can either specify the password manually or, if secrets managers are available, you can select a secret name from a secrets manager.
6. To test the connection to the source data, click Test Source Connection.

Connection security settings

For the source connection, you can also:

• Use SSL/TLS to encrypt authentication.
• Trust the server certificate.
• Use a connection tunneling option (SSH only).

Connecting to the destination database

Note that you must create the destination database with the full schema before you run data generation.

Copying the connection and authentication details from the source database

If the destination database is in the same location as the source database, then you can copy the connection and authentication details from the source database.

To copy the connection and authentication details from the source database:

1. Click Copy Settings from Source.
2. For Password, you can either specify the password manually or, if secrets managers are available, you can select a secret name from a secrets manager.
3. To test the connection to the destination database, click Test Destination Connection.

Providing the connection details

To provide the connection details for the destination database:

1. In the Server field, provide the server where the database is located.
2. In the Database field, provide the name of the database.
3. In the Port field, provide the port to use to connect to the database.
4. In the Username field, provide the username for the account to use to connect to the database.
5. For Password, you can either specify the password manually or, if secrets managers are available, you can select a secret name from a secrets manager.
6. To test the connection to the destination database, click Test Destination Connection.

Connection security settings

For the destination connection, you can also:

• Use SSL/TLS to encrypt authentication.
• Trust the server certificate.
• Use a connection tunneling option (SSH only).