Example to Extract Data from SAP - Revision history

https://wiki.onqpr.com/pa/index.php?action=history&feed=atom&title=Example_to_Extract_Data_from_SAP Example to Extract Data from SAP - Revision history 2026-04-23T05:25:57Z Revision history for this page on the wiki MediaWiki 1.39.1 https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23490&oldid=prev Ollvihe at 18:16, 2 September 2023 2023-09-02T18:16:01Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:16, 2 September 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer <del style="font-weight: bold; text-decoration: none;">[[Running and Calling Scripts|</del>script<del style="font-weight: bold; text-decoration: none;">]] </del>(not in the Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The data for the staging tables can be located in the Snowflake. After this script is completed, the next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer script (not in the Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The data for the staging tables can be located in the Snowflake. After this script is completed, the next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all the required data in a single query due to the limitations of the RCF interface. As a workaround, several queries need to be made where each query has a different filter to get a slice of the entire data. For example, date ranges can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all the required data in a single query due to the limitations of the RCF interface. As a workaround, several queries need to be made where each query has a different filter to get a slice of the entire data. For example, date ranges can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23230&oldid=prev Ollvihe at 22:42, 15 June 2023 2023-06-15T22:42:39Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:42, 15 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]] (not in the Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]] (not in the Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The <ins style="font-weight: bold; text-decoration: none;">data for the staging tables can be located in the Snowflake. After this script is completed, the </ins>next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in <del style="font-weight: bold; text-decoration: none;">one </del>query due to the limitations of the RCF interface. As a workaround, <del style="font-weight: bold; text-decoration: none;">multiple </del>queries need to be <del style="font-weight: bold; text-decoration: none;">used and in </del>each query <del style="font-weight: bold; text-decoration: none;">set </del>a filter to get <del style="font-weight: bold; text-decoration: none;">only </del>a slice of the data. For example, <del style="font-weight: bold; text-decoration: none;">dates </del>can be used limit how much data one query returns.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all <ins style="font-weight: bold; text-decoration: none;">the </ins>required data in <ins style="font-weight: bold; text-decoration: none;">a single </ins>query due to the limitations of the RCF interface. As a workaround, <ins style="font-weight: bold; text-decoration: none;">several </ins>queries need to be <ins style="font-weight: bold; text-decoration: none;">made where </ins>each query <ins style="font-weight: bold; text-decoration: none;">has </ins>a <ins style="font-weight: bold; text-decoration: none;">different </ins>filter to get a slice of the <ins style="font-weight: bold; text-decoration: none;">entire </ins>data. For example, <ins style="font-weight: bold; text-decoration: none;">date ranges </ins>can be used limit how much data one query returns.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The script defines a temporary table ''#SAP_Parameters'' that contains the common SAP query related parameters used in all the queries. In addition, <del style="font-weight: bold; text-decoration: none;">is </del>query <del style="font-weight: bold; text-decoration: none;">add </del>its own query specific parameters.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The <ins style="font-weight: bold; text-decoration: none;">example </ins>script defines a temporary table ''#SAP_Parameters'' that contains the common SAP query related parameters used in all the queries<ins style="font-weight: bold; text-decoration: none;">, to avoid repeating the common values</ins>. In addition, <ins style="font-weight: bold; text-decoration: none;">each </ins>query <ins style="font-weight: bold; text-decoration: none;">adds </ins>its own query specific parameters <ins style="font-weight: bold; text-decoration: none;">to the common parameters. There is also a temporary table ''#SapWhereClauseTable'' containing parameters for the SAP query where clause</ins>.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">There is also a temporary table ''#SapWhereClauseTable'' containing parameters for the SAP query where clause.</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The actual extractions <ins style="font-weight: bold; text-decoration: none;">from SAP </ins>are <ins style="font-weight: bold; text-decoration: none;">performed by </ins>the[[SQL_Scripting_Commands#--.23ImportSapQuery|--#ImportSapQuery]] command.</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The actual extractions are <del style="font-weight: bold; text-decoration: none;">done with </del>the[[SQL_Scripting_Commands#--.23ImportSapQuery|--#ImportSapQuery]] command.</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><syntaxhighlight lang="typescript" line></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><syntaxhighlight lang="typescript" line></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-----------------------------------</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-----------------------------------</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23229&oldid=prev Ollvihe at 22:38, 15 June 2023 2023-06-15T22:38:06Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:38, 15 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]] (not <del style="font-weight: bold; text-decoration: none;">directly </del>in Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]] (not in <ins style="font-weight: bold; text-decoration: none;">the </ins>Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23228&oldid=prev Ollvihe at 22:37, 15 June 2023 2023-06-15T22:37:51Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:37, 15 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]]<del style="font-weight: bold; text-decoration: none;"><nowiki/>s </del>(not directly in Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page contains an example script to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script runs as the QPR ProcessAnalyzer [[Running and Calling Scripts|script]] (not directly in Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23227&oldid=prev Ollvihe at 22:37, 15 June 2023 2023-06-15T22:37:35Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:37, 15 June 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page <del style="font-weight: bold; text-decoration: none;">describes </del>an example <del style="font-weight: bold; text-decoration: none;">how </del>to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script <del style="font-weight: bold; text-decoration: none;">can only run </del>as QPR ProcessAnalyzer script (not directly in Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page <ins style="font-weight: bold; text-decoration: none;">contains </ins>an example <ins style="font-weight: bold; text-decoration: none;">script </ins>to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] and thus the script <ins style="font-weight: bold; text-decoration: none;">runs </ins>as <ins style="font-weight: bold; text-decoration: none;">the </ins>QPR ProcessAnalyzer <ins style="font-weight: bold; text-decoration: none;">[[Running and Calling Scripts|</ins>script<ins style="font-weight: bold; text-decoration: none;">]]<nowiki/>s </ins>(not directly in Snowflake). As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23052&oldid=prev Ollvihe at 21:51, 19 May 2023 2023-05-19T21:51:21Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:51, 19 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]]. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]] <ins style="font-weight: bold; text-decoration: none;">and thus the script can only run as QPR ProcessAnalyzer script (not directly in Snowflake)</ins>. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23048&oldid=prev Ollvihe at 16:04, 19 May 2023 2023-05-19T16:04:30Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:04, 19 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]]. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[<del style="font-weight: bold; text-decoration: none;">Example_to_Transform_SAP_Data_into_Eventlogs_in_Snowflake</del>|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]]. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[<ins style="font-weight: bold; text-decoration: none;">Example_to_Transform_SAP_Data_into_Eventlog_in_Snowflake</ins>|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23043&oldid=prev Ollvihe at 11:58, 19 May 2023 2023-05-19T11:58:31Z

<p></p> <a href="https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23043&oldid=23042">Show changes</a>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23042&oldid=prev Ollvihe at 11:53, 19 May 2023 2023-05-19T11:53:53Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:53, 19 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l8">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The actual extractions are done with the[[SQL_Scripting_Commands#--.23ImportSapQuery|--#ImportSapQuery]] command.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The actual extractions are done with the[[SQL_Scripting_Commands#--.23ImportSapQuery|--#ImportSapQuery]] command.</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><<del style="font-weight: bold; text-decoration: none;">pre </del>lang="typescript" line></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><<ins style="font-weight: bold; text-decoration: none;">syntaxhighlight </ins>lang="typescript" line></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-----------------------------------</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-----------------------------------</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- Adjust SAP extraction parameters</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- Adjust SAP extraction parameters</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1113">Line 1,113:</td> <td colspan="2" class="diff-lineno">Line 1,113:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>--#Exit</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>--#Exit</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div></<del style="font-weight: bold; text-decoration: none;">pre</del>></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></<ins style="font-weight: bold; text-decoration: none;">syntaxhighlight</ins>></div></td></tr> </table>

Ollvihe https://wiki.onqpr.com/pa/index.php?title=Example_to_Extract_Data_from_SAP&diff=23030&oldid=prev Ollvihe at 11:37, 19 May 2023 2023-05-19T11:37:43Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:37, 19 May 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]]. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[<del style="font-weight: bold; text-decoration: none;">Transform_SAP_Data_into_Eventlogs_in_Snowflake</del>|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This page describes an example how to extract data from SAP and load into QPR ProcessAnalyzer. This example uses the [[SQL_Scripting_for_ETL|SQL scripting]]. As a result, the extracted data is stored into QPR ProcessAnalyzer to tables that can be called ''staging tables''. The next step is to [[<ins style="font-weight: bold; text-decoration: none;">Example_to_Transform_SAP_Data_into_Eventlogs_in_Snowflake</ins>|transform the staged data into the eventlogs]] used by the QPR ProcessAnalyzer models.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sometimes, when using the RFC interface, it's not possible to get all required data in one query due to the limitations of the RCF interface. As a workaround, multiple queries need to be used and in each query set a filter to get only a slice of the data. For example, dates can be used limit how much data one query returns.</div></td></tr> </table>

Ollvihe