This procedure is required if you want to use interface tables in Performance Management Architect. Interface tables consist of a set of tables and or views that enable the import of metadata and data from external systems into Performance Management Architect. Before importing metadata and data from interface tables, you must configure interface tables in Performance Management Architect. You configure the tables by creating data source links that can be used during profile creation and data synchronization.
If you plan to use Performance Management Architect with FDMEE, the interface data source must be in the FDMEE database schema. In addition, if using Oracle Hyperion Financial Data Quality Management Enterprise Edition, you should deselect the option to create interface tables in the procedure below.
To create an interface data source:
Enter the name and the port number of the server hosting the database. (The defaults display based on the database type.)
After you finish the wizard, the properties of the new data source (for example, its name, description database type, and database server) are displayed on the Interface Data Source tab.
After you complete the configuration, a set of sample tables is created in the database. For a complete list of the sample tables, see Defining Interface Tables.
You can review the configuration log (EPM_ORACLE_INSTANCE/diagnostics/logs/config), correct errors, and rerun the wizard.