SAP Connector Guide > Part II: SAP Connector Administration > SAP Connector Administration > SAP BW BEx Query Connector Administration
  

SAP BW BEx Query Connector Administration

Before you can use an SAP BW BEx Query connection to read BEx query data, you must perform the following tasks:
  1. 1. Verify if the required licences are enabled.
  2. 2. Download and configure the SAP JCo libraries to read BEx query data.

Step 1. Verifying if the Required Licences are Available for SAP BW BEx Query Connector

You must verify if the required licences for SAP BW BEx Query Connector are available before you create an SAP BW BEx query connection and read data from SAP BEx queries.
    1. In the Informatica Cloud page, click the Administer tab.
    2. Under Connector Licences, verify if the SAP BW BEx Query Connector licence is enabled.
    3. Under Packages, verify if the following packages are assigned:
    If any of the packages are missing, contact Informatica Global Customer Support to enable the missing license for these packages. When the required licenses are enabled, the packages appear in the Packages section.

Step 2. Downloading and Configuring the Libraries for SAP BW BEx Query Data Extraction

Before you can use an SAP BW BEx query connection, you must download the SAP JCo libraries from the SAP Service Marketplace and configure them on the machine where the Secure Agent runs.
Contact SAP Customer Support if you encounter any issues with downloading the libraries.
    1. Go to the SAP Service Marketplace: http://service.sap.com/connectors
    Note: You will need SAP credentials to access the Service Marketplace.
    2. Download the most recent version of the 64-bit SAP JCo libraries based on the operating system on which the Secure Agent runs:
    Secure Agent System
    SAP File Name
    Windows
    sapjco3.jar
    sapjco3.dll
    Linux
    sapjco3.jar
    libsapjco3.so
    3. Copy the JCo libraries to the following directory:
    <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. Configure the JAVA_LIBS property in Informatica Cloud.
    1. a. Log in to Informatica Cloud.
    2. b. Click Configure > Runtime Environments to access the Runtime Environments page.
    3. c. To the left of the agent name, click Edit Secure Agent.
    4. d. From the Service list, select Data Integration Server.
    5. e. From the Type list, select Tomcat JRE.
    6. f. Enter 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
    7. g. Click OK to save the changes.
    8. h. Repeat steps 2 through 7 on every machine where you installed the Secure Agent.
    5. Restart the Secure Agent.