OAC Essbase Maxl using SQL connection
Did the import syntax using a SQL connection changed with Essbase cloud? Reading at the official documentation is does not seems to be the case: https://docs.oracle.com/en/cloud/paas/analytics-cloud/tress/import-data.html
The following syntax is not working:
MAXL> import database 'cube'.'cube' data connect as 'user' identified by 'password' using server rules_file 'myrule.rul' on error write to 'mylog.txt';
The rule is based on a ADW connection and is working fine.
While searching the error code (1040215) we found the following KB paper: Error: "1040215 - Query post for the REST data source failed with error " When Attempting to Load Data With a MaxL Script into OAC Essbase (Doc ID 2662774.1). We defined a substitution variable called host and tested the following host values without success: