Integration

Overview

APS can work as a standalone product but it was designed to work closely with an ERP system.  It is possible to import data into APS so that data entry can be done in your ERP system and does not need to be re-entered into APS.  Also, once APS is producing accurate schedules it is often useful to load schedule data back into the ERP system in order to update Job schedule dates and expected material usage dates.  APS provides the export tools needed to make this happen.

Types of Data Connections

APS is flexible in the data connections it can make,  and although it is most easily interfaced via SQL, APS can also draw information from Oracle based databases, ODBC drivers, OLE DB, and even text files.

Key Concepts

When interfacing with an ERP it is important to create an efficient link between the two systems so as to not overburden hardware resources. Typically this is done by creating a Stored Procedure which will copy all the data from the relevant tables in the ERP database into a staging table.

Further manipulation or "massaging" of the data can be done through the use of Views. The reason behind this is so that the ERP database is not being queried constantly by APS thus tying up large amounts of hardware resources. This allows for better performance overall when using APS.