NetSuite
Maximize your NetSuite investment with complete data control of your data.
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.
All-In-One Solution for NetSuite
Automatic Child Table Creation
Faster recovery of your content document, attachments, custom objects, related records, and more.
Deletion Tracking
We maintain deletion relationships between parent and child data, ensuring data consistency.
File Cabinet Support
Data integration and synchronization that scales as your data grows – capturing information that is changing in the event of a restore.
Fast Report Generation
Faster recovery of your content document, attachments, custom objects, related records, and more.
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!
Instant Data Warehouse for QuickBooks
Sesame Software brings all of your company data into one place to provide data consistency, enhance data quality, and make it easier to develop consolidated reports. Organizations looking to replicate and integrate data from QuickBooks and many...