@Jesse Davis I actually really like SuiteAnalytics Connect. I like it so much I have a fear that NetSuite will someday realize it works so well, and will somehow take it away. That's what keeps me up at night. I have trust issues with NetSuite (and to be honest, most subscription-based software companies). But, for the last seven years it has served me well and is one of my most frequently used tools. When users tell me they can't build a report or saved search because of some limitation, I can produce query results from SuiteAnalytics Connect with as complicated of a query as I can come up with.
The main limitation of it is the fact the the data is read-only. However, given that its main purpose is to provide a data source for reporting tools, that's usually fine. Also, you aren't accessing the real underlying tables in NetSuite, they are most likely views of the data. The good news: in my experience, it is by far the fastest method of retrieving large amounts of data out of NetSuite. I have done speed comparisons with SuiteTalk and Restlets, and even with three SC+ licenses and lots of threads, SuiteAnalytics Connect is still the fastest.
There is also the choice between two data sources:
NetSuite.com and
NetSuite2.com. The former has a schema that more closely matches the UI, with column names similar to the field labels on your forms. The latter uses column names that are similar (or maybe identical) to the script ids. Depending upon your use case and the intended audience of the data, one or the other is likely to be more useful. Yes, there is some data not available through these data sources, but not very much. The bulk of the data you can view in the system is available. Users are still bound by the same permissions, so you can't automatically view data that you wouldn't have access to through the UI.
If you are proficient with database tools and SQL, it is great. Prior to the recent SuiteAnalytics workbooks feature, this was the only way to do complex joins of multiple record types in a single query. It also gives you the flexibility to replicate the data to another system and perform queries combining your NetSuite data and data from other systems.