April 2020link
Fivetran APAC Serverslink
We're pleased to announce our new servers in Australia. We will now sync all Asia-Pacific region (APAC) customers' data to these servers so that your data remains in the APAC region.
Link to Australia Servers Documentation
New connectorslink
AWS Inventorylink
AWS Inventory provides you with an overview of your AWS assets, including services, instances, and security groups.
Read our AWS Inventory connector documentation.
Schema changeslink
Brazelink
We have fixed an issue where API response time data was not being synced into the timestamp
column in the SESSION_EVENT
table. We will now sync this data into a new column, time
, and deprecate the timestamp
column.
We have added the following columns to the tables below:
dispatch_id
to thePUSH_NOTIFICATION_EVENT
andEMAIL_EVENT
tableschannel
andphone_number
to theSUBSCRIPTION_EVENT
table
Criteolink
We have added a new table, ADVERTISER
.
Facebook Ad Accountlink
We have added a new column, daily_budget
, to the CAMPAIGN_HISTORY
table.
Facebook Ad Insightslink
We have changed the data type of the following fields from LONG to DOUBLE:
cpc
cpm
cpp
ctr
unique_ctr
unique_link_clicks_ctr
unique_inline_link_click_ctr
social_spend
cost_per_inline_link_click
cost_per_inline_post_engagement
cost_per_unique_click
cost_per_unique_inline_link_click
cost_per_estimated_ad_recallers
estimated_ad_recall_rate
estimated_ad_recallers
Fivetran Platform Connectorlink
We have renamed the TRANSFORMATION_TABLE
table to TRIGGER_TABLE
.
We have renamed the group_id
column to destination_id
in the TRANSFORMATION
, DESTINATION_MEMBERSHIP
, and USER
tables.
Freshdesklink
We have added a new field, association_type
, to the TICKET
table.
Frontlink
We have added five new tables:
SHIFT
stores shift informationTEAM
stores team informationTEAM_TEAMMATE
joins theTEAM
andTEAMMATE
tablesTEAM_INBOX
joins theTEAM
andINBOX
tablesSHIFT_TEAMMATE
joins theSHIFT
andTEAMMATE
tables
Google Adslink
We now add a _fivetran_synced
column while syncing empty tables and columns from the source.
Kustomerlink
We have added a new table, MESSAGE_ATTACHMENT
, which stores message attachment details.
MySQLlink
We now add a _fivetran_synced
column while syncing empty tables and columns from the source.
Pinterest Adslink
We have added a new table, KEYWORD_REPORT
.
Recurlylink
We have added a new child table, COUPON_DISCOUNT
, to the COUPON_HISTORY
table. We have moved the following fields from the parent table to the child table:
discount_type
discount_percentage
discount_currency_type
discount_currency_amount
discount_trial_unit
discount_trial_length
Salesforcelink
We now add a _fivetran_synced
column while syncing empty tables and columns from the source.
Shopifylink
We have added a new table, DRAFT_ORDER_TAG
.
We have added a new table, ABANDONED_CHECKOUT
, to replace the CHECKOUT
table. We have also added six new child tables to replace the following child tables:
ABANDONED_APPLIED_DISCOUNT
replacesAPPLIED_DISCOUNT
ABANDONED_CHECKOUT_DISCOUNT_CODE
replacesCHECKOUT_DISCOUNT_CODE
ABANDONED_CHECKOUT_LINE
replacesCHECKOUT_LINE
ABANDONED_CHECKOUT_SHIPPING_LINE
replacesCHECKOUT_SHIPPING_LINE
ABANDONED_CHECKOUT_TAX_LINE
replacesCHECKOUT_TAX_LINE
ABANDONED_CHECKOUT_URL_TAG
replacesCHECKOUT_URL_TAG
We will deprecate the replaced tables after July 20, 2020. Be sure to update your queries with the new table names before we remove the old tables.
SQL Serverlink
We now add a _fivetran_synced
column while syncing empty tables and columns from the source.
Twitter Adslink
In the MEDIA_CREATIVE_HISTORY
table, we have deprecated the serving_status
field and replaced it with the entity_status
field to support Twitter API v7. We will continue to support the deprecated field for the next three months, so be sure to make the required schema changes by July 3, 2020.
Xerolink
We have added a new field, item_code
, to the PURCHASE_ORDER_LINE_ITEM
table.
Zendesk Supportlink
We have added a new table, TICKET_ATTRIBUTE
, which stores the attribute values of a ticket.
We have added a new table, AGENT_ATTRIBUTE
, which stores the attribute values of an agent.
Zuoralink
We now add a _fivetran_synced
column while syncing empty tables and columns from the source.
Improvementslink
Adobe Analyticslink
You can now configure your Adobe Analytics connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
AdRolllink
You can now configure your AdRoll connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Amazon S3link
You can now connect to public S3 buckets without needing an AWS account.
Amplitudelink
You can now configure your Amplitude connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Anaplanlink
You can now configure your Anaplan connector using the Fivetran REST API. This feature is in BETA and is available only for Enterprise accounts.
AppsFlyerlink
You can now configure your AppsFlyer connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
AWS Inventorylink
You can now configure your AWS Inventory connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Braintreelink
We now support Braintree Java SDK version 2.108.0.
Brazelink
We have added support for SMS and Content Card message engagement events.
Fivetran Platform Connectorlink
You can now configure the Fivetran Platform Connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Google Analyticslink
You can now configure your Google Analytics connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
Google Analytics 360link
You can now configure your Google Analytics 360 connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Google Playlink
You can now configure your Google Play connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
Heaplink
You can now configure your Heap connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Help Scoutlink
You can now configure your Help Scout connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
HubSpotlink
We now support future timestamp values in the following tables:
CALENDAR_EVENT
COMPANY_PROPERTY_HISTORY
CONTACT_FORM_SUBMISSION
CONTACT_PROPERTY_HISTORY
DEAL_PROPERTY_HISTORY
EMAIL_SUBSCRIPTION_CHANGE
ENGAGEMENT
LINE_ITEM_PROPERTY_HISTORY
IDENTITY_PROFILE_IDENTITY
If you have previously synced future timestamp values, re-sync the tables to ensure data integrity.
Intercomlink
You can now configure your Intercom connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Kustomerlink
We now capture deletes for the CONVERSATION
, CUSTOMER
, and NOTE
tables.
Lightspeed Retaillink
You can now configure your Lightspeed Retail connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Microsoft Dynamics 365 CRMlink
We now create empty tables in the destination even if the source tables are empty (contain only Null
values).
MongoDBlink
We now support SRV host records.
MySQLlink
We have increased the fractional second precision of our binary log parser from millisecond to microsecond for DATETIME, TIMESTAMP, and TIME types. To correct existing values of these types in your destination, trigger a table re-sync or a historical re-sync in the connector dashboard.
NetSuite SuiteAnalyticslink
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.
Optimizelylink
You can now configure your Optimizely connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Oraclelink
We have a new way to import tables with fewer than 1 million rows. Our new method will make initial and historical syncs much faster and reduce the resource load on your Oracle database. We will roll out this change over the next few weeks.
We have fixed a bug where we mapped NUMBER column values incorrectly if the column was defined with no precision or scale in the source database. Previously, these values may have been truncated in the destination, but they are now copied to the destination exactly as they appear in the source database. We will roll out this fix over the next few weeks. Once the fix rolls out to you, re-sync any tables where you have previously synced NUMBER column values to ensure data integrity.
Pendolink
You can now configure your Pendo connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
QuickBookslink
You can now configure your QuickBooks connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Rechargelink
We now sync analytics data from the CUSTOMER
, CHARGE
, and SUBSCRIPTION
tables into the ANALYTICS_DATA
table.
Segmentlink
You can now configure your Segment connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
ServiceNowlink
We now create empty tables in the destination even if the source tables are empty (contain only Null
values).
Shopifylink
You can now configure your Shopify connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Snowplowlink
We now support POST requests for all Snowplow connectors.
Stripelink
You can now select the tables you want to sync from the Schema tab on your connector details page.
Xerolink
We have added support to authenticate the connector using OAuth 2.0. We will be migrating the active users to the new standard of authentication.
Zendesk Chatlink
You can now configure your Zendesk Chat connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
Zuoralink
We now create empty tables and columns in the destination even if the source tables and columns are empty (contain only Null
values).
REST API Improvementslink
API configurationlink
You can now generate a new API secret from the account settings form if you think your current one was compromised. Read our REST API docs to learn how to regenerate your secret.
Changes to the re-sync connector table data endpointlink
We have made changes to the re-sync connector table data endpoint. Now, if another data sync is in progress, we will try to complete it, and if it is unsuccessful the request will be declined and the HTTP 409 Conflict error will be returned.
Microsoft Dynamics 365 CRMlink
You can now configure your Microsoft Dynamics 365 CRM connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
MongoDBlink
You can now configure your MongoDB Sharded Cluster connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
MySQLlink
We have added Magento MySQL and Magento MySQL RDS to the list of connectors that can be created via our REST API.
Xerolink
You can now configure your Xero connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.