ImportOdbcQuery Script Examples

From QPR ProcessAnalyzer Wiki
Revision as of 07:44, 7 February 2018 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

This page contains script examples for the ImportOdbcQuery script command.

The following script extracts data from an ODBC using a data source name configured as described in the How to Configure an ODBC Data Source Name for Connecting to QPR ProcessAnalyzer page and selects all columns from the table PA_MODEL.

(SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL
(SELECT 'OdbcQueryString', 'SELECT * FROM PA_MODEL') UNION ALL
(SELECT 'TargetTable', '#ImportOdbcTable') UNION ALL
(SELECT 'Append', '1')
--#ImportOdbcQuery