Enabling FDM Applications

You can enable applications registered in FDM to be registered as target applications in FDMEE. Use this for Oracle Hyperion Strategic Finance or Oracle Hyperion Enterprise® are registered in FDM, but are not registered in Oracle Hyperion Shared Services. After you enable the applications, define import formats, locations, and data load rules in FDMEE.

Note:

FDMEE 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. From the Setup tab, and then under Register, select FDM Application.

    This feature is for upgrade customers, who integrated from ERPI to FDM.

  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 FDMEE database, select Remote.

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

    Note:

    FDM and FDMEE 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, in JDBC URL, 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.