Is there any way to have the automated daily backup of NetSuite data into local server using SuiteAnalytics connect?

We use Fivetran to automate the replication/sync

But it seems Fivetran comes with some cost, our client is asking to build solution using ODBC drivers offered by Net suite etc.. and not recommending for any 3rd party solution

That would be a crazy idea to build-your-own automation tool to sync data from NetSuite without relying to any third party solutions. I do wonder why your company needs to do daily backup of NS if you can adhocaly pull things out. Anyways, Fivetran has free version, 500k MAR

As per my understanding it’s possible to have the backup using ODBC driver cuz NS itself is offering this feature. But since its very much new to me and wanted to know if anyone has worked previously on it. @sholomon12 : They need daily backup to meet local audit compliances with respect to country in which the data is hosted.

@Sitaram upadhya yes it's possible but not something NetSuite offers out of the box with the SuiteAnalytics Connect. You get access to the data that way and the driver but no scheduling tool or integration platform to sync tables daily to a local server. You would have to build that piece yourself or go with a 3rd party option.

Netsuite offers the connector, but that’s it. So any solution to backup all the data would still have to be be scripted in some query language (probably SQL) to save into a data warehouse, or using a custom application to query for the data and save it wherever needed. But then the client is paying for a custom solution that requires long term maintenance. Those costs are real and companies that fail to see it often end up costing themselves more in the long run. Yes, a solution like Fivetran has a cost, but it’s something you can budget for, and then you have the reliability and support of a well-tested tool, and bug-fixes and maintenance are the vendor’s responsibility, externalizing those costs. No matter what route is chosen, this isn’t going to be free. The client is either paying you for a custom solution, or paying a vendor for something more universal.

Thank you everyone for your valuable inputs

It's possible and I know because we built it. However, it really depends on requirements, for example a 'full backup and no 3rd party' is massively different than 'part backup with use of a 3rd party '. If your client is happy to use a 3rd party, I would definitely suggest you look at that option, as @scottvonduhn points out, you have a single point of contact for issues etc. It was quite a big development project and there were a lot of NS related issues to navigate so not straight forward at all (the code generates the entire schema dynamically, alters the schema re updates, there are circa 1700 tables, some with 10's millions of rows). An alternative lightweight solution for 'part-backups' we have used is to sync saved searches using RESTlets and schedule report exports via email, automate the pick up of the attachment and extract to a database, that works quite well and is relatively easy to implement.

Echoing @dynamicl, the real challenge will be the fact that in order to do a “full backup” you’ll need to detect new tables and schema changes to existing tables, and dynamically alter your backup schema to match Netsuite’s, in additional to extracting the data and saving it. It’s a major effort, and yes it can be built, but if you are starting from scratch, it will be a long and difficult task. However, people don’t always want or need full backups in many cases, and in that instance you might have an easier time. If they just need backup of their transactions and GL lines (along with the associated customers and vendors) then you can create a more targeted backup. The real benefit of a full backup would be for disaster recovery, or migration to a new ERP. It will contain a lot of non-transactional data that might not be needed