Just a quick note, since I had to ask to get it to work. You have the capability to download a secure version of MaxL from the OAC Essbase instances. What this means is you can run the MaxL you have on-premises just by changing the server to the cloud URL. If you are migrating from on-prem, this can save you a lot of time as you won;t have to write REST calls or EssCLI.
When you connect to a PaaS OAC instance, you can just get the public IP address and use it, but ther is no public IP address for Autonomous OAC (OAAC). Insted, you have to use the server address like:
https://your instance.oraclecloud.com/essbase/, but that does not work. I order to get it to work after essbase you have to add /agent.
Note, the same thing is true if you want to connect using EssCli.
Good luck. Hopefully your life became easier.
ODI in the hybrid database world – Amazon Redshift – AWS CLI
-
Written on June 5, 2023 by Rodrigo Radtke de Souza Hi all, probably this is
the last post of this series on how to load data from on-premises databases
to ...
1 year ago