My company has been using NetSuite since 2003. We create about 1 million new leads/prospects annually, 1 million opportunities annually, 1 million items annually, and about 50,000 sales orders annually. I am looking to begin archiving some of our data to enhance our system. Can anyone recommend a good place to start?

Personally, I'd start with pulling all your data down using the ODBC connector. It's pretty quick to be fair with the ability to pull hundreds of thousands of rows per min when used in parallel. You will have millions of rows in some tables but it shouldn't be an issue. Are you planning on trying to permanently delete some data?

We have two solutions to create a data back-up: 1. Satori Reporting www.satorireporting.com 2. Tactical Connect www.tacticalconnect.com

Re archiving\deleting, the issue with this will be dependant\child records. All depends which record types you are looking to clean up really.

We solve for that issue with Satori Reporting. We create an external data model/replica of NetSuite with all related records.

@Bobbie Kish What records are you trying to clean up?

Im looking at leads, prospects, and items to start. I have about 10 million items as of now.

I don't think you would benefit from 'deleting' records at least from a performance perspective, so I'd be inclined to just make them inactive. That's one of the troubles with cloud based systems in that you don't know the true schema of the back end datastore and if you make a change, it could be for nil benefit. If you have SuiteAnalytics Connect, I'd pull all the counts for all the 'tables' (I think these are actually views projected as tables via the driver), that would give you a better insight into the amount of data\rows you are dealing with.