Storing Secrets for Scripts - Revision history

Ollvihe: /* Using secrets */

2026-04-09T08:29:33Z

Using secrets

← Older revision		Revision as of 08:29, 9 April 2026
Line 39:		Line 39:
	* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function in expression language		* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function in expression language

	Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't ~~yet~~ support ~~the~~ secrets.		Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't support secrets.

Ollvihe: /* Using secrets */

2026-04-08T12:39:38Z

Using secrets

← Older revision		Revision as of 12:39, 8 April 2026
Line 33:		Line 33:
	== Using secrets ==		== Using secrets ==
	Secrets can be used in the following commands:		Secrets can be used in the following commands:
	* [[SQL Scripting Commands\|SQL scripting commands]]: ImportOdbcQuery, ImportSalesforceQuery and ImportSapQuery.		* [[SQL Scripting Commands\|SQL scripting commands]]: ImportOdbcQuery, ImportSalesforceQuery and ImportSapQuery
	* [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_ODBC_Datasource\|ODBC datasources of model]].		* [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_ODBC_Datasource\|ODBC datasources of model]]
	* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)		* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)
	* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)		* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function expression language
	* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function (expression language)		* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function in expression language

	Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.		Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.

Ollvihe: /* Using secrets */

2026-04-08T12:38:54Z

Using secrets

← Older revision		Revision as of 12:38, 8 April 2026
Line 37:		Line 37:
	* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)		* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)
	* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)		* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)
			* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function (expression language)

	Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.		Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.

TeeHiet: TK-58110

2025-07-08T05:56:12Z

TK-58110

← Older revision		Revision as of 05:56, 8 July 2025
Line 6:		Line 6:

	== Setting secrets ==		== Setting secrets ==
	Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function. ~~Secrets~~ can also be defined in the [[Project_Properties_Dialog#Secrets\|Project Properties Dialog]].		Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function. Project secrets can also be defined in the [[Project_Properties_Dialog#Secrets\|Project Properties Dialog]].

	Example: Set a project secret (for project id 1):		Example: Set a project secret (for project id 1):

TeeHiet: TK-58110

2025-07-08T05:45:07Z

TK-58110

← Older revision		Revision as of 05:45, 8 July 2025
Line 6:		Line 6:

	== Setting secrets ==		== Setting secrets ==
	Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function.		Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function. Secrets can also be defined in the [[Project_Properties_Dialog#Secrets\|Project Properties Dialog]].

	Example: Set a project secret (for project id 1):		Example: Set a project secret (for project id 1):

Ollvihe: /* Listing secrets */

2025-05-12T10:41:46Z

Listing secrets

← Older revision		Revision as of 10:41, 12 May 2025
Line 19:		Line 19:

	== Listing secrets ==		== Listing secrets ==
	To list all secrets in the project, ~~there is a property~~ [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for ~~projects~~. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.		To list all secrets in the project, use the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] property for the project. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.

	Example: ~~Show~~ project secrets (for project id 1):		Example: List project secrets (for project id 1):
	<pre>		<pre>
	ToJson(ProjectById(1).Secrets);		ToJson(ProjectById(1).Secrets);
	</pre>		</pre>

	Example: ~~Show~~ global secrets:		Example: List global secrets:
	<pre>		<pre>
	ToJson(Secrets);		ToJson(Secrets);

Ollvihe: /* Setting and listing secrets */

2025-05-12T10:40:43Z

Setting and listing secrets

← Older revision		Revision as of 10:40, 12 May 2025
Line 5:		Line 5:
	Each secret has a type which defines in which command the secret can be used. The purpose of the type is to improve security, so that the secret can only be used in the intended command.		Each secret has a type which defines in which command the secret can be used. The purpose of the type is to improve security, so that the secret can only be used in the intended command.

	== Setting ~~and listing~~ secrets ==		== Setting secrets ==
	Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function.		Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function.

	~~There is~~ a ~~property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]]~~ for ~~projects to list all secrets in the~~ project. ~~For the global secrets~~, ~~there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.~~		Example: Set a project secret (for project id 1):
			<pre>
			ProjectById(1).SetSecret("sap", "SapAdminPassword", "I l0ve 5AP!");
			</pre>

	Example: Set a global ~~and a project-specific~~ secret:		Example: Set a global secret:
	<pre>		<pre>
	SetSecret("sap", "SapReaderPassword", "I l0ve 5AP!");		SetSecret("sap", "SapReaderPassword", "I l0ve 5AP!");
	~~ProjectById(1).SetSecret("sap", "SapAdminPassword", "I l0ve 5AP!");~~
	</pre>		</pre>

	Example: Show ~~global~~ secrets:		== Listing secrets ==
			To list all secrets in the project, there is a property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for projects. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.

			Example: Show project secrets (for project id 1):
	<pre>		<pre>
	ToJson(Secrets);		ToJson(ProjectById(1).Secrets);
	</pre>		</pre>

	Example: Show ~~project's secret~~:		Example: Show global secrets:
	<pre>		<pre>
	ToJson(~~ProjectById(1).~~Secrets);		ToJson(Secrets);
	</pre>		</pre>

Ollvihe: /* Setting and listing secrets */

2025-03-27T09:44:04Z

Setting and listing secrets

← Older revision		Revision as of 09:44, 27 March 2025
Line 18:		Line 18:
	Example: Show global secrets:		Example: Show global secrets:
	<pre>		<pre>
	ToJson(Secrets)		ToJson(Secrets);
	</pre>		</pre>

	Example: Show project's secret:		Example: Show project's secret:
	<pre>		<pre>
	ToJson(ProjectById(1).Secrets)		ToJson(ProjectById(1).Secrets);
	</pre>		</pre>

Ollvihe: /* Setting and listing secrets */

2025-03-27T09:43:48Z

Setting and listing secrets

← Older revision		Revision as of 09:43, 27 March 2025
Line 9:		Line 9:

	There is a property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for projects to list all secrets in the project. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.		There is a property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for projects to list all secrets in the project. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.

			Example: Set a global and a project-specific secret:
			<pre>
			SetSecret("sap", "SapReaderPassword", "I l0ve 5AP!");
			ProjectById(1).SetSecret("sap", "SapAdminPassword", "I l0ve 5AP!");
			</pre>

			Example: Show global secrets:
			<pre>
			ToJson(Secrets)
			</pre>

			Example: Show project's secret:
			<pre>
			ToJson(ProjectById(1).Secrets)
			</pre>

	== Using secrets ==		== Using secrets ==

Ollvihe: /* Setting and listing secrets */

2025-03-27T09:39:41Z

Setting and listing secrets

← Older revision		Revision as of 09:39, 27 March 2025
Line 6:		Line 6:

	== Setting and listing secrets ==		== Setting and listing secrets ==
	Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for ~~Project entity~~, or the corresponding generic context SetSecret function.		Secrets can be set by calling the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function for the project, or the corresponding generic context [[Generic_Functions_in_QPR_ProcessAnalyzer#SetSecret\|SetSecret]] function.

	There is a property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for projects to list all secrets in the project. For the global secrets, there is the corresponding global Secrets property. Note that the secret value cannot be retrieved even by system administrators.		There is a property [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project\|Secrets]] for projects to list all secrets in the project. For the global secrets, there is the corresponding global [[Generic_Properties_in_Expression_Language#Secrets\|Secrets]] property. Note that the secret value cannot be retrieved even by system administrators.

	== Using secrets ==		== Using secrets ==

← Older revision		Revision as of 12:39, 8 April 2026
Line 33:		Line 33:
	== Using secrets ==		== Using secrets ==
	Secrets can be used in the following commands:		Secrets can be used in the following commands:
	* [[SQL Scripting Commands\|SQL scripting commands]]: ImportOdbcQuery, ImportSalesforceQuery and ImportSapQuery.		* [[SQL Scripting Commands\|SQL scripting commands]]: ImportOdbcQuery, ImportSalesforceQuery and ImportSapQuery
	* [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_ODBC_Datasource\|ODBC datasources of model]].		* [[QPR_ProcessAnalyzer_Model_Datasources#Loading_Data_from_ODBC_Datasource\|ODBC datasources of model]]
	* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)		* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)
	* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)		* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function expression language
	* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function (expression language)		* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function in expression language

	Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.		Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.

← Older revision		Revision as of 12:38, 8 April 2026
Line 37:		Line 37:
	* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)		* [[DataFrame_in_Expression_Language#ImportOdbcSecure\|ImportODBCSecure]] function (expression language)
	* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)		* [[Generic_Functions_in_QPR_ProcessAnalyzer#CreateSnowflakeConnection\|CreateSnowflakeConnection]] function (expression language)
			* [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Project#:~:text=CreateMeaConnection\|CreateMeaConnection]] function (expression language)

	Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.		Note: Currently [[SQL Scripting Commands#--.23ImportSqlQuery\|ImportSqlQuery]] and [[SQL Scripting Commands#--.23ImportOleDbQuery\|ImportOleDbQuery]] don't yet support the secrets.