Setting up the Open Interface Adapter

The Open Interface Adapter is used to map data from the open interface table (AIF_OPEN_INTERFACE) to the Oracle Hyperion Financial Data Quality Management, Enterprise Edition staging tables. Typically, the Open Interface Adapter is used to load from a source not supported with a pre-packaged adapter. The Open Interface Adapter eliminates the need to process and manage data files, but the user is responsible for loading the table. Load methods include:

  • Event script in FDMEE

  • ODI

  • SQL Loader

  • anything

You configure this adapter using FDMEE to populate the staging table with the related data from the open interface table. You load the open interface table with the tool of your choice like a pl/sql routine, a sql loader script or a custom program. When you use ODI to load the open interface table, you can customize the Open Interface Adapter ODI package shipped with FDMEE to call a custom ODI interface to load the open interface table as a step in the data load process.