Connect CDC SQData

This Quickstart assumes that full before and after data is being placed in the Hadoop HDFS datastore. SQData simplifies creation of each record via a single "Replicate" Command. Replicate uses the source data structure "DESCRIPTION" for both source and target. The SQData Apply Engine will automatically handle both Code Page translation and Data Type transformation as well as provide for the handling of invalid source data when applicable.

 

Example

The source data structures, typically in the form of COBOL copybooks for IMS or VSAM source data or DDL for Relational source data are placed into the Data Type specific directories created previously.

BEGIN GROUP DB2_SOURCE;

DESCRIPTION DB2SQL ./DB2DDL/EMP.ddl AS EMP

          KEY IS EMP_NO;

DESCRIPTION DB2SQL ./DB2DDL/DEPT.ddl AS DEPT

          KEY IS DEPT_NO;

END GROUP;

 

The content of the DB2 source DDL for the EMPLOYEE table in the EMP.ddl file:

      CREATE TABLE EMPLOYEE

          ( EMP_NO                         CHAR(6) NOT NULL

           ,FIRSTNME                       VARCHAR(12) NOT NULL

           ,MIDINIT                        CHAR(1) NOT NULL

           ,LASTNAME                       VARCHAR(15) NOT NULL

           ,WORKDEPT                       CHAR(3)

           ,PHONENO                        CHAR(4)

           ,HIREDATE                       DATE

           ,JOB                            CHAR(8)

           ,EDLEVEL                        SMALLINT

           ,SEX                            CHAR(1)

           ,BIRTHDATE                      DATE

           ,SALARY                         DECIMAL(9, 2)

           ,BONUS                          DECIMAL(9, 2)

           ,COMM                           DECIMAL(9, 2)

          );