Importing Data from SAP - Revision history

Ollvihe at 14:27, 21 May 2025

2025-05-21T14:27:41Z

← Older revision		Revision as of 14:27, 21 May 2025
Line 33:		Line 33:
	{\| class="wikitable"		{\| class="wikitable"
	! '''SAP data type'''		! '''SAP data type'''
	! '''Expression language:<br>~~ReadSap~~ function'''		! '''Expression language:<br>ExtractSap function'''
	! '''SQL scripting:<br>--#ImportSapQuery'''		! '''SQL scripting:<br>--#ImportSapQuery'''
	\|-		\|-

Ollvihe: /* SNC encrypted connection */

2024-12-15T23:44:58Z

SNC encrypted connection

← Older revision		Revision as of 23:44, 15 December 2024
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	To improve security, connection to SAP can be encrypted using SNC, a technique provided by SAP. To take the SNC into use, you need a dll file from SAP that contains the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's ~~(i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll)~~. In the QPR ProcessAnalyzer data extraction command, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. To enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.		To improve security, connection to SAP can be encrypted using SNC, a technique provided by SAP. To take the SNC into use, you need a dll file from SAP that contains the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's. In the QPR ProcessAnalyzer data extraction command, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. To enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* SNC encrypted connection */

2024-02-12T09:43:54Z

SNC encrypted connection

← Older revision		Revision as of 09:43, 12 February 2024
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	To improve security, connection to SAP can be encrypted using SNC, a technique provided by SAP. To take the SNC into use, you need ~~the~~ dll file from SAP that contains the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. ~~First of all, to~~ enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.		To improve security, connection to SAP can be encrypted using SNC, a technique provided by SAP. To take the SNC into use, you need a dll file from SAP that contains the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the QPR ProcessAnalyzer data extraction command, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. To enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* SNC encrypted connection */

2024-02-12T09:32:41Z

SNC encrypted connection

← Older revision		Revision as of 09:32, 12 February 2024
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	To improve security, connection to SAP can be encrypted using SNC ~~which is~~ a technique ~~available in~~ SAP. To take the SNC into use, you need the dll file from SAP that ~~provides~~ the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. First of all, to enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.		To improve security, connection to SAP can be encrypted using SNC, a technique provided by SAP. To take the SNC into use, you need the dll file from SAP that contains the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. First of all, to enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* ETL script examples */

2023-06-15T22:35:01Z

ETL script examples

← Older revision		Revision as of 22:35, 15 June 2023
Line 7:		Line 7:

	==ETL script examples==		==ETL script examples==
	Follow the links ~~below~~ to find example scripts:		Follow the links to find example scripts:
	* [[Example_to_Extract_Data_from_SAP\|Extract data from SAP into Snowflake staging tables]]		* [[Example_to_Extract_Data_from_SAP\|Extract data from SAP into Snowflake staging tables]]
	* [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake\|Transform staged SAP data into eventlog using Snowflake]]		* [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake\|Transform staged SAP data into eventlog using Snowflake]]

Ollvihe: /* SNC encrypted connection */

2023-05-31T21:49:24Z

SNC encrypted connection

← Older revision		Revision as of 21:49, 31 May 2023
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	To improve security, connection to SAP can be encrypted using SNC which is a technique available in SAP. To take the SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. First of all, to enable SNC, set the '''SncMode''' parameter to '''1''', and set '''SncLibraryPath''' to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.		To improve security, connection to SAP can be encrypted using SNC which is a technique available in SAP. To take the SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. First of all, to enable SNC, set the '''SncMode''' parameter to '''1''', and set the '''SncLibraryPath''' parameter to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* SNC encrypted connection */

2023-05-31T21:48:50Z

SNC encrypted connection

← Older revision		Revision as of 21:48, 31 May 2023
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	~~Connection~~ to SAP can be encrypted using SNC which is a technique ~~provided by~~ SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In ~~scripts~~, SNC is ~~used~~ in individual extractions commands (ExtractSap function and --#ImportSapQuery) by ~~provided~~ the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. ~~Most important SCN related parameters are following:~~		To improve security, connection to SAP can be encrypted using SNC which is a technique available in SAP. To take the SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (i.e., icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In the data extraction, SNC is set in the individual extractions commands (ExtractSap function and --#ImportSapQuery command) by providing the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. First of all, to enable SNC, set the '''SncMode''' parameter to '''1''', and set '''SncLibraryPath''' to contain path to the encryption dll file (e.g., sapcrypto.dll). You may also need to configure '''SncMyName''', '''SncPartnerName''' and '''SncQop'''.
	* SncMode~~: Use value~~ '''1''' to ~~use SNC.~~
	* SncLibraryPath: Path to the encryption dll file (e.g., sapcrypto.dll)
	* SncMyName
	* SncPartnerName
	* SncQop

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* SNC encrypted connection */

2023-05-31T11:46:24Z

SNC encrypted connection

← Older revision		Revision as of 11:46, 31 May 2023
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	Connection to SAP can be encrypted using SNC which is a technique provided by SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In scripts, SNC is used in individual extractions commands (ExtractSap function and --#ImportSapQuery) by provided the needed [[~~/QL_Scripting_Commands~~#--.23ImportSapQuery\|parameters]]. Most important SCN related parameters are following:		Connection to SAP can be encrypted using SNC which is a technique provided by SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In scripts, SNC is used in individual extractions commands (ExtractSap function and --#ImportSapQuery) by provided the needed [[SQL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. Most important SCN related parameters are following:
	* SncMode: Use value '''1''' to use SNC.		* SncMode: Use value '''1''' to use SNC.
	* SncLibraryPath: Path to the encryption dll file (e.g., sapcrypto.dll)		* SncLibraryPath: Path to the encryption dll file (e.g., sapcrypto.dll)

Ollvihe: /* SNC encrypted connection */

2023-05-31T11:46:14Z

SNC encrypted connection

← Older revision		Revision as of 11:46, 31 May 2023
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	Connection to SAP can be encrypted using SNC which is a technique provided by SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). SNC is used in individual extractions commands ~~in scripts~~		Connection to SAP can be encrypted using SNC which is a technique provided by SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). In scripts, SNC is used in individual extractions commands (ExtractSap function and --#ImportSapQuery) by provided the needed [[/QL_Scripting_Commands#--.23ImportSapQuery\|parameters]]. Most important SCN related parameters are following:
			* SncMode: Use value '''1''' to use SNC.
	~~SncMode~~		* SncLibraryPath: Path to the encryption dll file (e.g., sapcrypto.dll)
			* SncMyName
			* SncPartnerName
			* SncQop

	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]

Ollvihe: /* SNC encrypted connection */

2023-05-31T11:42:31Z

SNC encrypted connection

← Older revision		Revision as of 11:42, 31 May 2023
Line 78:		Line 78:

	== SNC encrypted connection ==		== SNC encrypted connection ==
	Connection to SAP can be encrypted using SNC which is a technique provided by SAP.		Connection to SAP can be encrypted using SNC which is a technique provided by SAP. To take SNC into use, you need the dll file from SAP that provides the encryption functionality (e.g., sapcrypto.dll). Copy the file to the same location as the other SAP dll's (icudt50.dll, icuin50, icuuc50.dll, libsapucum.dll, sapnwrfc.dll). SNC is used in individual extractions commands in scripts

			SncMode


	[[Category: QPR ProcessAnalyzer]]		[[Category: QPR ProcessAnalyzer]]