I was in a conference yesterday and there was some lively debate about the pros and cons of APEX vs Oracle Analytics Cloud, OBIEE & BICS. I thought I’d drill in to this a little further and explore what role does Oracle Application Express plays in a Business Analytics environment and should (or could) Application Express be used instead of Oracle Analytics Cloud?


I’ve been asked a number of times whether we can run existing “on premises” rules files in OAC, and also run in OAC using a SQL data source.

We’ve tested out both of these features and both work well:

  • Use Essbase SQL based rules files
  • Developing them off-line on an on-premises install in EAS
  • Setting the SQL connection string to be a substitution variable
  • Deploy them to OAC
  • Update the substitution variable to point to the cloud RDBMS
alter application 'TBC' set variable 'OCIString' 'QUBIXDB:1521/pdb1.a28217.oraclecloud.internal';
import database 'TBC'.'TBC' data connect as 'admin' identified by 'password' using server rules_file 'data' on error write to 'c:\eastemp\data.err';
execute aggregate process on database 'TBC'.'TBC' stopping when total_size exceeds 10;