1. Installation and Configuration Guide
  2. Upgrading EPM System (from 11.1.2.4 to 11.2.8)
  3. Importing Artifacts and Data for Release 11.2
  4. Importing FDMEE Artifacts
  5. Migrating the FDMEE Schema (SQL Server)

Migrating the FDMEE Schema (SQL Server)

The data migration process for Oracle Hyperion Financial Data Quality Management, Enterprise Edition uses SQL Server Integration Services (SSIS) to perform the migration. Review SQL Server documentation and familiarize yourself with the SSIS package.

This procedure requires a network connection between the Release 11.1.2.4.xxx environment and the Release 11.2 environment.

To migrate the FDMEE Schema (SQL Server):

  1. Stop the FDMEE service.

  2. Update the SSIS package with connection information, and then save the file:

    1. Open aif_migrate.dtsx using a text editor.
    2. Edit line numbers 27 and 31 to specify the database connection string for the destination database (the FDMEE Release 11.2 database):

      • Data Source—Specify the serverName:port. If you encounter connection errors, try entering serverName only, without the port.

      • User ID—Specify the SQL Server user used to configure the FDMEE Release 11.2 database.

      • Initial Catalog—Specify the name of the database used to configure FDMEE Release 11.2.

      • desstination_password—Specify the password (case-sensitive) in line number 31, by replacing password with the destination database password.

    3. Edit line numbers 42 and 46 to specify the database connection string for the source database (the FDMEE Release 11.1.2.4 database):

      • Data Source—Specify the serverName:port.

      • User ID—Specify the SQL Server user used to configure the FDMEE Release 11.1.2.4 database.

      • Initial Catalog—Specify the name of the database used to configure FDMEE Release 11.1.2.4.

      • source_password—Specify the password (case-sensitive) in line number 46, by replacing password with the source database password.

  3. Execute the SSIS Data Migration Package.

    The default location is <Local Drive>:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn

    1. Launch DTExecUI.exe.

    2. ForPackage source, select File System. For Package, browse to and select aif_migrate.dtsx.

    3. Click Execute.
    4. Review the Package Execution Process to ensure that there are no errors.

  4. After the import process is complete, execute the following SQL in the Release 11.2 database server environment to complete the database configuration. Log in as the user who owns the FDMEE tables for release 11.2 

    aif_post_import_updates.sql

    To execute the query, open SQL Server Management Studio, right-click the FDMEE 11.2 database, select New Query, copy the contents of aif_post_import_updates.sql, and then click Execute.

  5. Check for any errors. Fix any issues in the source and repeat steps 3 and 4 in sequence as needed.

    You can ignore errors related to dropping tables with the suffix _UPG in the name.