Enabling FDM Applications

You can enable applications registered in FDM to be registered as target applications in ERP Integrator. For example, Oracle Hyperion Strategic Finance, Fusion Edition or Hyperion Enterprise are registered in FDM, but are not registered in Oracle's Hyperion® Shared Services. After you enable the applications, you can define import formats, locations, and data load rules in ERP Integrator.

Note:

ERP Integrator supports loading data and drill through for FDM applications, but does not support loading metadata or writing-back data for applications registered in FDM.

  To enable FDM applications:

  1. In the Tasks pane, select FDM Application.

    The FDM Application page is displayed.

  2. Click Add.

  3. In the Name field, enter the FDM application schema name.

  4. Enter the User Name and Password for the application schema.

  5. Optional: Select Remote Database.

    If FDM accesses a database that is different from the ERP Integrator database, select Remote.

    If FDM accesses the same database as ERP Integrator, do not select Remote Database since ERP Integrator obtains the connection information from the Oracle's Hyperion Shared Services Registry.

    Note:

    FDM and ERP Integrator must be on the same database platform. Either on Oracle or SQL Server.

  6. For SQL Server databases only: Enter the SQL Server Database Name.

  7. If you selected Remote Database, click Search button. to select a generic JDBC URL address. Then, modify the <host>, <port>, and <SID>. For example, server.oracle.com:1521:orcl.

  8. To test the connection, click Test Connection.

  9. Click Save.

  10. Define the import format. See Working with Import Formats.