Just wondering is there existing solution for push sql server data back to NetSuite?

Documentation (the last I read in any way) said that the ODBC/JDBC data is read only. I don't think SuiteQL allows add/update either. Would be happy to be proven wrong though 🙂

@Hannes Benson You've got it right. @Lincecum - Your requirements will include a record type, right? or many? I am not aware of any ready-to-go solutions which would work for literally any record type. I think you'll need to develop your own solution using something like SuiteTalk SOAP or REST (running on your server), or a RESTlet (running in NetSuite) which can receive that data via a request and then create/update NetSuite records with it.

@Peter Ries Thanks, that’s what I’m doing it now. Just wondering is there better way to doing that. Appreciate!

Hey @Lincecum, you haven't given a lot of details so it's hard to say, but among the many possible ways to solve this, I might start by looking into NetSuite's CSV Integrator tool. It automates/schedules CSV Imports, at least for any of the supported record types. With it, if you can export your data into CSV files on a server you control, then the tool would import them into the File Cabinet and trigger CSV imports for you. That's probably the lightest weight dev task for you and should perform well with large-ish volumes of data. Or, like I said earlier, depending on the number of record types you want to import into NetSuite, you could write a RESTlet to do this too. And then you'd make HTTPS calls into that RESTlet to send it data and it would create records in the NetSuite account. Have fun,

@Peter Ries, Thank you! will look into the options. I’ll share my final solution here! Thanks again!