> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://mammoth.io/docs/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Connect Oracle NetSuite to Mammoth

> Connect Mammoth to Oracle NetSuite by signing in on NetSuite and picking an account, choose record tables and columns, and save a dataset that refreshes.

The Netsuite connector imports ERP and accounting data from your **Oracle NetSuite** account into Mammoth as a dataset. You sign in to NetSuite and pick the account; there are no API keys or account URLs to enter. Open it from **Data Library** > **New dataset** > **Connectors** and search for **Netsuite**. Project Admins create the connection; Project Editors can start datasets from a connection the project already has. Which connectors you can add depends on your plan.

## What you can bring in from NetSuite

- Record tables the signed-in role can see, and the columns you tick.
- Data you ask for in the **Chat**, for example *"which table has invoice due dates?"*

The dataset can refresh daily or only when you ask.

## Before you connect NetSuite

You need a NetSuite account, and a sign-in whose role can see the records you want to import.

## Connect NetSuite to Mammoth

These steps follow the shared flow in [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/).

1. Go to the **Data Library** and click **New dataset**.
2. Choose **Connectors**.
3. Search for **Netsuite** and click its tile. The connector workspace opens with the **Chat** showing.
4. In the **Chat**, Mammoth shows a card for connecting NetSuite. Click its sign-in button.
5. Mammoth sends you to NetSuite's sign-in page (system.netsuite.com). Sign in with your NetSuite credentials.
6. Pick the NetSuite account to connect, and authorize Mammoth.
7. You return to Mammoth with the connection active. NetSuite tells Mammoth which account you picked, so you don't enter an account ID or URL.

![Netsuite New Connection form with the Your NetSuite Account URL (Domain) field and Connect button](https://mammoth.io/docs/images/20260826_115906_styled4.webp)



## Pick NetSuite tables and columns

1. In **Tables**, click a table to see its columns and sample rows.
2. Tick the columns you want. They gather in **Your table**.
3. Click **Preview 100 rows** to check the result.

If you're not sure which table holds what you need, ask in the **Chat**.

## Save NetSuite data as a dataset

1. Click **Save as dataset**.
2. Enter a **Dataset name** and choose a folder under **Save in**.
3. Choose **Daily** to refresh the dataset every day, or **Manual** to refresh it only when you ask.
4. Click **Save**. When the dataset is ready, click **Open dataset**.

## Refresh NetSuite data and choose an update method

Choosing **Daily** creates a [Dataset Refresh](https://mammoth.io/docs/learn/automate/refresh-a-dataset/) automation for the dataset. To run it on another schedule, edit that automation. For a dataset saved with **Manual**, create a Dataset Refresh automation yourself.

After you save, the dataset's **Update method** setting offers only two options:

| Update method | What it does |
| --- | --- |
| **Replace all data** | Rebuilds the dataset from the source on every refresh |
| **Add to existing data** | Adds the rows each refresh brings in to the rows you already have |

NetSuite refreshes don't track a key column, so there is no key column to pick.

## Troubleshoot NetSuite connections

| Symptom | Likely cause | Fix |
| --- | --- | --- |
| Authorization doesn't complete | You closed the tab or denied access | Start the connection again |
| The wrong NetSuite account is connected | Another account was picked at sign-in | Connect again and pick the account you want on NetSuite's sign-in page |
| A record type isn't visible | The signed-in role lacks permission on it | Ask your NetSuite admin to check the role's permissions |

## Related

- [Xero](https://mammoth.io/docs/learn/get-data-in/connectors/xero/): import accounting data from Xero.
- [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/): the shared connector workspace steps.
- [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/): reuse, edit or delete this connection.
- [Refresh a dataset](https://mammoth.io/docs/learn/automate/refresh-a-dataset/): change when the dataset refreshes.
- [Connector reference](https://mammoth.io/docs/learn/get-data-in/connectors/): every source Mammoth connects to.

---
Source: https://mammoth.io/docs/learn/get-data-in/connectors/netsuite.md · Updated: 2026-11-08