X

Proactive insights, news and tips from Oracle Hyperion EPM and BI Support. Learn Oracle from Oracle.

How can I use the Oracle Cloud Infrastructure (OCI) to create my LCM Snapshots for Enterprise Performance Management (EPM) Cloud?

Tanya Heise
Sr Principal Technical Support Engineer

This article describes how a customer can download a snapshot from an EPM Cloud instance on an OCI (Oracle Cloud Infrastructure) instance, and then archive it to either an Object Store or OCI block storage.

Downloading a Snapshot from an EPM Cloud Instance

There are two ways (REST API and EPM Automate) to download a snapshot from an EPM Cloud instance on an OCI instance.

  • REST API

curl -u username:password serviceURL /interop/rest/11.1.2.3.600/applicationsnapshots/Artifact Snapshot/contents > snapshotFile

Example:
curl -u joe.smith@xyz.com:Su12!* https://planning-domain.pbcs.us2.oraclecloud.com/interop/rest/11.1.2.3.600/applicationsnapshots/Artifact Snapshot/contents > snapshot

mv snapshot snapshot.zip

For more information, refer to REST API documentation for downloading LCM snapshots.

  • EPM Automate

epmautomate downloadfile “Artifact Snapshot”
mv “Artifact Snapshot.zip” snapshot.zip

At the end of this step, you will have a snapshot file named snapshot.zip

For more information, refer to EPM Automate documentation for downloading files.


Archiving a Snapshot on an Object Store:

1. Create OCI Bucket for snapshots

A Compartment is required to provide permissions and access to Object resources. In the OCI Console, create the Compartment with the related Namespace and a Bucket (if they do not already exist). The Object Storage namespace serves as a top-level container for all buckets and objects and allows you to control bucket naming within your tenancy.

Examples:
Namespace:         epmclouddev
Bucket name:         lcm_backup

 

2. Upload to Object Store - two options.

3. Verify uploaded snapshot

You can verify the existence of the upload with the following GET command in the oci-curl program:

 ./oci-curl.sh objectStoreURL get “/n/namespace/b/bucket/o/” > {"objects":[{"name":“snapshotName"}]}

Example:

./oci-curl objectstorage.us-phoenix-1.oraclecloud.com get “/n/epmclouddev/b/lcm_backup/o/”

Returns:
> {"objects":[{"name":“snapshot}]}

 

Archiving a snapshot on OCI Block Storage

Syntax:
timestamp=`date +%m_%d_%Y_%I%M`
mv  snapshot.zip snapshot_${timestamp}.zip

For more information, refer to EPM Automate example of archiving a snapshot to local storage.

=============================================================================================================

Refer to the links below for more information:

Join the discussion

Comments ( 2 )
  • Nehal Thaker Monday, July 13, 2020
    Hello Tanya,

    The information shared is quite useful. I wanted to know if you can provide more information on using OCI to integrate the metadata & data files from different source systems to PBCS. And would it require the use of REST API or EPM Automate or is there any way we can avoid using them.

    Thanks
  • admin Thursday, July 30, 2020
    Hi Nehal, I reached out to the person who authored this presentation about your question. They stated that you will need to use REST API or EPM Automate (or other Data Integration methods like EPM Agent) to integrate with EPM Cloud. There is no “direct” connection between an OCI instance and EPM Cloud. Thank you.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.