Click image to view full size

Data Extraction

To enable you to maximise your use of existing systems and data stores, i-nexus can connect to any jdbc compliant database and extract data using a SQL query. This means there is no need to re-key data when you set up i-nexus, saving you time and money, and eliminating the errors in that can occur.

Click image to view full size

Data Transformation

Data you extract from a source system can be mapped to one or more metrics in i-nexus. This data can be transformed or combined with other imported data or data that has been manually entered using our intra worksheet calculations capability. This enables you to perform complex calculations and populate the resultant value into a KPI.

Click image to view full size

Data Load

In accordance with a schedule you define, i-nexus extracts data from your source system, validates it and imports it into the target metric columns defined by the mapping.