IBM integrations

Features of the Flat File Gateway

The Flat File Writer Gateway has various features that enable you to read alerts from the ObjectServer and to write them to a flat file.

Centralized property management
The gateway uses centralized property management and separates properties from data processing configuration. To configure the common gateway properties and the Flat File Writer Gateway properties, use the NCO_GATE.props properties file.
Setting the format of headers and trailers added to alerts
Whenever a delete, update, or insert occurs in the ObjectServer fields, the gateway writes header and trailer information with the changed alerts to the file.
Receiving notifications from multiple tables within the ObjectServer
The gateway can receive details of updates, inserts, and deletes to multiple tables from the ObjectServer. By default, the gateway writes all the updates to the file, then all the inserts, and then all the deletes.
Writing alert data to the file as name-value pairs
By default, the gateway writes the alert data to the file as comma separated entries.
Specifying start and end characters for all value fields
By default, the gateway only adds the start and end characters specified by Gate.File.StartString and Gate.File.EndString properties to string fields.
Passing table data
The gateway can replicate the data in any ObjectServer table in the destination file. Details of the tables to be replicated are stored in the table replication definition file. Use the Gate.Reader.TblReplicateDefFile property to specify the location of the table replication definition file.
Mapping table data
The gateway writes the alerts received from the various tables of ObjectServer into the flat file in a format defined by the map definition file. To specify the map definition file, use the Gate.MapFile property
Failback
The failback function comes into operation when the gateway loses its connection to the primary ObjectServer. When the primary ObjectServer fails, the reader fails back to the backup ObjectServer as configured using nco_xigen. To enable failback, set the Gate.Reader.FailbackEnabled property to TRUE
Process Agent control
You can control how the gateway runs by using Process Agent control.
Error handling
You can troubleshoot problems with the gateway by consulting error messages. To help you do this, the gateway has configurable error handling.

Parent topic: Flat File