Connections > SAP BW BEx Query connection properties > 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 SAP BW BEx Query 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 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 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.
    7. gClick Save.
    8. hRepeat steps 2 through 4 on every machine where you installed the Secure Agent.
  5. 5Restart the Secure Agent.

Configure SAP user authorization

Configure the SAP user account in the SAP system to process SAP BW BEx Query data.
The following table lists the objects and authorization required to configure user permissions to access and read data 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)
For more information about these objects and how to use them, see SAP user authorizations.