Is there anyone here I can talk to about their experience using ODBC?

Just don't.

hahhah

BTW, love the Canadian flag!

So basically the motivation behind my question is that after spending 10+ years doing dev where I could write SQL queries unrestricted, I'm constantly getting frustrated with NetSuite because of not being able to JOIN etc to get what I need. Much of my job is making complex datasets out of multiple tables and I end up having to do huge amounts of scripting to achieve something that should be possible to get in one (albeit complex) SQL query, using nested SELECTs, various types of JOINs, GROUP BYs etc.

just to chime in guys, I ❤️ Canada too!!!

Have you looked at SuiteQL?

SuiteSQL can't do multijoins on arbitrary stuff

For me, I use Tactical Connect to schedule exports to PowerBi where I can do whatever I like (joins, reports, etc). Data refreshes based on my needs, I can share live reports with executives, and publish reports back to netsuite (for warehouse staff).

@michoel can u give some info on that? Are u using windows and connecting to access?

Hey sorry, forgot to get back to you. The two primary uses cases were BI reports using Jasper Server, and in an ecommerce middleware with Tibco ETL. In the later case the integration updates stock levels for over 35k products in about 15 secs which I doubt you would be able to do with other integration methods.

Wow on Tibco ETL! 🙂 Thanks @michoel!

It was actually a typo, I meant to say Talend ETL

wait what