January 2019link
Fivetran EU Serverslink
We're pleased to announce our new servers in the European Union (EU). We will now sync all EU customers' data to these servers so that your data remains in the EU.
Link to EU Servers Documentation
New connector page layoutlink
The connector page is now divided into three tabs: Status, Schema and Setup.
New connector statuseslink
The connector status tab now has more detailed statuses about your connectors' health.
New connectorslink
Amplitudelink
Amplitude is a comprehensive product analytics software for web and mobile.
Link to Amplitude Documentation
Criteolink
Criteo is a retargeted advertising platform.
We have released a new version of the Criteo connector.
The new version supports OAuth (Open Authorization). Criteo has deprecated basic authentication with username and password.
The schema has been updated because Criteo has changed its API implementation from SOAP to REST.
- The
CATEGORY_REPORT
table has been dropped, as Criteo no longer supports this report. - The
CATEGORY_BID
table has been dropped. The information from this table is now included in theCATEGORY
table.
- The
Pendolink
Pendo helps product teams understand and guide users to create product experiences that customers love.
Schema changeslink
Amplitudelink
We have added a new table, EVENT_AMPLITUDE_ATTRIBUTION_ID
.
Apple Search Adslink
We have removed the deprecated display_status
field from the AD_GROUP_HISTORY
and CAMPAIGN_HISTORY
tables.
Braintreelink
The transaction_id
field is now the Primary Key in the TRANSACTION_ADD_ON
table.
HubSpotlink
- We have added the new column
web_conference_meeting_id
to theENGAGEMENT_MEETING
table. - We have also added the new column
unknown_visitor_conversation
to theENGAGEMENT_CALL
table.
Rechargelink
We have removed the restrict_by_email
column from the DISCOUNT
table.
Salesforce Marketing Cloudlink
We have added the new column unsubscribed_date
to the SUBSCRIBER
table.
Shopifylink
We have removed all
note_attributes_*
fields from theORDER
table. The newORDER_NOTE_ATTRIBUTE
table contains allnote_attributes
data.The
landing_site
field no longer exists. Thelanding_site
base URLs are now in thelanding_site_base_url
fields in theORDER
andCHECKOUT
tables. Each base URL's query parameters can be found in theORDER_URL_TAG
andCHECKOUT_URL_TAG
tables.We have added four new tables:
CHECKOUT_URL_TAG
DISCOUNT_APPLICATION
ORDER_URL_TAG
DISCOUNT_ALLOCATION
We have added two new fields to the
ORDER_LINE
table:total_discount
pre_tax_price
Snapchat Adslink
We have added the new column objective
to the CAMPAIGN_HISTORY
table.
Stripelink
We have added the outcome_risk_score
field to the CHARGES
table.
Zendesklink
We have added the following fields to the BRAND
table:
has_help_center
help_center_state
logo_content_type
logo_content_url
logo_file_name
logo_id
logo_mapped_content_url
logo_size
logo_url
Improvementslink
DoubleClick and Adwordslink
Since acquiring DoubleClick, Google has re-branded all DoubleClick sources. We have renamed the DoubleClick connectors as follows:
- DoubleClick Campaign Manager is now named Campaign Manager.
- DoubleClick for Publishers is now named Google Ad Manager.
- Adwords is now named Google Ads.
Facebook Ad Accountlink
We have upgraded the Facebook Marketing API to version 3.2. As Facebook has deprecated the rtb_flag
field, we will no longer support it.
Facebook Ad Insightslink
We have upgraded the Facebook Marketing API to version 3.2. As Facebook has deprecated the total_action_value
field, we will no longer support it.
Google Sheetslink
Moving forward, Fivetran will only sync the named range to the destination when changes are detected. You can track your syncs on the Connection Details page of your Fivetran dashboard. The "Last Synced Changes (UTC)" field will show when your data was last synced to the destination.
Greenhouselink
Application_created
, job_created
, and offer_created
events can now create entries in the history table. The main entity will continue to be updated during periodic syncs, not during the event cycle. You can find additional details in our Greenhouse Setup Guide.
Microsoft Dynamics 365 CRMlink
The setup form for the Microsoft Dynamics 365 CRM now contains two additional fields, Application ID and Client Secret. We have also updated our documentation to include instructions for registering an application on the Azure Portal.
MySQL Warehouse Primary Key Creationlink
Fivetran will create primary keys for a MySQL warehouse in either of the following scenarios:
MySQL version earlier than 5.7 or MariaDB version earlier than 10.2: If the source provides fewer than 16 primary keys and the sum of the byte length of string primary keys is less than 191.
MySQL version 5.7 and later or MariaDB version 10.2 and later: If the source provides fewer than 16 primary keys and the sum of the byte length of string primary keys is less than 768.
Salesforce Marketing Cloudlink
Fivetran now supports the s50
instance.
Zuoralink
We have released a new version of the Zuora connector that uses the REST API, moving off of the AQuA API.