QPR Installation Instructions

Importing Data

Importing Data

Previous topic Next topic  

Importing Data

Previous topic Next topic JavaScript is required for the print function  

The QPR Metrics system supports integration to external data through SQL import and OLAP import. The QPR Metrics system supports all OLAP databases, which support ADO 2.0.

 

Integration can be done using measure specific integration settings or using model specific collective integration.

 

Integration to existing data systems requires the following steps:

-Identification of data that can be imported
-Locating the data in existing systems
-Setting up an ODBC or OLAP connection to data source
-Mapping the data and the measures
-Setting up a query which derives the data
-Scheduling the import procedure if needed