SAP BW Connector > Connections for SAP BW Connector > Prerequisites
  

Prerequisites

Before you use an SAP BW connection, the SAP administrator needs to perform certain prerequisite tasks to configure the Secure Agent machine and SAP system.
To process data through SAP, you also need to verify if the required licenses are enabled for the SAP system.

Download and configure the SAP libraries

To read data from SAP BW objects, you need to download and configure the SAP JCo libraries on the Secure Agent machine. If you encounter any issues while you download libraries, contact SAP Customer Support.
  1. 1Go to the SAP Support Portal, and then click Software Downloads.
    2. Note: You need to have SAP credentials to access Software Downloads from the SAP Support Portal.
  2. 2Download the latest version of the 64-bit SAP JCo libraries based on the operating system on which the Secure Agent runs.
    3. Operating System
    SAP JCo Libraries
    Windows
    • - sapjco3.jar
    • - sapjco3.dll
    Linux
    • - sapjco3.jar
    • - libsapjco3.so
  3. 3Copy the JCo libraries to the following directory:
    4. <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\tpl\sap
    Create the deploy_to_main\bin\rdtm-extra\tpl\sap directory if it does not already exist.
  4. 4Log in to Informatica Intelligent Cloud Services and configure the JAVA_LIBS property for the Secure Agent.
    1. aSelect Administrator > Runtime Environments.
    2. bClick Runtime Environments to access the Runtime Environments page.
    3. cTo the left of the agent name, click Edit Secure Agent.
    4. dFrom the Service list, select Data Integration Server.
    5. eFrom the Type list, select Tomcat JRE.
    6. fEnter the JAVA_LIBS value based on the operating system on which the Secure Agent runs.
      7. Operating System
      Value
      Windows
      ..\bin\rdtm-extra\tpl\sap\sapjco3.jar;..\bin\rdtm\javalib\sap\sap-adapter-common.jar
      Linux
      ../bin/rdtm-extra/tpl/sap/sapjco3.jar:../bin/rdtm/javalib/sap/sap-adapter-common.jar
      Warning: If you copy the value directly from the table, the hyphens (-) in the value might be incorrectly copied. Copy the value to a text editor and make sure that the value you copied is not corrupted.
      The configured JAVA_LIBS property for the Secure Agent on Windows.
    7. gClick Save.
  5. 5After you save the JAVA_LIBS value, configure the JVMClassPath property for the Secure Agent.
    1. aFrom the Service list, select Data Integration Server.
    2. bFrom the Type list, select DTM.
    3. cEnter the JVMClassPath value based on the operating system on which the Secure Agent runs.
      4. Operating System
      Value
      Windows
      pmserversdk.jar;..\..\bin\rdtm-extra\tpl\sap\sapjco3.jar;..\..\bin\rdtm\javalib\sap\sap-adapter-common.jar
      Linux
      pmserversdk.jar:../../bin/rdtm-extra/tpl/sap/sapjco3.jar:../../bin/rdtm/javalib/sap/sap-adapter-common.jar
      Warning: If you copy the value directly from the table, the hyphens (-) in the value might be incorrectly copied. Copy the value to a text editor and make sure that the value you copied is not corrupted.
      The configured JVMClassPath property for the Secure Agent.
    4. dClick Save.
    5. eRepeat steps 2 through 5 on every machine where you installed the Secure Agent.
  6. 6Restart the Secure Agent.

Configure SAP user authorization

Configure the SAP user account in the SAP system to process SAP BW objects such as InfoCubes, InfoSets, MultiProviders, and DataStore objects.
For more information about how to configure SAP user authorization in the SAP system, see SAP user authorizations.
The following table describes the required authorization to read from SAP BW:
Authorization Object
Field
Value
S_RFC
RFC_TYPE
FUNC, FUGR
RFC_NAME
/INFADI/BWRDR, /INFADI/ZTEST_COMMUNICATION, BAPI_CUBE_GETLIST, DDIF_FIELDINFO_GET, BAPI_IOBJ_GETDETAIL, RFCPING, RFC_GET_FUNCTION_INTERFACE, RSAB, SYST
ACTVT
16
S_BTCH_JOB
JOBACTION
RELE
JOBGROUP
*
S_RS_ADMWB
RSADMWBOBJ
Provide the Administrator Workbench Object name from which you want to read data based on the requirements.
For more information about Administrator Workbench Objects, see the SAP documentation.
ACTVT
3
S_RS_ICUBE
RSINFOAREA
Provide the InfoArea names that you want to access based on the requirements.
For more information about InfoAreas, see the SAP documentation.
RSINFOCUBE
Provide the InfoCube object names that you want to access based on the requirements.
For more information about InfoCubes, see the SAP documentation.
RSIRSICUBEOBJ
DEFINITION, DATA, UPDATERULE
ACTVT
3
You can also add the following authorization objects based on the requirements of the SAP BW tasks that you run from Data Integration:

Install transport files for SAP BW

To read data from SAP BW objects from a Unicode SAP system, install the SAP BW transport files from the Secure Agent directory to the SAP system.
Ensure that the transport files you install on the SAP machines are the latest. Get the latest transport files from the following directory:
<Informatica Secure Agent installation directory>\downloads\package-bwreader.<Latest version>\package\rdtm\sap-transport\SAPBWReader

Prerequisites to install the transport files

Before you install the SAP BW transports, you need to perform the prerequisite tasks.

Installing transport files

To install the SAP BW transport files, perform the following steps:
  1. 1Find the transport files in the following directory on the Secure Agent machine:
    2. <Informatica Secure Agent installation directory>\downloads\package-bwreader.<Latest version>\package\rdtm\sap-transport\SAPBWReader
  2. 2Copy the cofile transport file to the Cofile directory in the SAP transport management directory on each SAP machine that you want to access.
    3. The cofile transport file uses the following naming convention: RUN_BWRDR_K<number>.g00
  3. 3Remove "RUN_BWRDR_" from the file name to rename the cofile. For example, for a cofile transport file named RUN_BWRDR_K900723.g00, rename the file to K900723.g00.
  4. 4Copy the data transport file to the Data directory in the SAP transport management directory on each SAP machine that you want to access.
    5. The data transport file uses the following naming convention: RUN_BWRDR_R<number>.g00
  5. 5Remove "RUN_BWRDR_" from the file name to rename the file.
    6. For example, for a data transport file named RUN_BWRDR_R900723.g00, rename the file to R900723.g00.
  6. 6To import the transports to SAP, in the STMS, click Extras > Other Requests > Add and add the transport request to the system queue.
  7. 7In the Add Transport Request to Import Queue dialog box, enter the request number for the cofile transport.
    8. The request number inverts the order of the renamed cofile as follows: g00K<number>
    For example, for a cofile transport file renamed as K900723.g00, enter the request number as g00K900723.
  8. 8In the Request area of the import queue, select the transport request number that you added, and click Import.