Posts

Oracle EPM 11.2 Installation How To

Image
There have been some very helpful blogs and twitter posts out there commenting on the Oracle EPM 11.2 installation so I'd like to thank these lovely people:
Dave Shay: http://www.epmonprem.pro/That EPM Bloke: http://hyperipwn.blogspot.com/AJ Martelino https://twitter.com/HyperionInfra I’ve taken some of the info from the resources above and my own trial an error and come up with a condensed Oracle EPM 11.2 installation crib sheet. I’d recommend getting an Oracle EPM infrastructure consultant to do this for you as it’s quite involved. Oracle have had years to get this right so I really can’t understand how they’ve made such a mess of it. Multiple RCUs?!


Server Preparation I used the following 3rd party software versions. Check the EPM Certification Matrix for full details
Windows Server 2019SQL Server 2016Windows Firewall
Turn off notifications and blocking for Domain and Local Network.Windows Defender
Turn off on-access scanning.Other Bits
Create a new user with administrator privilege…

OAC Remote Data Gateway Part 2: The RPD

Image
OAC Data Gateway 105.4: Now with added RPD goodness In one of my previous posts (here) I went through the setup of the Oracle Analytics Cloud Data Gateway utility. I showed how this could be used to connect your OAC instance to your on-premises data sources without the need of opening firewalls etc.

One missing piece of the puzzle was how to get the OAC RPD semantic layer to connect to on-premises using Data Gateway. This is a key piece of functionality that all current OBIEE customers will need if they want to connect their existing dashboards to their on-premises datasources.  Thankfully with the release of OAC 105.4 it is now possible to connect your to your on-premises data sources via your RPD using Data Gateway.

Prerequisites:
Install the latest version of OAC Data Gateway from hereInstall the OAC 105.4 Admin Tool on the SAME machine
Okay, that's it for pre-reqs :)

Alors mon cher ami, how do I get this to work? Here are the steps to connect your OAC Cloud RPD to your on-prem…

OCI - Installing EPM Automate on Always Free Oracle Linux

Image
Using Oracle's FREE Cloud VMs to Store your EPM Cloud Snapshots Unless you have been living under a rock for the past month you will know that Oracle have released their "Oracle Cloud Free Tier". This consists of the following services FOR FREE!
https://www.oracle.com/uk/cloud/free/


I've enjoyed playing with ADW and APEX, an incredible combo which will enable us to build simple applications to enhance our existing EPM Cloud apps.

The two free Oracle Cloud Infrastructure Compute VMs also caught my attention. These could of course be used for a multitude of things, one of which could be a host for EPM Automate and a location to store EPM Cloud snapshots.
Installing EPM Automate on Oracle Linux OCI There are several blogs out there on how to setup your instance. Here is a good one from APEX guru Dimitri:
https://dgielis.blogspot.com/2019/09/free-oracle-cloud-6-create-vm-instance.html
So, once you've got your VM running you can install EPM Automate.

Download the Linux …

OAC - Starting and stopping instances using the REST API (Autonomous/Oracle Managed)

Image
We waited a while to be able to start and stop OAC Oracle Managed (autonomous) instances through the OAC console but there isn't a way to schedule the starting and stopping of instances in the console. This is of course very important if you want to keep costs down by automatically shutting down your instances overnight for example.


Thankfully there are now REST API calls available for Oracle Managed OAC instances which allow you to stop and start your instances. You can schedule these commands from a scripting tool of your choice to automate this process e.g. create a batch script and schedule the start/stop using the Windows scheduler.

OAC Start Instance REST API Call The call to start the instance is a follows:

curl -v -i -X POST -u username:password -H
"Content-Type:application/vnd.com.oracle.oracloud.provisioning.Service+json"
-H "X-ID-TENANT-NAME:idcs-<IDCS-Account-Name>"
"https://psm-cacct-<PSM-Account-Name>.console.oraclecloud.com/paas/api/…

OAC Remote Data Gateway: Connecting to MS SQL Server

Image
The objective of this blog is to describe what the OAC Remote Data Gateway is, how it is configured and how to us it to connect an OAC instance to an on-premises MS SQL Server database (although the process will be the same connecting to any other on-premises data source).


The Oracle Analytics team have released a utility called the ‘Oracle Analytics Cloud Data Gateway’ which enables OAC to easily connect to your on-premises datasources with minimal fuss and WITHOUT HAVING TO OPEN UP FIREWALL PORTS!

No more awkward conversations with your network admin. No more grovelling and bribing them to open up ports in their firewall.

Current supported data sources are:

Oracle databaseSQL ServerDB2Teradata
The Oracle A-Team have written a blog here on what it does and how to configure and there is also a useful youtube video here.

What is the Oracle Analytics Remote Data Gateway? The Data Gateway is a replacement for the Remote Data Connector which is the OAC utility to connect to your on-premis…

OAC - Essbase Streaming Dataload from SQL Server Database

Image
Here's a short blog on streaming to the OAC Essbase cloud from a MS SQL Server source. The team at essbaselabs have written a nice blog on streaming Essbase data loads and the Oracle docs are here.

Download your MS SQL driver from hereSave it to your client machine and add the path to the jar file to your EXTERNAL_CLASSPATH in the esscs.bat file:
Using essCLI create the local connection to your on-prem data source:esscs createLocalConnection -N MSSQL_EPMDB -cs jdbc:sqlserver://epmdb:1433 -u epmsql -D com.microsoft.sqlserver.jdbc.SQLServerDriver


Run the dataload command. Here I'm passing the SQL query into the command but you can also store the query in your Essbase rules file:esscs dataload -application Sample -db Basic -rule SQLData.rul -stream -connection MSSQL_EPMDB -query "Select * from Sales"



Error handling is good and logged in the essbase-cli.log file:



I then correct my SQL statement and the query is successful:


For rules related errors a familiar dataload.err f…