Hi guys, I need your opinion on this. I need to drive out a lot of data from netsuite to Anaplan and one other system. The amount of data is huge(E.g. a million of time records), so I was thinking of ODBC, TBH, I am new with ODBC, I have been able extract data in to MS Excel with SQL queries so far. That is for legacy data. In the second process, I need to setup a recurring process so that I can post data out of Netsuite and feed to Anaplan or other system using ODBC, Data will be required hourly, weekly and Monthly(it will be large). I even don't know I can do this on a recurring basis via ODBC I can only think of doing a MR script collect data in JSON and send it over to API from other system, for large data I can use date filters to break down data into pieces. Would you be kind enough to put out your suggestions on this or point me to some guides/documents ? That would be really helpful for me.

Look at Celigo's integrator.io

You can consider a lambda function that will call everything to get the NS saved search(es) to AWS instance

@tuli - Anaplan doesnt have a native connection to NS?