Does anyone know if you can connect to ODBC/JDBC without an active user license (only token based or other) @battk @Fred Pope

No. Ultimately, you have to authenticate with a licensed user. TBA requires an active user/role tied to the token and SuiteAnalytics Connect enforces permission-based access, which necessitates a licensed user. https://suiteanswers.custhelp.com/app/answers/detail/a_id/106876

that is what I thought thank you!

Even if you can connect, it is read only. One approach to consider is an observer, and replicating the data on a cache, but this comes with significant architecture considerations. Another approach is to just use the API's, the native ones not custom built restlets, they are very fast when used right. But the limit you will run into there is the dataset size.... you may end up in SOAP world and SOAP is great in Oracle world. To help yourself there, train a model on the syntax and codegen most of it.