Working with Universal Data Adapter Source Systems

Before you use the universal data adapter in Oracle Hyperion Financial Data Quality Management, Enterprise Edition, register the data source from which you want to import data.

FDMEE supports data extraction from the following data sources:

• Oracle Data Source – UDA_ORCL

• MSSQL Server Data Source – UDA_MSSQL

• MySQL Data Source – UDA_MYSQL

• Teradata Data Source – UDA_TD

• DB2 Data Source – UDA_UDB

• DB2 400 Data Source - UDA_DB2/400

• SAP Hana – UDA_HANA

To add a source system for a universal data adapter:

1. On the Setup tab, under Register, select Source System.
2. In Source System, click Add.
3. Enter the source system details:
   1. In Source System Name, enter the source system name.

      Enter the name you want to use for the Data Source, such as "Oracle Receivables Data" or "MYSQL Payables Data", which indicates the specific data source.

   2. In Source System Description, enter a description of the source system.
   3. In Source System Type, select the type of source system of the universal data adapter.
      
      
      
   4. In ODI Context Code, specify the context code defined in ODI for the connection to the specific instance.

      The ODI context code refers to the context defined in Oracle Data Integrator. A context groups the source and target connection information.

      When data is sourced from another instance of a same seeded technology (Oracle, MSSQL, MYSQL, Teradata, DB2, or DB2 400), then use another source system of the same technology type with a different Context. In the Context, they should map the logical schema belonging to the source system type to the other instance.

4. Click Save.

   After you add a source system, select the source system in the summary region, and the details are displayed in the lower pane.