We now create empty tables in the destination even if the source tables are empty (contain only
We now support NetSuite 2020 Release 1 API version. We will gradually roll out this change to all the existing customers.
We have added the following new tables:
We now add a fivetran_synced column while syncing empty tables and columns from the source.
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.
We have changed reimport frequency for reimported tables:
|Table Import Duration||Import Frequency|
|20 secs or less||Re-import in every sync|
|Between 20 secs and 60 mins||Re-imported twice a day|
|More than 60 mins||Re-imported once a week|
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.
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
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.
ITEM_LOCATION_MAPre-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
nullvalues. For more information, see our NetSuite SuiteAnalytics guide.
_fivetran_synced field will now reflect the actual moment when we insert or update rows, rather than the sync start time.
We have updated the JDBC driver to version 7.20.50.
We no longer sync the