Configuring target engines during the distribution - 7.3

Talend Change Data Capture User Guide

Version
7.3
Language
English
Product
Talend Change Data Capture
Module
Talend Change Data Capture
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2023-12-22

The configuration of targets is performed on the source machine, when distributing a target table. However, more configurations may be available on the target machine once the distribution is performed.

General procedure is the following:

  1. Choose the type of database.

  2. Choose the database source or enter a connection string and click Test.

  3. Choose the syntax for the table name.

  4. Choose the default database.

 

Depending on the type of target, the connection can be made in ODBC or in native.

To choose a source database it needs to have been created previously.

One option is to enter the string connection ODBC. For example for SQL Server:

DRIVER={SQL Server Native Client 10.0}; SERVER=WFRDEV01\INST1; UID=sa; PWD=gamma

 

Creating the DSN on each target

You must then create the DSN (ODBC Data Source Name) on the target machine, to reference the desired database. 

Note: The DSN you create must be a system DSN. You can choose any name for the DSN.

In a 64-bit computer, you must use the 32-bit version of the ODBC administrator (odbcad32.exe). 

You can find it in the sub-directory SysWOW64 of the Windows directory.