Configuring SAP Data Source Access and Authentication

To configure Reporting and Analysis (Web Analysis, and Production Reporting) to access SAP JAVA Connector (SAP JCo) data sources and optionally to authenticate users against an SAP server, install the SAP JCo files to each Reporting and Analysis component machine.

  To configure Reporting and Analysis to use SAP as a data source and optionally to use SAP as an authentication provider:

  1. Obtain the SAP JCo files:

    • From your SAP distribution

    • Download from the SAP Web site as a registered user at https://service.sap.com/connectors

  2. (Windows) After Reporting and Analysis installation:

    1. Place the SAP JCo binaries in EPM_ORACLE_HOME/common/SAP/bin.

    2. Place the SAP JCo java archives (JAR files) in EPM_ORACLE_HOME/common/SAP/lib.

    3. Expand the JAR file, using the convenience utility, in EPM_ORACLE_HOME/common/SAP/lib/explodejarUsingJRE.bat|sh.

  3. UNIX: After Reporting and Analysis installation, place the SAP JCo binaries in EPM_ORACLE_HOME/common/SAP/bin. Place the SAP JCo java archives (.jar files) in EPM_ORACLE_HOME/common/SAP/lib.

  4. Optional: To configure Reporting and Analysis to use SAP as an authentication provider:

    1. Download these files from the SAP Enterprise Portal EP60 SP2 or later into EPM_ORACLE_HOME/common/SAP/lib.

      For the 64-bit version of Financial Reporting, use EPM_ORACLE_HOME/common/SAP-64/lib.

      • com.sap.security.core.jar

      • com.sap.security.api.jar

      • sap.logging.jar

      • iaik_jce.jar

      • iaik_jce_export.jar (if using the export version of the IAIK-JCE libraries)

    2. After installation, expand the JAR files, using the convenience utility, in

      EPM_ORACLE_HOME/common/SAP/lib/explodejarUsingJRE.bat|sh

      For the 64-bit version of Financial Reporting, use EPM_ORACLE_HOME/common/SAP-64/lib/explodejarUsingJRE.bat|shs.