Enterprise Application Integration
Using EAI (Enterprise Application Integration) software, Seiki is able to offer an intelligent interfacing solution that can optimise and simplify data exchanges between different software products. Enterprise Application Integration software serves to connect your ERP/MRP systems or other databases and software to the Seiki Scheduler database, in order to automate the task of data entry.
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. 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.