Create an apply engine script - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last updated
2024-12-13
Published on
2024-12-13T13:15:51.808737
You can create an apply engine script.
Note:
  • Develop a naming convention based on existing names in source and target. For example, use table name as DESCRIPTION alias (optionally with prefix).
  • Use named parameters for values that will change when moving between environments (dev, test, prod). For example, database name, schema name, host name, port number, publisher name.
  • It is recommended to use version control for apply engine script.
  • Do NOT alter the script source code after testing.
  1. Obtain relevant DDL and/or record layouts for datastores.
    • For Db2 and other RDBMS sources and targets, this is the CREATE TABLE statements.
    • For IMS, VSAM and mainframe files, COBOL copybooks is needed.
    • For Messaging system targets, record layouts are normally created automatically.
  2. Determine requirements for mapping to target records and filtering / transformations (if any).
  3. Develop the apply engine script.
  4. Parse the apply engine script and resolve any syntax, naming or mapping errors.
  5. Do a “stand-alone” test of the script.
    • The apply engine will connect to the publisher, then start receiving change records and applying them to the target datastore.
    • Resolve any connection or run-time errors .
  6. Configure the daemon to control the apply engine .
  7. Test operation of the apply engine through the daemon.