Mapping guidelines - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2026
First publish date
2000
ft:lastEdition
2026-03-04
ft:lastPublication
2026-03-04T14:06:44.769000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

There are a couple of key guidelines you must follow in order to obtain the results you expect.

  • Important: All target fields must be mapped

If all the target fields are not mapped, then the target record will not be written. This can be accomplished through explicit source to target mapping or with the INITIALIZE command.

The Parser will inform you of which target fields are not mapped, indicated by a return code of 4 upon completion of the Parser.

  • Datastore fields must be fully qualified if you have:
  • Multiple record types/descriptions in a source datastore with the same field names
  • Multiple target datastores that contains fields with the same names.
  • Qualifying datastore fields is explained in more detail in the following sections.