Setting up the Integration

Oracle Data Relationship Management integration with Oracle Hyperion Financial Data Quality Management, Enterprise Edition is enabled in the Target Application. When Data Relationship Management integration is enabled, you can export metadata to Data Relationship Management and import member mapping from Data Relationship Management.

To begin integrating Data Relationship Management with FDMEE, apply Data Relationship Management Release 11.1.2.4.340 Patch Number 23012151. Refer to the readme for patch 23012151 for install instructions. The FDMEE application template is installed as part of the Data Relationship Management installation. You use the template to configure the Data Relationship Management metadata to enable integration with FDMEE.

To register target applications:

  1. On the Setup tab, under Register, select Target Application.
  2. In Target Application, in the Target Application summary grid, click Add.
  3. Add a target application or select a target application.

    For information on adding a target, see Registering Target Applications.

  4. Click Enable DRM.
  5. From Application Details, select the DRM Options tab.

    Image shows DRM options tab.

  6. In Adapter API URL, specify the full Data Relationship Management API adapter URL.

    The adapter URL specifies the Data Relationship Management application to use for internal communication with the Web Service.

  7. In Web Service URL, specify the URL of the full Data Relationship Management Web Service Definition Language (WSDL) of the web service used to access the Data Relationship Management web service.

    Enter the machine computer name of the Web Services application, and the port number to which oracle-epm-drm-webservices is deployed.

  8. In Username, specify the user name used to access the Data Relationship Management.
  9. In Password, specify the password used to access the Data Relationship Management.
  10. In Import to DRM Profile (Metadata), specify the name of the import profile.
    Import profiles update dimensions from Data Relationship Management, interface tables, and flat files. Import profiles also enable you to merge dimension updates merged with the shared library, or replace the entire contents of the dimension. Import profiles may map the columns from the source to their corresponding EPMA properties.

    The Import profile contains the FDMEE target application name, IP address, and Data Relationship Management target application name.

    The import profile can be overridden in the Integration option tab in locations.

    Import profiles are built in Data Relationship Management. Data Relationship Management ships template profiles, which can be used as is or customized. Template profile names are stored in FDMEE.

  11. In Export from DRM Profile (Mapping), specify the name of the export profile.

    An export profile enables you to export segment values and hierarchies from Data Relationship Management. Export profiles are based on export types which output data in different formats. Export types can include hierarchy, comparison, integration, version, property, and log exports.

    The DRM Export Profile contains the FDMEE target application name, IP address, and Data Relationship Management target application name.

    The export profile can be overridden in the Integration option tab in locations.

    Export profiles are built in Data Relationship Management. Data Relationship Management ships template profiles, which can be used as is or customized. Template profile names are stored in FDMEE.

  12. In Target Application, click Save.
  13. Click Refresh DRM Profiles to show the list of Import Profiles, Export Profiles, and domains in list of values.
  14. Define the dimension details.

    See Defining Application Dimension Details.