NetSuite 数据分析 ODBC(SuiteAnalytics Connect) 和 新的Analytics Warehouse

背景

本文主要分享概念层面上的关于：NetSuite在ODBC上面的功能和演变。

Add-On模块 功能与收费情况

1. ODBC, JDBC and ADO.NET 这三个对应SuiteAnalytics Connect功能；免费

它有较长时间的发展历史和版本迭代，具体详见附录或Help中Connect Service Notifications（URL：这里是你NetSuite的AccountID.app.netsuite.com/app/help/helpcenter.nl?fid=chapter_1530646443.html）

 

2. NetSuite Analytics Warehouse Connector 对应 NetSuite Analytics Warehouse功能；额外收费

新增在大约Version2021.2左右；更接近底层数据库；数据内容更丰富，开放度更高

它与Netsuite底层是两个构架，一个趋势，和大数据、数据库仓库方向的Oracle实现方式。

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

 

 

什么是ODBC, JDBC 或 ADO.NET？

ODBC：

　　加载/获取部分受支持的NetSuite数据到Excel中，比如transactions，entity表，等等。
　　09年的时候，我举过一个应用的实例：sql读取csv和xls格式的文件,数据源
　　然后通过这种方式可以在不同的CSV或者excel文件间互相调用数据，当然理论上也可以通过此方式将数据导入到mysql等等数据库中。

　Use the SuiteAnalytics Connect ODBC driver to load your NetSuite data to Microsoft Excel workbooks.

　Open Database Connectivity: What Is ODBC?

JDBC：

通过JDBC驱动和API来加载/获取部分受支持的NetSuite数据到JAVA应用程序中。

Installing a Connect JDBC driver enables you to connect a Java application to the Connect Service. The Connect JDBC driver is a database driver implementation that enables you to use JDBC API to communicate with the SuiteAnalytics Connect service, use the Connect for JDBC driver when writing your own application


ADO.NET：

通过ADO.NET驱动和API来加载/获取部分受支持的NetSuite数据到.NET应用程序中。

ADO.NET data provider enables you to access the Connect Service from the Microsoft .NET platform

 

 

如何开启ODBC, JDBC 或 ADO.NET？

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.

 

 

 

附录

Connect-Service-Notifications

Changes in 2023

• Latest JDBC Driver Version Available

• Windows Server 2012 R2 No Longer Supported for SuiteAnalytics Connect

Changes in 2022

• New Uppercase Connection Attribute

• OAuth 2.0 for SuiteAnalytics Connect

• JDBC Driver Version Available

• Required Update of SuiteAnalytics Connect Drivers

Changes in 2021

• New Accounts and Access to the Connect Data Source

• Connect NetSuite.com Data Source No Longer Being Updated

• Removal of the Analytics Browser

• Change to Display Size and Precision in Some Connect Columns

• Changes to Return Values in Some Connect Columns

• Removal of Some Connect Tables and Columns

Changes in 2020

• Changes to Return Values in SuiteAnalytics Connect Columns

• Audit Trail and Execution Log Record Types Contain Outdated Data

• Idle Session Timeout for SuiteAnalytics Connect

• Deprecation of Data Center-Specific Domains for SuiteAnalytics Connect

Changes in 2019

• Change in Time Zone of Charges Table Date Columns

• New Version for SuiteAnalytics Connect ODBC and JDBC Drivers

• Changes to SuiteAnalytics Connect Return Values and String Types

• The Analytics Data Source and SuiteAnalytics Connect

• NetSuite Password Policies Now Apply to SuiteAnalytics Connect

Changes in 2018

• Cipher Suite Deprecations for SuiteAnalytics Connect JDBC Drivers

• Mandatory Update for SuiteAnalytics Connect ODBC Drivers