QPR Knowledge Base 2019.1

Import Data

Import Data

Previous topic Next topic  

Import Data

Previous topic Next topic  

In QPR Metrics, you can import existing information into your Scorecard model. Thanks to the import feature, QPR Metrics can be incorporated into an organization seamlessly and gradually. Furthermore, with imports, you can begin using historical data immediately.

 

You can import your existing data into QPR Metrics. Data can be imported from SQL databases. In SQL import, you type an SQL query and execute it either interactively or scheduled. This way, you can specify regular scheduled imports to retrieve data for your elements from a specific SQL database, say, once a week. You can perform mass SQL imports in much the same way as SQL imports. These imports can be done from the Integration View window.

 

You can utilize also data you have in QPR Modeling Client.

 

For more importing information, select the related topic:

 

SQL Import

 

 

Scheduling

When performing an SQL import, you can schedule the task to occur on intervals, at a specified date and time. This is helpful for automatically updating your model to contain the latest values of your company database. For example, you can schedule the import to run every night and thereby automatically update your model every night.

 

For more information, see Scheduling SQL Import.