Set up native SAP extraction

Introduction

It is possible to natively connect to an SAP application server, where SAP versions such as SAP R3, SAP ERP, SAP ECC 5.0, SAP ECC 6.0, S/4HANA are supported.

SAP datasources can be loaded by using the SAP connecting string type.

Prerequisites

Important:

To load the data from the SAP database you need an SAP account to be used to retrieve data. For reasons of compliance and data protection you must make sure that this SAP account used to retrieve data has limited access to SAP and only has the appropriate authorizations as described below.

Note that it is possible that the user who performs the actual data load from SAP has access to more data in Process Mining after loading the data than this user has in SAP, depending on the SAP authorizations of the user.

To be able to connect to the SAP datasource you must have:

access to the SAP application server.
the following information:
- host;
- system number;
- username;
- password;
- language;
- client.
SAP S_RFC authorization on the SAP application server which grants:
- Authorization for using RFC (Remote Function Calls) destinations;
- Authorization for calling function modules within a specific function group in an RFC destination (target system).
SAP S_TABU_NAM authorization for access to individual tables.

Minimal required access rights

If you do not want to grant an ALL permission, you must grant at least the following access rights:

SAP S_RFC authorization on the SAP application server:

+S_RFC RFC_TYPE : FUNC

FC_NAME : RFCPINGFUNCTION_EXISTS, RFCPING,RFC_GET_FUNCTION_INTERFACE,RFC_READ_TABLE, Z_XTRACT_IS_TABLE ACTVT : 16

RFC_TYPE : FUGR RFC_NAME : SYST RFC1,SDTX,SUNI,SYST, ZUIPATH ACTVT : 16

SAP S_TABU_NAM authorization on the SAP application server:

+S_TABU_NAM Activity 03 Table authorization group MA

SAP S_TABU_DIS authorization on the SAP application server:

+S_TABU_DIS Activity 03 Table name [TABLE LIST]*

*list of all SAP input tables used by the UiPath Process Mining connector or accelerator for which the native SAP extraction is set up.

Configuring UiPath Process Mining for Native SAP Extraction

Follow the steps below to configure UiPath Process Mining for native SAP extraction.

Step	Action
1	Go to the SAP ONE Support Launchpad website https://launchpad.support.sap.com/#/notes/2573790 and log in using your credentials for SAP.com.
2	Download the SAP NetWeaver RFC Library 7.50 (64-bits version)
3	From the SAP NetWeaver RFC library, copy the dll files to the `\System32` folder on the UiPath Process Mining server: `sapnwrfc.dll` `libsapucum.dll` `libicudenumber.dll` `icuucXX.dll` `icuinXX.dll` `icudtXX.dll` Note: XX is the version of the NW RFC library.
4	Go to the Microsoft Visual C++ Redistributable Packages for Visual Studio 2013 website https://www.microsoft.com/en-ie/download/details.aspx?id=40784. Click on Download.
5	Select `vcredist_x64.exe` and click on Next to download the file.
6	Run the `vcredist_x64.exe` to install the Visual C++ Redistributable Packages for Visual Studio 2013 (x64) on the UiPath Process Mining server.

Perform the following steps on the SAP system (not on the UiPath Process Mining Server):

Step	Action
1	Install the `Z_XTRACT_IS_TABLE` Function module in the SAP system from which you want to load datasources.
2	Activate the `Z_XTRACT_IS_TABLE` Function module.

Note: When setting up a native SAP extraction the SAP Z_XTRACT_IS_TABLE Function Module is required. If, for example, the Function Module is renamed in your SAP system, you can specify the correct name in the (optional) FunctionModule parameter in the SAP connection string.