Regarding HFM repositary move from IBM DB2 to Oracle

SHARAD KUMAR JAISWAL

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.

CBarbieri

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

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

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

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