Best Method for OneStream Integration with Netsuite

Hi Ramachendruni Sreenu,

When it comes to working with NetSuite and accessing data, you have two primary options: utilizing an ODBC connection or leveraging the REST API. Both methods have their own advantages and considerations, so let's dive into the details to help you make an informed decision.

1. ODBC Connection: With an ODBC connection, you can extract data from NetSuite using SQL queries. This approach is ideal if you only require data retrieval without the need to modify or update the NetSuite instance. ODBC offers the following benefits:

   a. Optimization: ODBC is highly optimized for pulling data directly from the NetSuite database, providing efficient and direct access to the required information.

   b. Direct Connection: ODBC establishes a direct connection to the NetSuite database, allowing you to query the data without any intermediate steps or conversions.

2. REST API: On the other hand, the REST API enables you to perform various operations, including data retrieval and modification, within NetSuite. This approach is useful when you need to make changes to the NetSuite instance from an external source, such as Onestream. Here are some key points to consider:

   a. Data Manipulation: REST API allows you to make POST requests and modify NetSuite data, providing flexibility beyond simple data retrieval.

   b. JSON Response: When using the REST API, the database is queried, and the results are packed as a JSON response, which is then sent over the HTTP protocol. This additional layer may introduce some overhead and result in slightly slower performance compared to ODBC, particularly in specific scenarios.

   Based on Your Use Case: To determine the most suitable approach, consider your specific requirements. If your primary objective is to fetch data from NetSuite without any modifications, ODBC offers a more optimized and direct connection to the database, making it an ideal choice.

   However, if you need to make changes or updates to the NetSuite instance from Onestream or any other external system, the REST API provides the necessary functionality and flexibility.

   In conclusion, the decision between ODBC and REST API depends on your use case. If data retrieval is your main goal, ODBC is recommended for its optimized and direct access to the database. On the other hand, if you require data modification capabilities, the REST API is the way to go.

Thanks, Omkareshwar

Archetype Consulting