QPR Knowledge Base 2016.1

Importing Data

Importing Data

Previous topic Next topic No directory for this topic  

Importing Data

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

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