When you first select the staging tables item from the navigator you will be prompted to complete the set up.

The setup is broken into 3 parts: the prechecks, making a database configuration specific to your system and creation of the Maps required to create the staging tables.

Staging Table Creation Tool Initialization is broken up into three parts: Prechecks, Making the Database Configuration and Making the Maps.

Requirements

Mapping

Altova Mapforce

Altova Mapforce EDI configurations, X12 and/or EDIFACT

Database

DB2 or Microsoft SQL Server

EDI Staging Table Creation Helper

The EDI Staging Table Creation Tool allows for the creation of staging tables to be based on information from the SEF file (Standard Exchange Format) and Altova Mapforce's EDI Definitions.

Staging tables allow for EDI data to be stored in a temporary location for further processing. 

The Staging Table Creation Tool is in two parts:

• the setup, allowing for the tool to be configured to the exact environment required (currently DB2 and MSSQL only) 
  and
• the runtime, allowing the selection of individual transaction types to have the required table created in the Library or Database.