--- title: "NetSuite Analytics" slug: "netsuite-analytics" description: "Secure ETL tool Dataddo provides a seamless, no-code connection to automatically sync your NetSuite tables and centralize business insights in any destination." updated: 2026-01-16T13:01:11Z published: 2026-01-16T13:01:11Z --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt > Use this file to discover all available pages before exploring further. # NetSuite Analytics **NetSuite Analytics** is a built-in business intelligence solution that provides real-time visibility into operational and financial data through interactive dashboards and saved searches. It features the SuiteAnalytics Workbook, which allows users to perform complex data exploration, pivot analysis, and visualization directly within the NetSuite environment without needing external tools. ## Authorize Connection to NetSuite Analytics **DATADDO TIP** Dataddo offers two separate authorizers for NetSuite: - [NetSuite](/docs/netsuite), which uses the **NetSuite REST API**, and - NetSuite Analytics, which uses **SuiteAnalytics Connect** (ODBC/JDBC). Each connection method has different requirements, capabilities, and limitations. To ensure you choose the most suitable option for your use case, **please contact your Dataddo account manager before setting up either connector**. 1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select NetSuite Analytics. 2. Fill in the following fields: 1. **Server IP or Hostname**: Your NetSuite Analytics address in the following format `account_id.connect.api.netsuite.com`. 2. **Username**: Your NetSuite Analytics username. 3. **Password**: Password to your NetSuite Analytics account. 4. **Port**: Depending on your server's configuration, this is typically port 1708. 5. **Account ID**: ID of your NetSuite Analytics account, which can be found in your account URL. 6. **Role ID**: ID of your account role. Find the role ID in **Setup** > **Users/Roles** > **User Management** > **Manage Roles (Administrator)** > **Internal ID** column. 3. Rename your ***authorizer*** for easier identification and click on **Save**. ## How to Create a NetSuite Analytics Data Source 1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button and select the connector from the list. 2. Select one of the following depending on your use case. - **Table Replication**: The most common method for replicating a whole table. It copies data from the source table and loads it into the destination. - **Custom SQL**: Use a custom SQL query to define and extract a specific subset of data. This is useful for filtering data, joining multiple tables, or creating a unique dataset before loading it into your destination. ![Source creation for table replication.](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Create%20Source%20-%20Table%20Replication.png) 3. From the drop-down menu, select your ***authorizer***. **Didn't find your authorizer?** Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new). 4. **Name** your data source. The next step depends on your selection. | Table Replication | Custom SQL | | --- | --- | | On the **Data Model** step: 1. **Select your table**: Choose the specific table you want to replicate. 2. **Select all columns to replicate**: Choose which specific data fields (columns) from the table should be included in the replicated data. 3. [Optional] The **Change Tracking Column** is an optional setting used for incremental data extraction. By selecting a column with a date or timestamp (such as `Last Modified Date`) the system can identify and sync only new or updated records. | On the **Query** step: Provide your custom SQL to retrieve the data of the new source. Note that the preview is limited to 100 rows, however, the source will apply the limit specified in your query. | ### Finish Source Creation 1. Configure your [**sync frequency**](https://docs.dataddo.com/docs/extraction#extraction-frequency) or set the exact synchronization time under **Show advanced settings**. **DATADDO TIP** If you need to **load historical data**, refer to the [**Data Backfilling**](https://docs.dataddo.com/docs/data-backfilling) article. 2. Preview your data by clicking on the **Test Data** button in the top right corner. You can **adjust the date range** for a more specific time frame. 3. **Save** the configuration and **congratulations, your new data source is ready!** --- ## Troubleshooting ### Data Preview Unavailable No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are: - **Date range**: Try a smaller date range. You can load the rest of your data afterward using [manual data load](https://docs.dataddo.com/docs/data-backfilling). - **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions. - **Invalid metrics, attributes, or breakdowns**: You may not have any data for the selected metrics, attributes, or breakdowns. - **Incompatible combination of metrics, attributes, or breakdowns**: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same ***data source***. ## Related Articles Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage. **Sending Data to Dashboarding Apps** - [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards) - [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps) **Sending Data to Data Storages** - [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses) - [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages) **Other Resources** - [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting) - [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs) - [Data Duplication](https://docs.dataddo.com/docs/data-duplication) Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.