For the installation stage in ODBC, the ODBC MySQL driver needs to be installed.
Before you begin
The MySQL source file is available on a GitHub repository. You can find the download link in the installation package.
After this installation, the remaining steps of the setup can be completed in native mode.
About this task
Enter the data in the login screen. The profile used by default needs to have
advanced rights on the database and on the schemes and tables that will be
replicated. It also needs to have the advanced rights to the system
- Click OK.
- At first launch of DDSPVMySQL, the Tuning registry key is created and set to 0 by default. Set this key to 1 to activate the tuning and get metrics at the table level.
Talend Change Data Capture then creates and installs the elements required by MySQL registry and the SQLite database for the repository with a name based on: firstname.lastname@example.org.