Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Replace Query tracked Aggregate views of an ASO cube to another cube and aggregate | Main | Analytics and the APP! »

Migrate Oracle Hyperion Cloud Applications(PCMCS) on Autopilot!!! Using EPMAutomate


Migrate Oracle Hyperion Cloud Applications (PCMCS) on Autopilot!!! Using EPMAutomate


What is EPMAutomate?

EPMAutomate utility helps in automating administrator's activities for EPM Hyperion cloud products.


What is Migration and Why it is required ?

Migration of application in cloud is required to move an application from Test instance to Production instance and vice versa. Manual migration of application across the instance could take hours, it can be automated using EPMAutomate utility which subsequently reduce the time from hours to minutes. Migration of application includes Data, Metadata, Security, Data Management, Reports etc i.e every artifacts of application will be migrated using EPMAutomate utility without manual intervention. Migration can be server to cloud or cloud to cloud. It is always preferable to move backup artifact from server to cloud. Here example has been demonstrated with respect to PCMCS application .

Migration methods:


  1. Server to Cloud

  2. Cloud to Cloud


  1. Steps to automate Server to Cloud Migration from daily backups process using EPMAutomate utility in PCMCS


  1. Login into PCMCS Workspace by entering Identity Domain, User Name, Password and Click on Sign in



 

2. Delete existing application from instance if available, where new application will be migrated and imported from another instance.

Click Application->Application


3. Click on 'X' to delete application and click Yes


 

4. Now, modify the attached reusable sample batch script with relevant url and user credentials to automate Migration process using EPMAutomate utility

Sample Script:


@echo off

rem This script is used to perform On-Demand migration of Artifact Snapshot using

rem server backups i.e server to cloud migration

rem Update the parameters: url (Target url), Folder (source folder) and SnapshotName as per requirement

rem Please make sure application has been deleted from target instance before importing snapshot into it

SET url=

SET user=abc

SET password=D:\Oracle\password.epw

SET IdentityDomain=

SET Folder=D:\Oracle

SET SnapshotName=Artifact_Snapshot_09_13_2017_1322

SET UploadedSnapshot=%SnapshotName%.zip


call epmautomate login %user% %password% %url% %IdentityDomain%

timeout 10

call epmautomate uploadfile %Folder%\%UploadedSnapshot%

timeout 8

call epmautomate importsnapshot %SnapshotName%

timeout 10

call epmautomate logout           



5. Trigger .bat script :

Uploading relevant snapshot to cloud


 

 

6. Once migration completes, check for migration report in in PCMCS workspace.

Click Application->Migration->Reports->Migration Status

  

B) Steps to automate Cloud to Cloud Migration from daily backups process using EPMAutomate utility in PCMCS



  1. Follow steps 1 to 3 from section A

  2. Attached script to migrate artifact from one cloud instance to another

     

    'Copysnapshotfrominstance' command is used to move artifact snapshot across instances in cloud 

     

    Sample Script:

    @echo off

    rem This script is useful to migrate Artifact Snapshot from Test to Production instance 

    rem Update the following parameters based on requirement

    SET url=

    SET FromURL=

    SET user=

    SET password=D:\Oracle\password.epw

    SET IdentityDomain=

    SET SnapshotName=Artifact Snapshot

    call epmautomate login %user% %password% %url% %IdentityDomain%

    timeout 10

    call epmautomate copysnapshotfrominstance %SnapshotName% mdeshmukh %password% %FromURL% %IdentityDomain%

    timeout 8

    call epmautomate importsnapshot %SnapshotName%

    timeout 10

    call epmautomate logout


3.Rest of the steps are similar as in Section A

Reference(s)

https://docs.oracle.com/cloud/latest/epmcommon/CEPMA/epm_automate_command_links_pcmcs.htm#CEPMA-GUID-6BC610D3-03F0-41C4-8C52-FA1EE972D03F



 


 


Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles