Gateway for 1D Data 6​.1

The Gateway extracts data from various data sources that are in unstructured (Text, Word, XML or PDF) or tabular (delimited text, Excel, Access) file formats and databases such as SQL Server and Oracle. The Gateway extracts data from specific data sources and transforms them into output EIWM format to be loaded into AIM. The output can also be stored on a Windows file system, in an Amazon Web Services (AWS) S3 bucket, or AVEVA Cloud Storage.

Characteristics of the Gateway

The following are the characteristics of the Gateway:

• Common User Experience: All new gateways built with common components ensure consistent configurations and operations.

• Data Validation: The Gateway validates data using either the whole or part of a value, conforming to a pattern, look up list and Report failures.

• RegEx Utility: The Gateway provides a utility to suggest RegEx patterns taken from a tabular Data Source (Excel, Access, SQL, Oracle and Delimiter Text) and provides an option to export into a .csv file.

• Standalone: As it is a standalone application you can deploy it independently either from its graphical user interface or from a command line interface.