Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OAC Essbase Maxl using SQL connection

edited Jun 9, 2020 12:30PM in Essbase 5 comments

Content

Dears,

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: 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!