You can't use this until you register with us!

Description

Obtain data from NetSuite and load it into SQL Server.

Purchasing Options

NetSuite to SQL Server Loader - $99.99 / month

Available Actions

Load Data

Download data from NetSuite and store it in SQL Server.

Variables

Source Parameters
netsuite_connection required

Credentials to use to connect to NetSuite.

netsuite_query required

SuiteQL query to retrieve the desired information.

user_params

Parameters to use in your NetSuite Query, if any. Refer to slide out help for more information.


Range Parameters
pointer

Optional datetime stamp indicating the starting point of the information to retrieve. If specified, this field will be automatically updated after each increment of data is downloaded. Formatted as YYYY-MM-DDTHH:MM:SS in the UTC timezone. Required if Start Point Query is not specified.

start_point_query

Optional SQL Query to use to determine the starting point of the information to retrieve. If specified, Next Run Start Point will be ignored.

end_pointer

Optional datetime stamp indicating the stopping point of the information to retrieve. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
db_connection required

SQL Server database where the data will be loaded.

target_table required

Name of the table, in schema.table format, where data will be stored.

create_table_if_dne required

If the specified table does not exist, enable to automatically create it.

table_config required

Select a Shared Config with the NetSuite Query result column name to SQL Server column name mappings and SQL Server column definitions.