Location of Interface Tables
96
Integration Guide
Location of Interface Tables
The endpoint definition for an external system or a publish channel points to the
database where its interface tables are stored. The database can be a local
database or a remote database.
The predefined interface table endpoint (MXIFACETABLE) points to the local
database, and you can add endpoints for remote databases.
Names of Interface Tables
The integration framework registers interface table names to an enterprise service
or a publish channel. You must configure the object structure that is associated
with the enterprise service or publish channel to support flat files. The Support
Flat Structure check box must be selected on the object structure.
Default names for interface table are not provided. The following guidelines
apply names for interface tables:
T Publish channels and enterprise services that use the same object structure
can use the same interface table name or different interface table names.
T Publish channels and enterprise services that use a different object structure
must use different interface table names.
Interface Queue Tables
The interface queue tables identify the sequence in which a receiving system
should process the records in the respective interface tables. Two queue tables
exist, one for inbound transactions and the other for outbound transactions.
Some transactions depend on the successful processing of a previous transaction.
For example, a PO record for an employee must be processed before the PO
receipt record. The receiving system must process the records in the same
sequence in which the sending system created the records.
All inbound and outbound transactions must have a record that is inserted into
the corresponding inbound or outbound queue table. This record contains a
unique sequential identifier called TRANSID, which is a value that identifies the
interface table to which the transaction data is written. The corresponding
interface table uses the TRANSID value to identify the record or records that are
associated with the transaction. You can identify the contents of a transaction by
looking up all the records with a given TRANSID value in the corresponding
interface table.
Interface Queue Table Direction
MXOUT_INTER_TRANS Outbound
MXIN_INTER_TRANS Inbound
To Next Page
Loading...