SuiteAnalytics Connect FAQ

See the questions and answers below for information about SuiteAnalytics Connect.

How can I get access to my NetSuite data through an ODBC, JDBC, or ADO.NET connection?

The SuiteAnalytics Connect feature is an add-on module. For additional information, or to purchase this module, please contact your Account Manager.

Note:

The SuiteAnalytics Connect module is not available for NetSuite Small Business accounts.

To enable the SuiteAnalytics feature:

  1. Go to Setup > Company > Enable Features.

  2. On the Analytics subtab, in the Data Management section, enable SuiteAnalytics Connect.

  3. Click the Save button.

Next, you should download a driver. Go to the Home tab and in the Settings portlet, click Download Driver for instructions.

Note that you need the SuiteAnalytics Connect permission to access the schema available with this feature.

For additional information about using SuiteAnalytics Connect, see SuiteAnalytics Connect.

For more information, see SuiteAnalytics Connect.

I am getting the following error: TCP/IP error, connection reset by peer. What could be causing this?

This message indicates that the connection was closed. There are several reasons that can trigger this message such as a network issue, a NetSuite server restart, the client/server host was unreachable, or a firewall on your system.

A firewall on your system may close the connection if it is considered idle. If you determine that the firewall or your operating system may be the problem, you can set the KeepAliveTime parameter to prevent your system from closing the connection. For more information, see Idle Connection Timeout.

Why is NetSuite2.com the Preferred Data Source for Connect?

The NetSuite2.com data source, also known as the analytics data source, provides advanced query capabilities and solves some previous inconsistencies in data exposure. Also, this data source applies role-based access control which helps to increase security.

To learn about the benefits of using the analytics data source, see NetSuite2.com Data Source.

How can I see all the record types and fields available for Connect?

The NetSuite2.com data source applies role-based access control. This means that the features, roles and permissions assigned to your account determine the data that you can access through Connect. However, you can use the Static Data Model to see all available record types and fields. Using the Static Data Model, SuiteAnalytics Connect still applies role-based permissions. Therefore, you can only get the data for the records that you can access, but you can see the structure and the name of all available record types and fields. For more information, see Setting the Static Data Model for Connect Drivers.

I moved to NetSuite2.com, but I do not get the same results when I use the same query. How can I get results through NetSuite2.com?

The NetSuite2.com data source uses a different schema than NetSuite.com. Some record types and fields that were available in NetSuite.com may not be available in NetSuite2.com, or may return different results. To understand how data is structured in NetSuite2.com and the differences between NetSuite.com and NetSuite2.com, see Record Types and Fields.

Related Topics

Connect
SuiteAnalytics Connect
Accessing the Connect Service Using an ODBC Driver
Accessing the Connect Service Using a JDBC Driver
Accessing the Connect Service Using an ADO.NET Data Provider
Connect Service Considerations
Connect Data Source
Connect Service Notifications

General Notices