NetSuite SuiteAnalytics Release Notes

August 2022link

We have added support for CLOB data type. We now convert the data to STRING data type in your destination tables. We are gradually rolling out this feature to all existing connectors.

Our dbt-Core* compatible data models for NetSuite SuiteAnalytics now support the NetSuite2.com data source. Find the models in Fivetran’s dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

April 2022link

You can now use the NetSuite2.com data source to configure your NetSuite SuiteAnalytics connector. This feature is in beta. For more information, see our NetSuite SuiteAnalytics documentation.

March 2022link

We have added support for the NetSuite2.com data source. We are gradually rolling out this feature to all our existing customers.

You can now create new NetSuite connectors that sync data from the NetSuite2.com data source into your destination.

NOTE: If your NetSuite account provides access to both data sources, you can sync data from both data sources using a separate connector for each data source. However, we do not support switching data sources for existing NetSuite connectors.

August 2020link

We have released pre-built, dbt Core-compatible data models for NetSuite SuiteAnalytics. Find the models in Fivetran’s dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have modified our sync strategy for incremental tables. Now, during the incremental update, we restrict the latest re-import range to the maximum primary key value. Previously, during the incremental update, we didn’t restrict the range, which caused high MAR (monthly active rows) consumption. We are gradually rolling out this change to all existing customers. If you’d like to use the updated strategy immediately, contact our support team.

July 2020link

We have changed the sync strategy for the incremental tables that have the fivetran_index column as a primary key. We are gradually rolling out this change to all existing customers.

We have changed the sync strategy for the re-import tables that have the fivetran_index column as a primary key. We are gradually rolling out this change to all existing customers.

We have also changed the sync strategy of the fivetran_index column. Now, we use a monotonically increasing value for the fivetran_index column that is specific to each primary key. Previously, we used a monotonically increasing value that was specific to the full table. We have implemented the modified sync strategy for the following tables:

• BILLING_SCHEDULE
• ITEM_LOCATION_MAP
• ITEM_PRICES
• ITEM_VENDOR_PRICING
• POSTING_ACCOUNT_ACTIVITY
• REVRECSCHEDULELINES
• TRANSACTION_SHIPPING_GROUPS
• TRANSACTION_TRACKING_NUMBERS

We are gradually rolling out this change to all existing customers.

We now use the DELETED_RECORDS table to capture deleted records for tables that have a single primary key and are updated incrementally. Previously, during the incremental update, we imported ranges, which caused high MAR (monthly active rows) consumption. We are gradually rolling out this change to all existing customers.

We have removed the Data Source field from the connector setup form because we only support NetSuite.com as a data source.

We have changed our sync strategy for tables that have a single primary key and are updated incrementally. We now use the data_last_modified column to retrieve updates and new records, and we re-import ranges only to capture deletes. We are gradually rolling out this change to all existing customers.

June 2020link

We now create empty tables in the destination even if the source tables are empty (contain only Null values).

We now support NetSuite 2020 Release 1 API version. We will gradually roll out this change to all the existing customers.

We now add a fivetran_synced column while syncing empty tables and columns from the source.

We have added the following new tables:

• ADDRESSES
• BILL_OF_MATERIALS
• BOM_REVISION_COMPONENTS
• BOM_REVISIONS
• CURRENCY_EXCHANGE_RATE_TYPES
• CURRENCY_EXCHANGE_RATES
• EMPLOYEE_CURRENCY_MAP
• INBOUND_SHIPMENTS
• ITEM_COLLECTION_ITEM_MAP
• ITEM_COLLECTIONS
• ITEM_PRICE_HISTORY
• LOCATION_COSTING_GROUPS
• LOCATION_COSTING_GRP_LOCATIONS
• PURCHASE_CHARGE_RULES
• RESOURCE_GROUP_ENTITY_MAP
• RESOURCE_GROUPS
• SUBSCRIPTION_LINE_REVISIONS
• TRANSACTION_HISTORY
• UNLOCKED_TIME_PERIODS

April 2020link

We will implement a new and modified sync strategy for a subset of the supported NetSuite tables. This strategy will ensure that our syncs capture the deleted and modified records. See our NetSuite SuiteAnalytics documents for the complete list of tables that uses the modified sync strategy.

NetSuite stopped updating timestamps from child records to parent records, and this impacted our current sync strategy.

We will gradually roll out this change to all the existing customers. As part of the deployment, we will re-sync the tables for which we have changed the sync strategy.

November 2019link

We have changed reimport frequency for reimported tables:

Tables that take longer than 20 seconds to import get marked as not recommended on the dashboard and include a message on how frequently Fivetran syncs them. For more information, see our NetSuite SuiteAnalytics documentation.

November 2018link

We have fixed the incremental update of sub-tables. All sub-tables of sub-tables will also be updated recursively. For example, if the TRANSACTIONS table is updated, then its sub-table TRANSACTION_LINES will be updated, along with TRANSACTION_LINES’s own sub-tables BIN_NUMBER and BIN_NUMBER_COUNTS.

October 2018link

We have released service version 3 of the NetSuite SuiteAnalytics connector, which includes the following new features:

• Tables that can’t be incrementally updated can now be re-imported. The frequency with which we update these re-import tables is based on how fast we can ingest them from NetSuite. For more information, see our NetSuite SuiteAnalytics guide.
• The ITEM_LOCATION_MAP re-import table will update every sync. To see the duration of each table import, you can refer to the table warning field on the Schema tab of your Fivetran dashboard’s Connector page.
• We can now upload records for tables where the primary key column contains null values. For more information, see our NetSuite SuiteAnalytics guide.

June 2018link

The _fivetran_synced field will now reflect the actual moment when we insert or update rows, rather than the sync start time.

May 2018link

We have updated the JDBC driver to version 7.20.50.

We no longer sync the SUBSCRIPTION_CO_LINES table.