Creating specific tables for MySQL/MariaDB sources - 7.3

Talend Change Data Capture Installation 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-10-05

If DD_TUN_DST and DD_PARAM tables for MySQL / MariaDB source do not exist in the Talend Change Data Capture repository database, they must be created as described in the following procedure.

Tables for MySQL / MariaDB source are called: MYSQL_DD_PARAMsql and MYSQL_DD_TUN_DST.sql.

Use SQLiteSpy.exe to execute the script. The database to be updated is located in folder DestinationPath/MySQL and named {server@database}.db3.

Note: {server@database} is the name of the instance of MariaDB installed and located in the registry key DD_for_MySql.

{server@database} = 195.195.95.60@mdb_dd_test.