import data issue
Summaryimport data issue
I am trying to load data to Essbase using below import statement which works in MAXL editor
import database "APP"."DB" data connect as "TTT" identified by "PPP" using server rules_file "TEST.rul"
to load_buffer with buffer_id 1 on error write to "test.log";
I tried to automate the same using our automation tool which gives below error.
Syntax error near ['" identified by identified by "PPP" using server rules_file "'].
These are direct sql credentials. I am not trying with encrypted schema/password.
Any suggestions on what is missing here