NetSuite
Maximize your NetSuite investment with complete data control for current and future use.
Sesame Software for NetSuite
Automatic Child Table Creation
We detect where child data resides and automatically break it out into normalized child tables. This simplifies data management and improves query performance.
Deletion Tracking
We maintain deletion relationships between parent and child data, ensuring data consistency.
File Cabinet Support
Our functionality seamlessly integrates with the file cabinet system, keeping your data organized and intact.
Faster Report Generation
This functionality eliminates the need for full data refreshes, resulting in significantly faster generation of accurate reports.
Enhanced Analysis with SuiteAnalytics
SuiteAnalytics provides a denormalized, accounting view of the data which is specialized for analysis and reporting. We provide:
Incremental loading of the child records as parents update.
Transaction and transaction lines.
The Data Structure
Sesame Software is reshaping your data management efforts with a user-friendly interface that effortlessly organizes and retrieves information – including all of your custom fields. Experience the convenience of having all the work done for you, as we redefine how businesses leverage the full potential of your data.
Created in 2023 as a sample set. This is not representative of the entire NetSuite data structure.
Frequently Asked Questions
Get your questions answered before the demo! Be sure to check out our full Q&A section for more information.
How frequently can I run my downloads?
Fully customizable but you are bottlenecked by mutation of the object. Changes cannot be faster than NetSuite’s API is capable of handing the data to us.
Can the downloads be set up on a schedule?
Yes, we use CRON based scheduling through the application, and we also support many other schedulers via batch processing.
What APIs are supported?
Both SuiteTalk (SOAP) and SuiteAnalytics (JDBC) are supported. They are treated as separate connectors with their own individual schemas.
Are you using the SOAP or the RESTlet API?
We currently use the SOAP API.
Are you using Token-Based Authentication?
Yes, we use Token-Based Authentication.
Do you support uploads/bidirectionality?
We do not support uploads or bidirectionality currently.
What are the account/profile requirements for download?
Sesame recommends a fully permissioned Admin user to perform the download, NetSuite enforces role-based permissions for visibility of data.
How do you handle schema changes in NetSuite?
New fields and name changes are handled as new objects/fields, all historical data is preserved in the old objects.
Can you capture deleted records?
Yes. Sesame Software does logical deletes from NetSuite, indicating with a status flag in the Target DBMS.
What objects do you support?
All objects that are accessible and supported by NetSuite’s SOAP API/Suite Analytics JDBC API.
Can I control what objects are downloaded?
Fully customizable, lists and single object downloads supported.
Can I filter objects by county or subsidiary?
The best practice for Sesame Software is to download all data and filter for reporting on the Target DBMS side. While technically possible, filtering on these data parameters will require the client to have an in-depth knowledge of how their data is structured in their individual NetSuite and prior diligent use of the features/data that is to be filtered.
Do you support objects not listed in the Schema Browser?
The Custom Objects, Saved Searches, Special Views (i.e.; Posting Transaction Summary), and the File Cabinet are all supported.
How is the File Cabinet handled?
We utilize the metadata to create a mirror structure to a mapped OS drive (i.e.; C:\FileCab\..). A virus scanner on the target system is then completed.
What security protocols are in place for data transfer?
No data flows through Sesame’s servers; you inherit the security from NetSuite on the selection side and whatever security is in place for your target environment.
Are you BFN Certified through NetSuite?
Yes, we are listed on the Marketplace as a Hybrid application.
Don’t Get Locked into a Single Type of Architecture
Sesame Software helps customers integrate data with the NetSuite platform across on-premise systems and cloud applications.
From Our Clients
We value our customers! Check out what they have to say:
“Sesame Software has been a fantastic tool to work with. The NetSuite integration was set up in under an hour.”
– Clickstop
“NetSuite is a very powerful tool for us and Sesame Software helps us get the most out of it.”
-Esquire
Featured Resources
Are you looking to connect your NetSuite Data? Learn more below!
Closing the Gap Between Oracle Fusion Applications, Other Data Sources, and ADW for Oracle Analytics Cloud
Oracle Fusion Applications, Oracle Autonomous Data Warehouse (ADW), and Oracle Analytics Cloud (OAC) are powerful technologies used by organizations across all industries to manage business data and gain critical insights for forward-thinking...
2022 Cloud World
Our team had an amazing time last week in Las Vegas giving hands-on demonstrations of Sesame Software's suite of data warehousing, replication, and integration tools at Oracle CloudWorld 2022! We showcased our rapid data pipelines and solutions...
Oracle Database Service for Azure Connects Microsoft to OCI
It just got a little easier to bring together databases in Oracle Cloud with workloads running in Microsoft Azure thanks to the launch of the duo’s multi-cloud database service. Oracle and Microsoft announced that they are jointly launching a new...