Integration

Overview

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

Types of Data Connections

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

Key Concepts

When interfacing with an ERP, it is important to create an efficient link between the two systems not to overburden hardware resources. Typically, this is done by creating a Stored Procedure that 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 PlanetTogether, thus tying up large amounts of hardware resources. This allows for better performance overall when using PlanetTogether.