Projects

A project defines:

  • The source ERP system (including the ERP version) - Lawson, Infor, SAP, Oracle, or PeopleSoft.
  • The destination or Insight tables
  • The mapping between source and destination
  • Schema documentation

Each project builds a single package that can deploy the extraction scripts, mapping, and Insight schema changes required to support an ERP Type.

An ERP may also have multiple projects associated with it as mappings may vary.  For example, for Oracle there are separate projects for the 11i and 12i versions as mappings for Oracle 11i systems are different from 12i systems.

Caution: 

Once a project is created, you can update the details except for the project name, ERP type, Friendly name, FQN . However, a new connection can be associated with the project. To change these attributes you must do a 'Save As' and save a new copy of the project.

When you start a new project, you can either extend the schema and mappings in an existing project or create a project for a new ERP type where you choose the ERP, name and Insight version.