This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Are there any upper limits on data that can be accessed via ODBC connection using SuiteAnalytics connect?

Yes :slightly_smiling_face: Make your life easier and pull data via saved searches <http://www.tacticalconnect.com|www.tacticalconnect.com>

Can you expand on what limits you are referring to?

Hi <@U29QCJQF3>, I am talking about the rows, I have a huge amount of data, basically Time Records for now, they are 3521031,  I have to migrate this data to AnaPlan and one other system.

I have tried extracting data using excel only, what are the other popular and efficient methods available ?

Hey Vikas. my question was actually for <@UUJSAJX16>. To extract 3 million rows from NetSuite I would say ODBC is your best bet.

So, with ODBC you are limited to the tables/fields you can access and the performance of the connector is limited (failed with big pulls, i.e. 3M rows). So, when we replicate NetSuite in our product (extrernal data warehouse), the ODBC connector simply couldn't keep up. So, that is why we developed our own connector using saved searches which does give us access to all data.