The following steps are required to use SAP HANA with
Oracle Hyperion Financial Data Quality Management, Enterprise Edition.
-
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.
-
Import the SAP HANA technology from the:
<EPM_ORACLE_HOME>\products\FinancialDataQuality\odi\11.1.2.4.00\masterrep
folder.
-
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.
-
Import the HANA Adapter Project.
-
Create a connection to HANA, and map the logical schema UDA_HANA to it in the context.