File or HDFS JSON target - connect_cdc_sqdata - Latest

Connect CDC (SQData) Replicator 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) Replicator Engine
Copyright
2024
First publish date
2000
ft:lastEdition
2024-08-01
ft:lastPublication
2024-08-01T16:58:30.842568

Examples

  • Simple JSON formatted file or HDFS (Hadoop file system) where every source object name (i.e. table name) will become a file name.
    REPLICATE
      DB2 cdc://<host_name>:<sqdaemon_port>/<publisher_name>/<subscription_name>
      TO JSON [file | hdfs]:///*/key
    ;
  • Simple JSON formatted file or HDFS (Hadoop file system) where every source object name (i.e. table name) is written to a specified file name with a common prefix and suffix.
    REPLICATE
      DB2 cdc://<host_name>:<sqdaemon_port>/<publisher_name>/<subscription_name>
      TO JSON [file | hdfs]:///<prefix>_*_<suffix>/key
    ;