1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Loading Data Using a Universal Data Adapter
  5. Configuring SAP HANA

Configuring SAP HANA

The following steps are required to use SAP HANA with Oracle Hyperion Financial Data Quality Management, Enterprise Edition.

To set up SAP HANA:

  1. Download the jdbc jar used to connect to SAP HANA (njdbc.jar) to the target location: \Oracle\Middleware\user_projects\domains\EPMSystem\lib.
    The jdbc jar file is provided by SAP.
  2. Import the SAP HANA technology from the: <EPM_ORACLE_HOME>\products\FinancialDataQuality\odi\11.1.2.4.00\masterrep folder.
  3. Create the SAP Model in the model folder " Universal Data Adapter Model" with the following values:
    • Name––HANA source
    • Code––HANA_SOURCE
    • Technology––SAP HANA
    • Logical Schema––UDA_HANA

    Note:

    If the model folder "Universal Data Adapter Model" is not available, import it from the following location: <EPM_ORACLE_HOME>\products\FinancialDataQuality\odi\11.1.2.4.00\workrep.
  4. Import the HANA Adapter Project.
  5. Create a connection to HANA, and map the logical schema UDA_HANA to it in the context.