Data Integration Validation | Vantage Analyst - Data Integration Validation - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide
Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.4.1
Published
May 2022
Language
English (United States)
Last Update
2022-05-09
dita:mapPath
ufz1626905554941.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
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 );
Related information