@jpsawyer not sure about ddl. my understanding is the database is proprietary and you should not be accessing it. you can use oracle sql with odbc, jdbc,
ado.net drivers but generally speaking, you're looking at views, not tables. i haven't actually done it though, i could be off/mistaken. i set up our connection and we have another employee doing BI with suiteanalytics connect. my understanding is that if you gained access to the underlying tables, that would be considered an exploit.