Move your data from Netsuite SuiteAnalytics with your free account

The NetSuite SuiteAnalytics Connect capture connector in Estuary captures NetSuite data through SuiteAnalytics Connect and loads it into Estuary collections. It automatically discovers the tables, schemas, keys, and cursor fields available to the configured NetSuite role, then selects the appropriate replication method for each table.

• Automatic discovery of accessible NetSuite tables, including Transactions, Reports, Lists, and Setup data
• Incremental replication for tables with suitable date-time cursor fields such as lastmodifieddate
• Paginated backfills for tables that have an appropriate page cursor
• Snapshot replication for tables without usable cursor fields, including detection of deleted rows through snapshot diffing
• Configurable sync intervals, with incremental tables checked every 1 hour by default
• Deletion capture through NetSuite’s DeletedRecord system table for supported base-record tables
• Configurable historical backfills using a start date
• Token-based authentication, with username/password authentication also supported

Most core NetSuite record tables — including Transaction, Account, Customer, Employee, Item, Subsidiary, and Vendor — expose a lastmodifieddate field that Estuary can use for incremental capture. During each incremental sync, the connector queries only rows modified since its previous checkpoint.