August 15, 2023

Create connections and subscribers – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Create connections and subscribers – Docs for ESB 6.x

Create connections and subscribers

  1. In the Repository tree view and under
    Metadata, create a connection to your
    database dedicated to CDC, in this scenario
    CDC_connection.

    Note:

    Ensure that the database connection for CDC is on the same server with
    the source data to which changes are to be captured.

  2. In the Repository tree view and under
    Metadata, create a connection to the
    source data warehouse and identify the table to catch, in this scenario
    CRM_connection.
  3. Right-click the CRM connection and select Retrieve schema from the drop-down menu to
    retrieve the schema of the table to catch.
  4. Right-click CDC Foundation of
    CRM and select Create
    CDC     in the drop-down menu.

    The [Create Change Data Capture] dialog
    box displays
    Use_Case_tMysqlCDC_Create_Sub1.png

  5. In the Set link Connection field, select
    CDC_connection.
  6. Click Create Subscriber. The [Create Subscriber and Execute SQL Script] dialog
    box displays.

    Use_Case_tMysqlCDC_Create_Sub2.png

  7. Click Execute and then Close.
  8. Click Finish to validate the creation of
    the subscriber table.

    In the CDC Foundation folder, the
    relevant subscriber table displays.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x