Installing QPR Metrics Integration Kit

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.

Help URL: http://www.yourdomain.com/help/index.html?ag_integration.htm