NetSuite SuiteAnalytics Release Notes

August 2020link

We have released a pre-built dbt package for NetSuite SuiteAnalytics. Find the package in Fivetran’s dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

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 subtables. All subtables of subtables will also be updated recursively. For example, if the TRANSACTIONS table is updated, then its subtable TRANSACTION_LINES will be updated, along with TRANSACTION_LINES’s own subtables 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.