Hi all. I'm trying to play with ODBC access to NS and the default driver from NetSuite seems working great, but it does not support UPDATE operations. I found couple companies that offer their own drivers, but I'm not sure how safe is it. Will they get access to our company data? Did anyone try any 3d company drivers?

It’s read only. Thought it’d be obvious you can’t do updates? There’s so much business/system logic sitting in front of that data, allowing updates would be madness. Any 3rd party offerings that provide update operations may present themselves as ODBC, but they actually go through a NetSuite API (so RESTlet/Suitelet/SOAP/etc) to do updates, and won’t be very fast as a result. You’re better off looking at why you want to update & use mass updates or map/reduce scripts instead

Got it. Well, for me it's easier to compose sql statements instead of creating mass updates.

It’s easier for me too, but not an option (sadly)