ImportOdbcQuery Script Examples - Revision history

Ollvihe at 12:53, 18 January 2024

2024-01-18T12:53:14Z

← Older revision		Revision as of 12:53, 18 January 2024
Line 10:		Line 10:
	</pre>		</pre>

	The following is the same command as the previous, except instead of a plaintext connections string (which might contain a password), the connections string is stored as a [[~~Secure Strings~~\|~~secure string~~]] with name ''MySecureConnectionString'':		The following is the same command as the previous, except instead of a plaintext connections string (which might contain a password), the connections string is stored as a [[Storing_Secrets_for_Scripts\|secret]] with name ''MySecureConnectionString'':
	<pre>		<pre>
	(SELECT 'OdbcConnectionStringKey', 'MySecureConnectionString') UNION ALL		(SELECT 'OdbcConnectionStringKey', 'MySecureConnectionString') UNION ALL

Ollvihe at 20:48, 25 October 2021

2021-10-25T20:48:57Z

← Older revision		Revision as of 20:48, 25 October 2021
Line 1:		Line 1:
	This page contains script examples for the [[~~QPR ProcessAnalyzer~~ Scripting Commands#--.23ImportOdbcQuery\|ImportOdbcQuery]] script command.		This page contains script examples for the [[SQL Scripting Commands#--.23ImportOdbcQuery\|ImportOdbcQuery]] script command.

	The following script extracts data from an ODBC connection to QPR ProcessAnalyzer database and selects all columns from the table PA_MODEL.		The following script extracts data from an ODBC connection to QPR ProcessAnalyzer database and selects all columns from the table PA_MODEL.

Ollvihe at 18:21, 15 March 2020

2020-03-15T18:21:08Z

← Older revision		Revision as of 18:21, 15 March 2020
Line 10:		Line 10:
	</pre>		</pre>

	The following is the same command as the previous, except instead of a plaintext connections string (which might contain ~~passwords~~), the connections string is stored as a [[Secure Strings\|secure string]] with name ''MySecureConnectionString'':		The following is the same command as the previous, except instead of a plaintext connections string (which might contain a password), the connections string is stored as a [[Secure Strings\|secure string]] with name ''MySecureConnectionString'':
	<pre>		<pre>
	(SELECT 'OdbcConnectionStringKey', 'MySecureConnectionString') UNION ALL		(SELECT 'OdbcConnectionStringKey', 'MySecureConnectionString') UNION ALL

Ollvihe at 18:20, 15 March 2020

2020-03-15T18:20:46Z

← Older revision		Revision as of 18:20, 15 March 2020
Line 10:		Line 10:
	</pre>		</pre>

			The following is the same command as the previous, except instead of a plaintext connections string (which might contain passwords), the connections string is stored as a [[Secure Strings\|secure string]] with name ''MySecureConnectionString'':
			<pre>
			(SELECT 'OdbcConnectionStringKey', 'MySecureConnectionString') UNION ALL
			(SELECT 'OdbcQueryString', 'SELECT * FROM PA_MODEL') UNION ALL
			(SELECT 'TargetTable', '#ImportOdbcTable') UNION ALL
			(SELECT 'Append', '1')
			--#ImportOdbcQuery
			</pre>

	[[Category:Examples]]		[[Category:Examples]]

Ollvihe at 12:27, 13 November 2019

2019-11-13T12:27:39Z

← Older revision		Revision as of 12:27, 13 November 2019
Line 1:		Line 1:
	This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery\|ImportOdbcQuery]] script command.		This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery\|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.		The following script extracts data from an ODBC connection to QPR ProcessAnalyzer database and selects all columns from the table PA_MODEL.
	<pre>		<pre>
	(SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL		(SELECT 'OdbcConnectionString', 'DSN=PA_EXPRESS_40') UNION ALL

Ollvihe at 07:44, 7 February 2018

2018-02-07T07:44:12Z

← Older revision		Revision as of 07:44, 7 February 2018
Line 1:		Line 1:
	This page contains script examples for the [[~~Supported_QPR_ProcessAnalyzer_Commands_in_Scripts~~#--.23ImportOdbcQuery\|ImportOdbcQuery]] script command.		This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ImportOdbcQuery\|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.		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.

TeeHiet: 403051

2016-06-20T07:46:25Z

403051

← Older revision		Revision as of 07:46, 20 June 2016
Line 1:		Line 1:
	This page contains script examples for the ~~ImportDataTable~~ script command.		This page contains script examples for the [[Supported_QPR_ProcessAnalyzer_Commands_in_Scripts#--.23ImportOdbcQuery\|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.		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.

TeeHiet: 403051

2016-06-20T07:30:28Z

403051

New page

This page contains script examples for the ImportDataTable 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.
<pre>
(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
</pre>

[[Category:Examples]]