Common Misconceptions About NSAW

Since NSAW is fairly new, I have here some common misconceptions about this data warehousing and analytics platform that Oracle is heavily investing on:

FALSE: NSAW uses live SuiteConnect ODBC/JDBC connection to run the logical queries for your reports.

TRUE: It only uses ODBC/JDBC during pipeline refresh where data from the SuiteConnect service flows to the Autonomous Data Warehouse (ADW) during off-peak hours. All logical queries for reports are ran against the physical objects in ADW (not ODBC) so execution is very fast.

FALSE: When querying data, you are limited to what SuiteQL (which is based off an old SQL engine released in 1992) can do.

TRUE: You can utilize all the capabilities of a modern Oracle DB since ADW is in itself a modern Oracle DB. You can create stored procedures, views, materialized views, functions, etc. in ADW and use them in your reports.