While moving ETL from NetSuite.com to NetSuite2.com via SuiteAnalytics Connect, I hit a weird issue: the accountingPeriod table looked like it was missing recent and future periods. After checking row counts and testing queries, I found the culprit was the parent column—adding it cut results from 315 to 171. The fix: join accountingPeriod to fiscal calendar tables instead.
Ever connect DBeaver to NetSuite and wonder why half your text columns are mysteriously NULL? It’s not your permissions—it’s the SuiteAnalytics Connect ODBC driver. This post shows a simple workaround: switch DBeaver to the NetSuite JDBC driver. I walk through downloading the driver, adding the class, wiring the connection string, and getting complete data back instantly, including optional StaticSchema too.
NetSuite2.com’s role-based permissions can make SuiteAnalytics Connect feel like you’re working blind—tables vanish, ER diagrams hide relationships, and you’re left guessing what access you need. This post shows a lifesaver: enabling the Static Data Model (StaticSchema) so you can see every table and field even without permissions. I walk through adding StaticSchema for ODBC (Windows/Linux), JDBC, and ADO.NET.
You must be logged in to post a comment.