Creating the Source Adapter

A source adapter is an integration framework in Oracle Hyperion Financial Data Quality Management, Enterprise Edition that enables you to extract data from the source system in a flexible and customizable manner. When you configure Oracle Data Integrator with a universal source adapter, ODI extracts the data directly to a temporary data table used for transforming data from source to target in a data rule execution (tdataseg_t).

As another step in implementing the universal data adapter feature, create a definition that instructs how data is populated in FDMEE from the source table through ODI.

For the source adapter, FDMEE seeds and sets up the source adapter for the following six data sources:

• Oracle

• MSSQL

• MYSQL

• Teradata

• DB2

• DB2 400

• SAP Hana

To create the source adapter:

1. On the Setup tab, under Register, select Source Adapter.
2. In Source Adapter, from the Source Adapter summary task bar, click Add.

   A blank entry row is added to the Source Adapter summary section.

   Complete the following steps in the Source Adapter details section.

3. In Adapter Key, enter a user defined identifier for the adapter.
4. In Adapter Name, enter a user defined name for the adapter.
5. In Source System Type, select the technology type:

   Available options:

   • Oracle

   • MSSQL

   • MYSQL

   • Teradata

   • DB2 UDB

   • DB2 400

   • SAP Hana

   Based on the source system type, the following fields are populated automatically:

   • ODI Package Name

   • ODI Project Code

6. In Table Name, specify the source table name.
7. Click Save.