Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
EPMA enabled HFM application data migration
Hi,
I have an EPMA enabled HFM applicaton (version 11.1.2.2.300, OS: Windows Server 2008) that I need to clone on another environment for disaster recovery purposes. I've been following this document in order to have an understanding of the underlying structures HFM http://www.oracle.com/technetwork/middleware/bi-foundation/hfm-data-migration-130030.pdf.
Being this an EPMA enabled application what I thought is that I cannot use the HFM Copy Application before having the EPMA application in the target environment.
What I did, so, is to migrate through LCM the EPMA artifacts, deploy it in order to have the HFM application, then import through LCM the HFM artifacts. Then data tables have been copied across schemas, as per the above oracle document.
Everything went fine, and I could migrate and automate the export\import of the metadata, but I still have a problem with the data, which are not visible in the target application.
What I found is that the metadata IDs are different in the two environments, and I think this is due to the fact that in the target I deployed the EPMA application in order to have the HFM one, but I would really appreciate if someone could confirm my understanding.
In the document is stated that this should be the right approach (migrate EPMA, copy relevant tables) but this is not working for me. If I resolve the IDs in the metadata they are different between the two environments, and in the data tables the intersections are identified by the IDs, and also the Scenario in the tables name uses (if I understood properly) the id in the Scenario (which is different).
What should be the correct path to migrate an EPMA enabled application (I have access to the schemas) so that an alignment would require only the copy of the tables and the data from the DBAs?
Thank you,
bidi
Answers
-
Hi. To move the data extract it and then load using the interface or ODI or another tool. A database copy won't work as you're seeing. Also do the same with journals.
Eric
Eric Erikson, CPA
Independent HFM Consultant
828-485-8454
www.linkedin.com/in/ericerikson
ericerikson.blogspot.com