This content has been marked as final. Show 2 replies
I am prototyping Direct Discovery against an SAP Hana database. If I do a standard SQL Select, I get the data, however, when I use Direct Query with the following script, I get an error. The syntax looks correct according to the most recent documentation. Any thoughts?
ODBC CONNECT TO [IQ5 ODBC_USER] (XUserId is OKbRdHRICaQeVKNKFSUSM, XPassword is PcfUGKBGNLYIHYEGBBQB);
cast("/BIC/ZLABOR1" as double) as "IE Labor Value_/BIC/ZLABOR1",
cast("/BIC/ZLABOR2" as double) as "Earned Labor_/BIC/ZLABOR2"