SAP BW BEx Query Connector > Connections for SAP BW BEx Query > Prerequisites
  

Prerequisites

Before you use an SAP BW BEx Query 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 BEx Query, 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.
    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 BEx Query data.
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 BEx Query:
Read Object Name
Authorization
S_RFC
RFC1, RFC_METADATA, RFC_METADATA_GET, RSAB, RSOB, RS_UNIFICATION, SDTX, SUGU, SU_USER, SYST
S_RS_COMP
ACTVT=3 (DISPLAY)
S_RS_COMP1
ACTVT=3 (DISPLAY)
S_RS_ICUBE
ACTVT=3 (DISPLAY)