Source datastore specification - connect_cdc_sqdata - 4.1

Connect CDC (SQData) Secure communications components

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
4.1
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Secure communications components
Topic type
How Do I
Installation
Copyright
2024
First publish date
2000
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T13:29:14.268926
The actions performed by an Apply Engine are described by an Engine Script. In this example the script might define the simple mapping and data transformation required for replication of the changes captured from DB2 on z/OS to the target Kafka Cluster. The script must contain a section similar to the one below, which describes the content and source of the CDC records for two employee related tables:
...
-- -------------------------------------------------------------
--         DATA DEFINITION SECTION
-- -------------------------------------------------------------
DESCRIPTION SQLDDL ~\sqdata\DB2DDL\emp_table.ddl  AS empddl;
DESCRIPTION SQLDDL ~\sqdata\DB2DDL\dept_table.ddl AS deptddl; 
--  
DATASTORE cdc://zos_host_name/Capture_publisher_agent_name/engine_name
           OF UTSCDC
           AS CDCIN
           DESCRIBED BY
                     empddl
                    ,deptddl
;
...

Notes:

  • zos_host_name will contain the actual host name of the z/OS system where the DB2 database Capture Agent and its Controller Daemon run.
  • Capture_publisher_agent_name will contain the alias name assigned to the CDC Store in the Agent Configuration File which is also specified in the Capture Agent Configuration file, not discussed in this document. See the DB2 Capture Reference Manual for more information about the configuration of that Capture Agent.
  • If the Engine will use a TLS connection the remote Publisher running under IBM's (AT-TLS) , the "cdcs://" URL syntax type must be specified.