Adding an instance of the CDC Replication Engine for BigQuery (Windows)

Before you can start replication, you must add and configure an instance.

Procedure

If you are configuring the first instance of the CDC Replication Engine for BigQuery after installation, you can proceed to Step 3 of this procedure.
At the command prompt, launch the configuration tool by issuing the following command in the specified directory:
```
\<CDC Replication installation directory>\bin\dmconfigurets.exe
```
At the welcome message, click OK to continue.

On the IBM® Data Replication New Instance dialog box, you can configure the following options in the Instance area:

Option	Description
Name	Enter a name for your CDC Replication instance. This name must be unique.
Server Port	Enter the port number which CDC Replication uses for communication with client workstations running Management Console and other servers. Note: This port number cannot be used by other applications installed on the same server. You will use this port number when specifying access parameters for your datastore in the Access Manager perspective in Management Console. CDC Replication displays a default TCP/IP port of 12101. For more information, see your Management Console documentation.
Maximum Memory Allowed (MB)	Enter the amount of physically available RAM that you want to allocate for this instance of CDC Replication. By default, the configuration tool allocates 1024 MB of RAM for each instance. Note: Using values other than the defaults or allocating more RAM than is physically available on your server should only be undertaken after considering the impacts on product performance.
Encryption profile	CDC Replication Engine for BigQuery instances require that you configure TLS for communication between source and target. Select an encryption profile with encryption enabled. Click Manage to view and manage the available encryption profiles. Encryption profiles can be shared between multiple instances of CDC Replication. Draft comment: arun.c.r@ibm.com For my own reference. Hyperlinking pending for some phrases here. See topic for reference: https://www.ibm.com/docs/en/idr/11.4.0?topic=teradata-adding-instance-cdc-replication-engine-windows

In the Windows Service area, you can specify the account that will be used to start CDC Replication services. Select one of the following options:

Option Description

Local System account Start the CDC Replication services through the local system administrator account.

Option	Description
Local System account	Start the CDC Replication services through the local system administrator account.
This account	Start CDC Replication services through the specified user account. The account must be specified in the format `<domain>\<user name>`, where `<domain>` is the name of a domain in your environment, and `<user name>` is a valid login user name in the specified domain. If your computer is not part of a domain, you can specify `<computer name>\<user name>`. In the Password and Confirm Password boxes, enter the password currently associated with the selected Windows user account. If you change the password for the Windows user account after installing CDC Replication, you will have to use the Windows Services dialog to change the password currently set for each CDC Replication service.

This account

Start CDC Replication services through the specified user account.

The account must be specified in the format <domain>\<user name>, where <domain> is the name of a domain in your environment, and <user name> is a valid login user name in the specified domain. If your computer is not part of a domain, you can specify <computer name>\<user name>.

In the Password and Confirm Password boxes, enter the password currently associated with the selected Windows user account. If you change the password for the Windows user account after installing CDC Replication, you will have to use the Windows Services dialog to change the password currently set for each CDC Replication service.

In the BigQuery Instance area, you can configure access to the database that contains the tables for replication. To complete this step, you will require system administrator privileges. You can then add a datastore in the Access Manager perspective in Management Console and provide users access to this database. For more information, see your Management Console documentation.

Option	Description
BigQuery Private Key JSON File	Select the BigQuery service account's JSON key file. To download this file: Log in to your Google account at cloud.google.com. Click Console, and then to go to the Dashboard where you can select your project. From the navigation menu, click APIs & Services then select Credentials. From the Create Credentials menu, choose the Service account key. Select the dataset used by CDC Replication for metadata tables. You can specify any dataset except those in use by other installed instances of CDC Replication.
BigQuery Dataset	Select the dataset used by CDC Replication for metadata tables. You can specify any dataset except those in use by other installed instances of CDC Replication. Note: CDC Replication metadata tables contain important configuration information and should be backed up as part of your database backup strategy.

Option

Description

BigQuery Private Key JSON File

Select the BigQuery service account's JSON key file. To download this file:

Log in to your Google account at cloud.google.com.
Click Console, and then to go to the Dashboard where you can select your project.
From the navigation menu, click APIs & Services then select Credentials.
From the Create Credentials menu, choose the Service account key.
Select the dataset used by CDC Replication for metadata tables. You can specify any dataset except those in use by other installed instances of CDC Replication.

BigQuery Dataset

Select the dataset used by CDC Replication for metadata tables. You can specify any dataset except those in use by other installed instances of CDC Replication.

Note: CDC Replication metadata tables contain important configuration information and should be backed up as part of your database backup strategy.

In the Refresh Loader Path area, click Browse to specify the directory for bulk inserts into the database. CDC Replication must have read and write permissions for this directory.
Notes:
- Use a different directory for each instance of CDC Replication.
- This directory may contain database tables for replication. Take this into consideration when determining user access to this directory.