Connections > SAP BW Connector connection properties > 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 SAP BW data, 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 of the machine 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 of the machine 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 of the machine 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 SAP user authorization in the SAP system to access and read from SAP BW objects such as InfoCubes, InfoSets, MultiProviders, and DataStore objects.
The following table lists the authorization objects, fields, and values required to configure user permissions to access and read data 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.
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.
For more information about InfoAreas, see the SAP documentation.
RSINFOCUBE
Provide the InfoCube object names that you want to access.
For more information about InfoCubes, see the SAP documentation.
RSIRSICUBEOBJ
DEFINITION, DATA, UPDATERULE
ACTVT
3
You can also add the following authorization objects to configure user permissions to access and read data from SAP BW:
For more information about these objects and how to use them, see SAP user authorizations.

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. The transport files are applicable for SAP NetWeaver BW version 7.x.

Prerequisites to install the transport files

Before you install the SAP BW transports, make sure to perform the following prerequisite tasks:

Installing transport files

To install the SAP BW transport files, perform the following tasks:
  1. 1Locate 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.