NetSuite Connection

Overview

NetSuite Connection Manager is SSIS Connection Manager for establishing NetSuite connections. Use the API to build components based on NetSuite Connection Manager.

Setup

Use the NetSuite Connection Manager dialog to specify properties for connecting to NetSuite service.

Server Options

User name: Specify user name to access NetSuite.

Password: Specify password to access NetSuite.

Account ID: Specify accountID to access NetSuite. You can confirm your accountID in the NetSuite UI. As administrator, go to Support > Customer Service > Contact Support by Phone. Your account number is displayed in a pop-up box.

Role

Specify role to access NetSuite. If you don't specify a role, the user's default role is used. Check below list of standard roles:

Value	Role
1	Accountant
2	Accountant (Reviewer)
3	Administrator (default)
4	A/P Clerk
5	A/R Clerk
6	Bookkeeper
7	CEO (Hands Off )
8	CEO
9	Sales Manager
10	Sales Person
11	Store Manager
12	Support Manager
13	Support Person
14	Customer Center
15	Employee Center
16	Vendor Center
18	Full Access
19	Warehouse Manager
20	Payroll Manager
22	Intranet Manager
23	Marketing Manager
24	Marketing Assistant
25	System Administrator
26	Sales Administrator
27	Support Administrator
28	Marketing Administrator
30	NetSuite Support Center

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Server URL

Specify NetSuite service URL. This property should be explicitly specified when doing sandbox testing. Sample URLs:

https://webservices.sandbox.netsuite.com/services/NetSuitePort_2011_1

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

How to trace the web services calls in use?

You can use the regular .NET network tracing facilities to trace the web services calls. Follow these steps to enable tracing:

Go to DTS\Binn folder and open DtsDebugHost.exe.config file in your favorite text editor.

Include following settings inside configuration element:

    <system.diagnostics>
      <trace autoflush="true" />
      <sources>
        <source name="System.Net" maxdatasize="1024" tracemode="protocolonly">
          <listeners>
            <add name="MyTraceFile" />
          </listeners>
        </source>
      </sources>
      <sharedListeners>
        <add
          name="MyTraceFile"
          type="System.Diagnostics.TextWriterTraceListener"
          initializeData="c:\System.Net.trace.log" />
      </sharedListeners>
      <switches>
        <add name="System.Net" value="Verbose" />
      </switches>
    </system.diagnostics>

initializeData attribute controls where the trace log file is saved. Now when you execute a package inside Visual Studio, "c:\System.Net.trace.log" file will contain the web services tracing information. If you want to trace when you execute packages outside Visual Studio, include the settings above in DTExec.exe.config configuration file.

Make sure you comment or remove the tracing settings after you finish testing. Otherwise this may slow down your package execution speed considerably.