NetSuite

Maximize your NetSuite investment with complete data control of your data.
Woman working on her laptop

Data Backup

Safeguard your NetSuite data with our robust backup solution, ensuring peace of mind and data resilience.

  • Create a secure copy of your NetSuite data for storage at any location of your choice.
  • Supports a wide range of relational databases, including cloud and columnar platforms, offering flexible architecture options and avoiding vendor lock-in.
  • Long term, incremental backups of your NetSuite data in an on-prem or cloud database for regulatory compliance.

  • Allows for restarts on disconnects, particularly beneficial for handling large objects.
  • Updates objects instead of downloading user data, saving time and effort.
  • Offers peace of mind downloading, enabling efficient management of large datasets without constant monitoring.

Data Archive

Streamline your data archiving process with our efficient solution, facilitating easier access and management of historical NetSuite data. Upon completion, we deliver the File Cabinet as a separate zip file from the database. This mirrors the folder structure from the File Cabinet in the cloud. Thus, the original files will retain their file formats once the full zip file is unzipped.

  • Liberate all Child tables to any of our featured target endpoints.
  • Child Tables can be downloaded to SQL Server, Oracle, and MariaDB, providing enhanced relationship information.
  • Simplifies writing searches and facilitates offloading of data to a centralized location for easier querying.

  • Automates the process of building database tables and relationships, eliminating the need for manual intervention.
  • Saves time and resources by streamlining warehouse build processes.

  • Our solution maintains the original folder structure and status of records, including metadata structure and nested files.
  • Ensures you can easily access historical information whenever needed, maintaining a comprehensive record for audits or future reference.
  • All archived data undergoes an anti-viral scan, guaranteeing the integrity and safety of your information.

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.

NetSuite using Relational Junction to connect to data platforms

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!

Sesame Software at Oracle Cloud Day Dallas

Sesame Software at Oracle Cloud Day Dallas

Sesame Software has been recognized by Oracle for bringing a “Ground-Breaking Solution” to Oracle Cloud Marketplace with the patented Sesame Software Data Management Suite. Sesame Software allows you to leverage Oracle Cloud without the imposed...

Fully Automated Data Warehouse for NetSuite

Fully Automated Data Warehouse for NetSuite

Enable Rapid Integration for Enhanced Reporting and Analytics Create an on-premise or cloud data warehouse that is a mirror of your NetSuite data. In addition, easily replicates data from any data source to ensure data consistency, enhanced...

Start Connecting Data Today!

Centralize your NetSuite data into the data warehouse of your choice.
Spend more time on insights and less time on managing your data pipeline.
Scale your ecosystem and connect to multiple destinations.

Learn More Today!