About EPM Automate
EPM Automate is a utility which enables service administrators to remotely perform a selection of routine tasks on their PBCS system. The EPM Automate commands are referenced in batch scripts, meaning repeatable tasks can be automated easily. This is particularly useful when the automated task cannot be set up as a scheduled job from within the PBCS interface. The following tasks can be performed remotely using EPM Automate commands:
Installing EPM Automate
Before you can use EPM Automate, it must be downloaded and installed to your local computer or server. To install the latest version of the EPM Automate utility:
By default, the EPM Automate Utility is installed in C:/Oracle/EPM Automate.
Taking automatic system backups using EPM Automate
One of the most useful commands available through EPM Automate is to download artefact snapshots of your application from your PBCS instance to your local computer. As you may know, a full artefact snapshot of your PBCS application is automatically taken every night by Oracle. This includes a full backup of everything that makes up your application, including; all business rules, all FDMEE artefacts, all dimension metadata, Essbase data, forms, task lists, security and reports.
These nightly snapshots are overwritten each night, meaning there will only be one copy of your application stored on the system at any one time. This can cause issues when needing to retrieve information from a system backup, which is why it is widely recommended to keep a seven-day rolling backup of your application. Artefact snapshots can be accessed and downloaded manually by a service administrator via the Application->Migration->Snapshots section of PBCS, however manually downloading the snapshot every day takes time and in the long run is not practical.
To avoid this manual work, the EPM Automate utility can be used to download and save the daily application snapshots automatically, enabling you to save multiple backups of your application to your computer with ease.
The EPM Automate function which enables this task is downloadfile, and is referenced in a batch script with the following syntax:
Call epmautomate login USERNAME PASSWORD URL IDENTITYDOMAIN
Call epmautomate downloadfile "Artifact Snapshot”
Call epmautomate logout
Where the parameters in the above script are as follows:
The file is downloaded as a zip file into the folder that EPM Automate was installed to. By default, this will be in directory C:\Oracle\EPM Automate. The snapshot file can then be moved to a more convenient location and renamed to keep as a backup of your PBCS application.
If you would like any more information on using EPM Automate to enhance your PBCS system, feel free to contact me or any of the team on 01483 685450.