Hi, does anyone know the most efficient way to dump all (or most) data from netsuite in an organized way (DB, spreadsheets) thanks1

SuiteAnalytics ODBC connector for me. I'm currently syncing 674 tables of data from NetSuite using SSIS with the connector so I have all the data locally to query (along with 7 other databases so I can join other data easily when reporting). The only slight problem with this approach is that the db schema can change occasionally ... I've started to write some code to do a dynamic sync that picks up the schema changes going forward then the local copy will always be an exact mirror copy of the cloud version as this doubles up as a full offsite backup.