QPR Knowledge Base 2012.1

Installing QPR Metrics Integration Kit

Installing QPR Metrics Integration Kit

Previous topic Next topic  

Installing QPR Metrics Integration Kit

Previous topic Next topic  

The QPR Metrics system supports integration to external data through SQL import and OLAP import. QPR Metrics Integration kit requires that Microsoft SQL Server is used.

 

QPR Metrics Integration Kit is installed by running database scripts to database.

1.Start your favorite SQL Query tool.
2.Log on to database with the same login id as QPR products are using.
3.Open the following files and execute them

SC_Import_ValuesSQLServer.sql

sql_QPR_ReportingViews.sql

sql_QPR_ReportingProcedure.sql

 

If you install the reporting procedure you must have installed the reporting views before.

Finally the database job can be installed.

 

Note: SC_ReportingUpdate database job must be installed by database admin.