Skip to main content
Feedback

NetSuite.com to NetSuite2.com Migration Guide

Introduction

Oracle NetSuite is transitioning all customers from the legacy NetSuite.com data source to the modern NetSuite2.com (SuiteAnalytics Connect) data source.

This document outlines the required steps, technical changes, schema updates, and configuration adjustments needed to ensure continuity for Boomi integrations.

This guide consolidates the latest guidance from Oracle — including information provided directly by NetSuite’s engineering team — and includes references to all official NetSuite documentation.

Overview of the change

NetSuite is phasing out the legacy NetSuite.com data source as part of the 2026.1 platform upgrade. This modernization initiative moves all SuiteAnalytics Connect users to the NetSuite2.com data source, labeled NetSuite Analytics within Boomi.

Oracle manages this transition on a rolling schedule, and each customer account is upgraded independently. Once your account is upgraded, any integrations still using the legacy data source may stop functioning.

NetSuite communicates upgrade timing through:

  • Email notifications from Oracle
  • The New Release portlet on your NetSuite home dashboard (availability varies)

What’s changing in NetSuite2.com

NetSuite2.com introduces key updates to authentication, querying, security, and schema design.

Key enhancements

  • Modern schema aligned with SuiteAnalytics Workbook
  • More consistent and accurate data exposure
  • Stronger role-based access control (RBAC)
  • Support for OAuth 2.0 and Token-Based Authentication (TBA)
  • Use of SuiteQL, a modern SQL-like query engine
  • Retirement of SQL-like syntax from NetSuite.com

Oracle Documentation

https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_163465025391.html

Required migration steps

Step 1: Create Token-Based Authentication (TBA) credentials

NetSuite2.com does not support username/password authentication.
You must generate TBA credentials inside NetSuite.

You will need:

  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret
  • A role with SuiteAnalytics Connect permissions

Configure these credentials in your NetSuite Analytics (NetSuite2.com) connection in Boomi.

Official Oracle documentation: Requirements for Using Token-based Authentication in Connect.

Step 2: Update all queries to SuiteQL

NetSuite2.com exclusively uses SuiteQL.
Legacy SQL-based queries from NetSuite.com must be rewritten.

Action items:

  • Review all queries used in Boomi data pipelines
  • Rewrite them using SuiteQL syntax
  • Validate expected results and field availability

Review Oracle’s official migration documentation: Changing from NetSuite.com to NetSuite2.com.

Step 3: Review schema changes and update pipeline mappings

NetSuite2.com introduces structured changes impacting field mappings and data relationships.

Examples:

  • Renamed tables: transaction_lines → transactionline
  • Removed or merged tables
  • Datatype updates
  • Custom record differences (manual review required)

Use Oracle’s mapping documentation to identify changes.

Download Oracle’s mapping spreadsheet: NetSuite.com to NetSuite2.com Mapping Spreadsheet.

Step 4: Update downstream data models

Because NetSuite2.com may return different structures:

  • Update or recreate target tables
  • Perform a one-time full reload
  • Revalidate transformations, joins, calculated fields

Step 5: Validate updated pipelines

Before disabling the old source:

  • Run old and new pipelines in parallel
  • Compare row counts, aggregates, business metrics
  • Confirm outputs match reporting/ERP expectations

Step 6: Monitor your NetSuite upgrade schedule

NetSuite controls the timing of customer upgrades.

Monitor:

  • Email notifications
  • The New Release portlet

We recommend completing migration early to prevent unexpected pipeline failures.

On this Page