Forum Stats

  • 3,838,819 Users
  • 2,262,400 Discussions
  • 7,900,762 Comments

Discussions

Regarding HFM repositary move from IBM DB2 to Oracle

SHARAD KUMAR JAISWAL
SHARAD KUMAR JAISWAL Member Posts: 13 Blue Ribbon
edited Jul 10, 2018 9:12AM in Financial Consolidation

Did someone tried to move HFM repositary from IBM DB2 to Oracle database? If yes then can you please let me know what tool or process being used to do this.

Tagged:

Answers

  • CBarbieri
    CBarbieri Member Posts: 1,011 Gold Trophy
    edited Jul 9, 2018 2:03PM

    The HFM copy application utility can be used for this. It has been a very long time since I've seen an HFM customer using DB2, but I know the utility does support moving between Oracle and SQL Server. It should also work with DB2. The utility has shipped with all versions of HFM through 11.1.2.3. You can also download it:

    •11.1.2.3.702 PSU, PSE 22323578.

    •Download p22323578_11123000_MSWIN-x86-64.zip, unzip it, and you’ll see them:

    •\22323578\files\products\FinancialManagement\Utilities

    •Copy contents of that folder to any 11.1.2.4 server and these     utilities should work

    - Chris

  • SHARAD KUMAR JAISWAL
    SHARAD KUMAR JAISWAL Member Posts: 13 Blue Ribbon
    edited Jul 9, 2018 3:25PM

    Thanks for quick reply. So this is totally different utility than upgrade utility right. Also here is the upgrade plan which we are going through.

    HFM 11.1.1.4 (Current production) to HFM 11.1.2.3 (Staging environment)

    HFM 11.1.2.3 (Staging environment) to 11.1.2.4 (Future production)

    Do you suggest to use application upgrade utility to move to 11.1.2.3 (DB - IBM DB2) from 11.1..1.4 and then run copy application utility to copy the data from IBM DB2 to Oracle DB using HfmCopyApplication_x64.exe from 11.1.2.3 to 11.1.2.4. Also one more thing we are using classic application not EPMA.

    Thanks,

    Sharad

  • CBarbieri
    CBarbieri Member Posts: 1,011 Gold Trophy
    edited Jul 9, 2018 6:13PM

    This is a bit more complicated because you have an upgraded added into the activities. You may be able to copy the application from 11.1.1.4 with DB2 to 11.1.2.3 with Oracle DB, run the schema upgrade once its in 11.1.2.3, then upgrade 11.1.2.3 to 11.1.2.4. I think the issue you have to research has to do with the versions of DB2 and Oracle DB that are supported for each 11.1.1.4, 11.1.2.3, and 11.1.2.4. I don't recall if you can use the same version of DB2 on 11.1.1.4 as you can on 11.1.2.3. If you can use that, I suppose you could upgrade within DB2 first to 11.1.2.4, then use the copy app utility to move it to Oracle DB within the 11.1.2.4 environment.

    This is uncharted territory because so few customers use DB2 (I would guess it's less than a dozen worldwide, out of maybe 4,000 HFM customers), and because you are migrating from such an old version of HFM (11.1.1.4 has not been supported for years). As a fall-back, I might simply build a new shell in 11.1.2.4 and migrate the application piece by piece using application, data, and journal extracts. Reconsolidate and then tie out the results against the original 11.1.1.4 application. This would save you the work of installing the interim 11.1.2.3 environment and trying to run the copy app plus the schema upgrade. You would only lose the audit trails from process management, but this could be faster and more easily supported.

    - Chris

  • SHARAD KUMAR JAISWAL
    SHARAD KUMAR JAISWAL Member Posts: 13 Blue Ribbon
    edited Jul 10, 2018 9:12AM

    Once again thanks for your quick response. We will try this and let you know.

This discussion has been closed.