Skip to content

Set up the CDC Inbound Endpoint Environment

Setup MySQL

  1. First, install MySQL database v8.x.x locally. If you have a remote server, please obtain the credentials required to connect.

  2. Create a user. For detailed instructions, refer to the MySQL Creating User documentation.

  3. Enable binlog. For detailed instructions, refer to the Enable MySQL Binlog documentation.

  4. Enable GTIDs. For detailed instructions, refer to the Enable MySQL GTIDs documentation.

  5. Download the Debezium MySQL Connecter Plug-in version 2.7.4.Final and Extract.

  6. Download the latest Debezium Orbit JAR v2.7.4 from nexus and place it in <PROJECT_HOME>/deployment/libs directory.

  7. Copy the following JAR files to <PROJECT_HOME>/deployment/libs:

    • mysql-connector-j-8.3.0.jar
    • antlr4-runtime-4.10.1.jar

  8. Copy the following JAR files to <MI_HOME>/wso2/lib:

    • debezium-connector-mysql-2.7.4.Final.jar
    • debezium-core-2.7.4.Final.jar

Note

  • <PROJECT_HOME> refers to the directory where your integration project is located.
  • <MI_HOME> refers to the extracted folder of the WSO2 Micro Integrator zip.

Setup PostgreSQL

  1. Install PostgreSQL locally or ensure you have access to a remote PostgreSQL instance with the necessary credentials.

  2. Configuring the PostgreSQL server. For detailed instructions, refer to the Configuring the PostgreSQL server documentation.

  3. Download the Debezium PostgreSQL Plug-in version 2.7.4.Final and Extract.

  4. Download the latest Debezium Orbit JAR v2.7.4 from nexus and place it in <PROJECT_HOME>/deployment/libs.

  5. Copy the following JAR files to <PROJECT_HOME>/deployment/libs:

    • postgresql-42.6.1.jar
    • protobuf-java-3.25.5.jar

  6. Copy the following JAR files to <MI_HOME>/wso2/lib:

    • debezium-connector-postgres-2.7.4.Final.jar
    • debezium-core-2.7.4.Final.jar

Note

  • <PROJECT_HOME> refers to the directory where your integration project is located.
  • <MI_HOME> refers to the extracted folder of the WSO2 Micro Integrator zip.

Setup MS SQL Server

  1. Install Microsoft SQL Server locally or ensure you have access to a remote SQL Server instance with the necessary credentials.

  2. Enable Change Data Capture (CDC) in both database and server. For detailed instructions, refer to the Enable MSSQL CDC documentation.

  3. Download the Debezium SQL Server Plug-in version 2.7.4.Final and Extract.

  4. Download the latest Debezium Orbit JAR v2.7.4 from nexus and place it in <PROJECT_HOME>/deployment/libs.

  5. Copy the following JAR files to <PROJECT_HOME>/deployment/libs:

    • mssql-jdbc-12.8.1.jre8.jar

  6. Copy the following JAR files to <MI_HOME>/wso2/lib:

    • debezium-connector-sqlserver-2.7.4.Final.jar
    • debezium-core-2.7.4.Final.jar

Note

  • <PROJECT_HOME> refers to the directory where your integration project is located.
  • <MI_HOME> refers to the extracted folder of the WSO2 Micro Integrator zip.