Does suiteql allow us to push data to netsuite?
# suiteqla
Aditya Viki
11/13/2024, 9:41 PMDoes suiteql allow us to push data to netsuite?
a
Anthony OConnor
11/13/2024, 10:12 PMno its read only
m
Michael Wetson
11/15/2024, 4:11 PMNetSuite does not allow any database level direct-write access. Your options are UI, CSV import, SuiteFlow or SOAP. There is an ODBC connector through CData that can write to the NetSuite database through "legal" methods.
s
scottvonduhn
11/15/2024, 5:19 PMI've used the CData connection, and based on the speed of it (it was very slow) I suspect it is translating inserts / updates into SuiteTalk calls, and likely doing it row by row. I don't think they have any special connection to NetSuite, or if they do have some special connection, it's not fast.
scottvonduhn
11/15/2024, 5:22 PMAnother way is to use Restlets (SuiteScript) to build a custom data insert/update endpoint, but it is more work and maintenance than the other options.
👍 1
3 Views