Data Integration Validation | Vantage CX - Data Integration Validation

Data Integration Validation | Vantage CX - Data Integration Validation - Vantage Customer Experience

Vantage Customer Experience User Guide

Deployment

VantageCloud

VantageCore

Edition

Enterprise

IntelliFlex

VMware

Product

Vantage Customer Experience

Release Number

1.6

Published

October 2023

Language

English (United States)

Last Update

2023-10-26

dita:mapPath

hbt1563223944614.ditamap

dita:ditavalPath

oyf1565965838286.ditaval

dita:id

tmo1562969305444

Product Category

Teradata Applications

The tables that you use when you create an API data integration must be valid. This section includes the schema for each table type. See API Request and Response Tables.

Inbound Response and Outbound Source Table

Each row in the table represents the data sent or received in each individual API call.

CREATE MULTISET TABLE ${databaseName}.${tableName}, FALLBACK,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      Execution_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Integration_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Object_Order INTEGER,
      Path VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Value VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Datatype VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Order INTEGER,
      Request_Object_Order INTEGER,
      Request_Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Status INTEGER NOT NULL,
      Response_Content_Type VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Body VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC
     )
PRIMARY INDEX ( Object_Id );

Outbound Response

CREATE MULTISET TABLE ${databaseName}.${tableName}, FALLBACK,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO,
     MAP = TD_MAP1
     (
      Execution_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Integration_Id VARCHAR(12) CHARACTER SET LATIN CASESPECIFIC,
      Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Object_Order INTEGER,
      Path VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Value VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Property_Datatype VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
      Element_Order INTEGER,
      Request_Object_Order INTEGER,
      Request_Object_Id VARCHAR(40) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Status INTEGER NOT NULL,
      Response_Content_Type VARCHAR(128) CHARACTER SET LATIN NOT CASESPECIFIC,
      Response_Body VARCHAR(32000) CHARACTER SET LATIN NOT CASESPECIFIC
     )
PRIMARY INDEX ( Object_Id );