Best Method for OneStream Integration with Netsuite
Hello Integration Experts, I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks
Forum Discussion
Hi,
there are different aspects to consider.
In terms of functionality, you will get pretty much the same. Most of the integrations with NS pull data from saved searches. There are different ODBC drivers for NS but they should be providing same functionality. Some of them are 3rd party drivers so they have a cost (Ex: CDATA). But NS has also SuiteAnalytics which it's providing the ODBC driver. All the logic and functionality is embedded in the driver so you don't have to build any complex code to extract data. Your integration will look like a SQL one.
Also, ODBC driver requires the ODBC driver to be available which take you to use Smart Integration Connector most likely.
With REST API, you will have to build your own code including authentication. SIC is not needed. You may get more options but TBH, you should be ok with the ODBC one
If you want to keep things simple, the ODBC option looks better to me.
HTH
Thanks franciscoamores