NetSuite Connector for Data Prep¶
User Persona: Data Prep User, Data Prep Admin, or Data Source Admin
Note
This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.
Configure Data Prep¶
This connector allows you to connect to NetSuite for browsing and importing available data. The following parameters are used to configure the connection.
General¶
-
Name: Name of the data source as it will appear to users in the UI
-
Description: Description of the data source as it will appear to users in the UI
Tip
You can connect Data Prep to multiple Netsuite accounts. Using a descriptive name can be a big help to users in identifying the appropriate data source.
NetSuite Configuration¶
-
NetSuite Account ID: Your NetSuite account ID. You can find this by logging in to NetSuite, clicking the Setup tab → Integration → Web Services Preferences.
-
Username: The user of the NetSuite account used to authenticate.
-
Password: The password of the NetSuite user.
-
Role ID: The Internal ID of the role that will be used to connect to NetSuite. Leave this empty to use the user's default role. To find the Role ID, follow the steps above for finding the Account ID, then select the username from the drop-down list, and finally select the corresponding Role associated with the user account.
-
Timeout: The number of seconds to wait for an operation, the default value is 300 seconds.
Web Proxy Configuration¶
If you connect to Data Source through a proxy server, these fields define the proxy details.
-
Web Proxy: 'None' if no proxy is required or 'Proxied' if the connection to NetSuite should be made via a proxy server. If a web proxy server is required, the following fields are required to enable a proxied connection.
-
Proxy host: The hostname or IP address of the web proxy server.
-
Proxy port: The port on the proxy server for Data Source.
-
Proxy username: The username for the proxy server.
-
Proxy password: The password for the proxy server.
Note
Leave username and password blank for an unauthenticated proxy connection.
Data Import Information¶
Via Browsing¶
- Browse to an Object and "Select" the table for import.
Via SQL Query¶
- Using a legal SQL Select Query.