This document provides information about the i-Performance Data Integration process, which includes:
Identifying the required data used for the Planning, Budgeting, and Forecasting process
Creating the load files from the various data sources to populate the Planning application
Using the Data Integration Utility to load the files
Each of the tables (or files) in the Creating the Load Files section describes the format and content of each individual file. Extracts are created from source systems and saved into a file in the order of the columns listed. These files are then imported into the Planning application.
Some transformation of source data may be necessary in order to create the load files. The Creating the Load Files section describes any business logic that may need to be derived for each column.
NOTE: Changes to the product are listed in Revision History.
Please review all the information contained within this document to get a general understanding of what is required. General documentation can be found alongside this page whereas more detailed documentation at a load file level can be found under the Creating the Load Files section.
You will need access to source systems that contain the following types of information.
Employee / Full Time Equivalent FTE
Inventory (WIP, AR, Months of Inventory)
Productivity (Hours, Realization, Worked Value, Billed Value)
Firm/Organization Details (Offices, Departments)
Much of this will be found in your ERP system (Elite or CMS, for example) and your payroll system. You will need an understanding of the database layout of both the ERP and Payroll systems is required to know exactly what data to extract from those systems.
To access information in the ERP system, some amount of database expertise will be required to retrieve the information from the database and deposit it in the load file in the correct format. Also necessary is the ability to view the data for correctness; this may just be importing the load files into Microsoft Excel to visually determine if the load file is correct. For better error checking, some amount of VBA experience coupled with Excel knowledge may be helpful.
The creation of the Load Files is one of the first steps in the overall process to install and configure the Planning Application. It is recommended that you start creating these load files as early in the implementation process as possible. You will be able to load the CSV files into the Data Integration Layer once the Satori V-i-Performance Appliance has been delivered and configured.
Data Integration Process
Integrating your data involves a number of steps. This document is intended to guide you through each step and provide you with the information you need to successfully complete the data integration process.
To integrate your data, you must perform the following procedures:
Create CSV Load Files based on the information found under Creating the Load Files
Load the CSV files to the staging environment through the use of the Data Integration Utility
The following diagram illustrates the data integration process. Click any section of the diagram to view information about that part of the process.
Order of Creating and Loading the Data Files
Though the load files can be created in any order, here is a recommended order for the creation and loading of the data files.
General Ledger (Group 1):
Employee Data (Group 2):
Additional Data (Group 3):
Forecast Data (Group 4):
In this documentation, the terms ”table” and ”file” are used interchangeably.