I’m curious about how you use SuiteAnalytics Connect, did you download everything from NetSuite and join tables from local database? I’m currently facing some performance issue, when I try to generate a table with serial number from transaction_inventory_numbers and join transaction to get sales order number. I’m using MSSQL and openquery, but it usually take 10~20s to get result back from server.

We found the ODBC performance really poor. In the end we went with @Josh_SatoriReporting, but previously used FiveTran.com to get data into SQL.

@Lincecum I have found that it does take a few seconds to query a large table. What query are you trying to perform? OpenQuery is one part of making things more performant, but as others have said, it's best to pull the data into local tables, one at a time, then join the data locally.

Check us out...we've solved all this for you 🙂 We have a turnkey data warehouse for NetSuite...www.satoritechllc.com

@scottvonduhn true, I found if I create temp table in local and join from temp table will faster than join in NetSuite