Please be aware that many ERP/MRP system vendors prefer not to allow data from external sources to be written directly into their product databases. In such circumstances, the options available are to write data to a temporary table or tables, usually within the external database structure, or write to a CSV file or files. With both options, the external system would then import the data via their own routines or products in accordance with their own rules. It is then the customer’s responsibility to liaise with the external systems’ vendor to arrange this data import.
To achieve this, a number of mandatory and optional data sets are required to provide the interface between the SQL database of the Seiki Scheduler and other systems’ data sources, e.g. SQL database, Microsoft Access or CSV files. Download the product information sheet below for dull details. This data exchange may be configured to run either in a single direction or bi-directionally, depending on your requirements.
As well as being able to run manually, the EAI can also be configured to run automatically via a user configurable schedule. This may be at a set time each day or after a specific interval. You also have the flexibility to split the interface configuration into a number of sections, each with their own schedule regime. For example, you can split the data import to and data export from the Scheduler.
Data Exchange Methods
SQL
SQL View is our preferred method of importing data from external systems into the Scheduler database. You may need assistance from your external system’s vendor or agent to create the required SQL view. In these circumstances, any additional costs incurred would be the responsibility of the customer.
Comma Separated Value (CSV) Files
An alternative method of providing data to be imported into the Scheduler database is via one or more CSV files. These files are structured such that each records line of data represents a single record, with each record having the individual field values separated by commas. It is a two-stage process. Firstly, the external system is required to generate the appropriate CSV file(s) which is the responsibility of the customer to configure and schedule this activity. Secondly, having recognised the presence of the CSV file(s), the EAI product reads the content and populates the Scheduler SQL database accordingly.
Related topics: Seiki Scheduler, Seiki AIR WIP Booking
