ExtractSap Function - Revision history

MarHink at 15:41, 14 January 2025

2025-01-14T15:41:10Z

← Older revision		Revision as of 15:41, 14 January 2025
Line 20:		Line 20:
	* '''PoolSize''': Maximum number of RFC connections that this destination will keep in its pool. Default value is "5". Optional. Corresponds to the "POOL_SIZE" constant in SAP.		* '''PoolSize''': Maximum number of RFC connections that this destination will keep in its pool. Default value is "5". Optional. Corresponds to the "POOL_SIZE" constant in SAP.
	* '''IdleTimeout''': If a connection has been idle for more than the defined time in seconds, it will be closed and removed from the connection pool. Default value is "600". Optional. Corresponds to the "IDLE_TIMEOUT" constant in SAP.		* '''IdleTimeout''': If a connection has been idle for more than the defined time in seconds, it will be closed and removed from the connection pool. Default value is "600". Optional. Corresponds to the "IDLE_TIMEOUT" constant in SAP.
			* '''ImportChunkSize''': Specifies the size of the chunks of data used when importing the data from SAP to PA Server. The value represents the approximate maximum number of data cells in each chunk (consisting tables of <number of rows> * <number of columns> data cells. Default value is 200000. Smaller value causes big imports to be split into more chunks taking more time in total, but it makes importing of each chunk faster possibly helping in some timeout situations.
	* '''Router''': List of host names and service names or port numbers for the SAPRouter in the following format: /H/hostname/S/portnumber. Optional. Corresponds to the "SAPROUTER" constant in SAP.		* '''Router''': List of host names and service names or port numbers for the SAPRouter in the following format: /H/hostname/S/portnumber. Optional. Corresponds to the "SAPROUTER" constant in SAP.
	* '''LogonGroup''': The logon group from which the message server shall select an application server. Optional. Corresponds to the "GROUP" constant in SAP.		* '''LogonGroup''': The logon group from which the message server shall select an application server. Optional. Corresponds to the "GROUP" constant in SAP.

Ollvihe at 07:16, 30 April 2024

2024-04-30T07:16:46Z

← Older revision		Revision as of 07:16, 30 April 2024
Line 111:		Line 111:
	"Mode": "1"		"Mode": "1"
	};		};
	let queryParameters = sapConnection.Extend({		let queryParameters = sapConnection.Extend(#{
	"FieldNames": "VBELN,ERDAT,ERZET,ERNAM,NETWR,WAERK",		"FieldNames": "VBELN,ERDAT,ERZET,ERNAM,NETWR,WAERK",
	"QueryTable": "VBAK",		"QueryTable": "VBAK",

Ollvihe at 07:16, 30 April 2024

2024-04-30T07:16:09Z

← Older revision		Revision as of 07:16, 30 April 2024
Line 83:		Line 83:
	"IdleTimeout": 600		"IdleTimeout": 600
	};		};
	let queryParameters = sapConnection.Extend({		let queryParameters = sapConnection.Extend(#{
	"FieldNames": "VBELN,ERDAT,ERZET,ERNAM,NETWR,WAERK",		"FieldNames": "VBELN,ERDAT,ERZET,ERNAM,NETWR,WAERK",
	"QueryTable": "VBAK",		"QueryTable": "VBAK",

Ollvihe at 22:20, 23 April 2024

2024-04-23T22:20:04Z

← Older revision		Revision as of 22:20, 23 April 2024
Line 52:		Line 52:
	* '''SapSso2Ticket'''		* '''SapSso2Ticket'''
	* '''SncLibraryPath''': Full path including file name of the SNC shared library to be used.		* '''SncLibraryPath''': Full path including file name of the SNC shared library to be used.
	* '''SncMode: Determines whether connections will be secured with SNC. Value 0 doesn't use SNC (default) and value 1 uses SNC.		* '''SncMode''': Determines whether connections will be secured with SNC. Value 0 doesn't use SNC (default) and value 1 uses SNC.
	* '''SncMyName: Token/identifier representing the external RFC program. In most cases this can be omitted. The installed SNC solution usually knows its own SNC name. Only for solutions supporting “multiple identities”, you may Varies depending on the installed SNC solution (Secude, Kerberos, NTLM, etc). Example for Secude: p/secude:CN=ALEREMOT SAP Online Help 09.09.2014 SAP .NET Connector 3.0 41 need to specify the identity to be used for this particular destination/server. E, O=Mustermann-AG, C=DE		* '''SncMyName''': Token/identifier representing the external RFC program. In most cases this can be omitted. The installed SNC solution usually knows its own SNC name. Only for solutions supporting “multiple identities”, you may Varies depending on the installed SNC solution (Secude, Kerberos, NTLM, etc). Example for Secude: p/secude:CN=ALEREMOT SAP Online Help 09.09.2014 SAP .NET Connector 3.0 41 need to specify the identity to be used for this particular destination/server. E, O=Mustermann-AG, C=DE
	* '''SncPartnerName: The backend's SNCname.		* '''SncPartnerName''': The backend's SNCname.
	* '''SncPartnerNames		* '''SncPartnerNames'''
	* '''SncQop: Quality of service to be used for SNC communication of this particular destination/server. One of the following values:		* '''SncQop''': Quality of service to be used for SNC communication of this particular destination/server. One of the following values:
	** 1: Digital signature		** 1: Digital signature
	** 2: Digital signature and encryption		** 2: Digital signature and encryption

Ollvihe at 22:19, 23 April 2024

2024-04-23T22:19:41Z

@@ Line 27: / Line 27: @@
 * '''Ping''': If this is set to true, SAP server is pinged before SAP query execution. Purpose is help troubleshooting SAP connection issues. Optional.
 * '''TraceLevel''': Sets SAP trace level, which can be 0, 1, 2, 3 or 4. Setting higher trace level helps to troubleshoot SAP connection issues. ''sapnco.dll'' writes log file to the current working folder with for example name'nco_rfc_5484_2.trc'. Optional.
 Examples:

Ollvihe at 12:51, 18 January 2024

2024-01-18T12:51:13Z

← Older revision		Revision as of 12:51, 18 January 2024
Line 5:		Line 5:
	* '''User''': SAP username used to connect to SAP. Mandatory. Corresponds to the "USER" constant in SAP.		* '''User''': SAP username used to connect to SAP. Mandatory. Corresponds to the "USER" constant in SAP.
	* '''Password''': Password for the SAP user used to connect to SAP. Mandatory. Corresponds to the "PASSWD" constant in SAP.		* '''Password''': Password for the SAP user used to connect to SAP. Mandatory. Corresponds to the "PASSWD" constant in SAP.
	* '''PasswordKey''': [[~~Secure_Strings~~\|~~Secure string key~~]] for the stored SAP password. Alternative for the Password property.		* '''PasswordKey''': [[Storing_Secrets_for_Scripts\|Secret name]] for the stored SAP password. Alternative for the Password property.
	* '''Client''': The SAP backend client. Mandatory. Corresponds to the "CLIENT" constant in SAP.		* '''Client''': The SAP backend client. Mandatory. Corresponds to the "CLIENT" constant in SAP.
	* '''AppServerHost''': Hostname or IP of the specific SAP application server, to which all connections shall be opened. Mandatory if MessageServerHost is not defined. Corresponds to the "ASHOST" constant in SAP.		* '''AppServerHost''': Hostname or IP of the specific SAP application server, to which all connections shall be opened. Mandatory if MessageServerHost is not defined. Corresponds to the "ASHOST" constant in SAP.

Ollvihe at 00:16, 2 March 2023

2023-03-02T00:16:28Z

← Older revision		Revision as of 00:16, 2 March 2023
Line 1:		Line 1:
	ExtractSap function ~~extracts~~ data from an SAP R/3 system and returns ~~it as~~ a DataFlow. The function is in the generic context and also in the project context. When using the secure strings, the function need to be called in the project context as the secure strings are project specific.		ExtractSap function imports data from an SAP R/3 system using its RFC interface and returns a DataFlow. The function is in the generic context and also in the project context. When using the secure strings, the function need to be called in the project context as the secure strings are project specific. Using the ExtractSap function requires installing [[QPR_ProcessAnalyzer_ScriptLauncher#Installing_SAP_NetWeaver_RFC_Library\|SAP NetWeaver RFC Library]]. More information about [[Importing_Data_from_SAP\|connecting to SAP]].

	Using the ExtractSap function requires installing [[QPR_ProcessAnalyzer_ScriptLauncher#Installing_SAP_NetWeaver_RFC_Library\|SAP NetWeaver RFC Library]].

	More information about [[Importing_Data_from_SAP\|connecting to SAP]].

	Parameters:		Parameters:

Ollvihe at 00:14, 2 March 2023

2023-03-02T00:14:54Z

← Older revision		Revision as of 00:14, 2 March 2023
Line 1:		Line 1:
	ExtractSap function extracts data from an SAP R/3 system and returns it as a DataFlow. The function is in the generic context and also in the project context. When using the secure strings, the function need to be called in the project context as the secure strings are project specific.		ExtractSap function extracts data from an SAP R/3 system and returns it as a DataFlow. The function is in the generic context and also in the project context. When using the secure strings, the function need to be called in the project context as the secure strings are project specific.

	Using the ExtractSap function requires installing [[~~Installing_QPR_ProcessAnalyzer_Server~~#Installing_SAP_NetWeaver_RFC_Library\|SAP NetWeaver RFC Library]].		Using the ExtractSap function requires installing [[QPR_ProcessAnalyzer_ScriptLauncher#Installing_SAP_NetWeaver_RFC_Library\|SAP NetWeaver RFC Library]].

			More information about [[Importing_Data_from_SAP\|connecting to SAP]].

	Parameters:		Parameters:

Ollvihe at 22:48, 15 February 2023

2023-02-15T22:48:31Z

← Older revision		Revision as of 22:48, 15 February 2023
Line 33:		Line 33:

	An example of performing a SAP extraction and persisting the extracted data to a table having id 1. Note: Data table must exist already when using this approach.		An example of performing a SAP extraction and persisting the extracted data to a table having id 1. Note: Data table must exist already when using this approach.
	<~~pre~~>		<syntaxhighlight lang="typescript">
	let sapConnection = #{		let sapConnection = #{
	"AppServerHost": "sap01",		"AppServerHost": "sap01",
Line 56:		Line 56:
	DatatableById(1)		DatatableById(1)
	.Import(resultsFlow);		.Import(resultsFlow);
	</~~pre~~>An example of performing a SAP extraction and persisting the extracted data to a table named "SAPData" in project having id 1. If the data table does not yet exist, a new one is created into Snowflake.<syntaxhighlight lang="typescript">		</syntaxhighlight>

			An example of performing a SAP extraction and persisting the extracted data to a table named "SAPData" in project having id 1. If the data table does not yet exist, a new one is created into Snowflake.<syntaxhighlight lang="typescript">
	let sapConnection = #{		let sapConnection = #{
	"AppServerHost": "sap01",		"AppServerHost": "sap01",
Line 81:		Line 83:
	.ExtractSap(queryParameters)		.ExtractSap(queryParameters)
	.Persist("SAPData", #{"ProjectId": 1, "Connection": CreateSnowflakeConnection(#{"ProjectId": 1})})		.Persist("SAPData", #{"ProjectId": 1, "Connection": CreateSnowflakeConnection(#{"ProjectId": 1})})
			</syntaxhighlight>

	~~</syntaxhighlight>~~An example of performing a SAP extract, a simple transformation for extracted data and import to a table named "TransformedSAPData" in project having id 1.		An example of performing a SAP extract, a simple transformation for extracted data and import to a table named "TransformedSAPData" in project having id 1.

	Note: The example uses ScriptLauncher as a gateway and works only with ScriptLauncher version 2023.1 or later with "UseLegacyClientSideImport"-setting in appsettings.json set to false (if the setting is available in the used version).<syntaxhighlight lang="typescript">		Note: The example uses ScriptLauncher as a gateway and works only with ScriptLauncher version 2023.1 or later with "UseLegacyClientSideImport"-setting in appsettings.json set to false (if the setting is available in the used version).<syntaxhighlight lang="typescript">

MarHink: Improved readability

2023-02-14T11:40:07Z

Improved readability

← Older revision		Revision as of 11:40, 14 February 2023
Line 82:		Line 82:
	.Persist("SAPData", #{"ProjectId": 1, "Connection": CreateSnowflakeConnection(#{"ProjectId": 1})})		.Persist("SAPData", #{"ProjectId": 1, "Connection": CreateSnowflakeConnection(#{"ProjectId": 1})})

	</syntaxhighlight>An example of performing a SAP extract ~~(using~~ ScriptLauncher as a gateway~~. NOTE:~~ ScriptLauncher ~~must be~~ version 2023.1 or later with "UseLegacyClientSideImport"-setting in appsettings.json set to false (if the setting is available in the used version)~~), a simple transformation for extracted data and import to a table named "TransformedSAPData" in project having id 1~~.<syntaxhighlight lang="typescript">		</syntaxhighlight>An example of performing a SAP extract, a simple transformation for extracted data and import to a table named "TransformedSAPData" in project having id 1.

			Note: The example uses ScriptLauncher as a gateway and works only with ScriptLauncher version 2023.1 or later with "UseLegacyClientSideImport"-setting in appsettings.json set to false (if the setting is available in the used version).<syntaxhighlight lang="typescript">
	function ExtractTransformAndLoad(extractFunc, transformFunc, loadFunc)		function ExtractTransformAndLoad(extractFunc, transformFunc, loadFunc)
	{		{