See also NetSuite Technical Details
Set up NewSuite to give ETL+ read access to the data. NetSuite ODBC Setup
Make NetSuite a data source for ETL+. See below.
Test the connection, load data and verify the right number of records loaded from NewSuite to the data warehouse (the target). See below.
Optional. Put the loading process on a schedule.
ETL+ Connection to NetSuite
If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.
Login to ETL+ (help here).
On the ETL main page,
right-click NetSuiteon the left panel →
ODBC Data Sourcespage, select the correct ODBC Name from the list.
ODBC requiring credentials:
double-click the ODBC name→
You might leave the Alias as is, or customize it.
You’ll get back to the ETL page and see tables under the NetSuite source on the left panel.
Testing a Table Load
Right-click a table on ETL main page’s center panel →
Failure? It’s likely that the prior step wasn’t properly configured. Go back and review it.
Logicon (top right) to view data load results. Log page help here.
Level 1 Testing
The Level 1 Testing checks if the data extraction process finished successfully and row count per extracted table matches with NetSuite’s table row counts.
ETL+ must have already loaded your data manually or scheduled.
Login to ETL+ (help here).
On the ETL main page, click the top-right
Logicon. Log page help here.
Scroll down on the log page and double-check that no table load failed, and the row count matches with the NetSuite tables. Following is an example highlighting two tables and their loaded row count.
Failed to load tables:
Check that the user assigned to DataSelf has reading rights to that particular data set.
Backfrom the Log page, on the ETL main page, select the failing table on the center panel, check that its SQL Statement on the right panel has correct information.
Tables with record count different than in NetSuite:
It might be just that new records have been populated in NetSuite since the DataSelf data load. Reload the data. Click
Backfrom the Log page, on the ETL main page, select the table with incorrect row cound on the center panel,
right-clickthe table on the center panel again ->
Load Now. This might take a while if the table has a large data set.
The user assigned to DataSelf might have access to limited data sets, such as only data from one Division. Check the user’s security credentials.
Schedule the Data Load
On the ETL main page, click
Refresh Batch(top right icon on the center panel).
The Refresh Batch page (help here) usually comes pre-configured to your source system(s).
Overview this page’s configuration. On the right panel, feel free to uncheck tables and Tableau extracts that don’t apply to your reporting needs.
Run a Refresh Batch now (optional): click the
Refresh Batch Now(play icon) on the left panel.
To schedule the data load (optional):
WTS Settings-> enter the WTS parameters →
This step might require you to run ETL+ app as “Run as administrator” in Windows.
- Sage 100 ERP Location Changes
- Introduction / Overview
- ETL+ Source Driver for Google Sheets
- ETL+ Source Driver for Microsoft SQL Server
- v2022.08 ETL+ for Google Sheets
- v2022.08 ETL+ for Salesforce.com
- v2022.08 ETL+ for Sage X3
- v2022.08 ETL+ for Sage Intacct
- v2022.08 ETL+ for Sage CRM
- v2022.08 ETL+ for Sage 500
- v2022.08 ETL+ for Sage 300
- v2022.08 ETL+ for Sage 100 MS SQL Server
- v2022.08 ETL+ for Sage 100 Providex
- v2022.08 ETL+ for Quickbooks