1. Integrating Oracle Data Relationship Management Suite with Enterprise Performance Management
  2. Using Data Relationship Management with FDMEE
  3. Configuring FDMEE Metadata in Data Relationship Management
  4. Configuring the External Connections to the FDMEE Database

Configuring the External Connections to the FDMEE Database

The external connections must be properly configured before viewing, running, or editing the import and export defined in the application template.

Oracle Hyperion Financial Data Quality Management, Enterprise Edition writes to these tables:

  • AIF_HS_DRM_LOADS––Version import section

  • AIF_HS_DRM_LOAD_HIERARCHIES––Hierarchy import section

  • AIF_HS_DRM_MEMBER_V––Node import section

  • AIF_HS_DRM_HIERARCHY_V––Relationship import section

Oracle Data Relationship Management exports the member mappings to the TDATAMAP_STG table.

Note:

The FDMEE database must be in place and set up before performing this task.

After loading the application template, follow these procedures to configure the external connections:

FDMEE Import Database

To configure the FDMEE import database:

  1. Login to the Data Relationship Management system with an account that has the administrator role.

  2. On the Home page, select Administer.

  3. Expand External Connections and double click the FDMEE Export DBconnection.

  4. Define the Connection String, User ID and Password to connect to the FDMEE database.

  5. Click Test Connection to verify that a connection is made with the credential entered.

  6. Select the Include Viewscheckbox.

  7. Fill in the Filter (Schema and Object) with the schema for the FDMEE database and AIF_HS_DRM* and then click Retrieve Objects.

  8. Remove the initial FDMEE_INTEGRATION.AIF_HS_DRM* tables (4) by clicking Remove All.

  9. Highlight the four tables that start with AIF_HS_DRM* in the Available objects and then click Select to move them to the Selected column.

  10. Click Save to save the changes to the external connection.

FDMEE Export Database

To configure the FDMEE export database:

  1. Login to the Data Relationship Management system with an account that has the administrator role.

  2. On the Home page, select Administer.

  3. Expand External Connections and double click the FDMEE Export DBconnection.

  4. Define the Connection String, User ID and Password to connect to the FDMEE database.

  5. Click Test Connection to verify that a connection is made with the credential entered.

  6. Fill in the Filter (Schema and Object) with the schema for the FDMEE database and TDATAMAP_STG and then click Retrieve Objects.

  7. Remove the initial FDMEE_INTEGRATION.TDATAMAP_STG by clicking Remove All.

  8. Highlight TDATAMAP_STG in the Available objects and then click Select to move it to the Selected column.

  9. Click Save to save the changes to the external connection.