January 2019

Fivetran EU Servers

We have added new servers in the European Union (EU). We will now sync all EU users' data to these servers so that your data remains in the EU.

For more information, see our data residency documentation.

New connector page layout

The connector page is now divided into three tabs:

• Status
• Schema
• Setup

New connector statuses

The connector status tab now has more detailed statuses about your connectors' health.

New connectors

Amplitude

Amplitude is a comprehensive product analytics software for web and mobile.

Read our Amplitude connector documentation.

Pendo

Pendo helps product teams understand and guide users to create product experiences that customers love.

Read our Pendo connector documentation.

Schema changes

Amplitude

We have added a new table, EVENT_AMPLITUDE_ATTRIBUTION_ID.

Apple Search Ads

We have removed the deprecated display_status field from the AD_GROUP_HISTORY and CAMPAIGN_HISTORY tables.

Braintree

The transaction_id column is now the primary key in the TRANSACTION_ADD_ON table.

HubSpot

We have added a new column, web_conference_meeting_id, to the ENGAGEMENT_MEETING table.

We have added a new column, unknown_visitor_conversation, to the ENGAGEMENT_CALL table.

Recharge

We have removed the restrict_by_email column from the DISCOUNT table.

Salesforce Marketing Cloud

We have added a new column, unsubscribed_date, to the SUBSCRIBER table.

Shopify

We have removed all note_attributes_* columns from the ORDER table. The new ORDER_NOTE_ATTRIBUTE table contains all note_attributes data.

The landing_site column no longer exists. The landing_site base URLs are now in the landing_site_base_url columns in the ORDER and CHECKOUT tables. Each base URL's query parameters can be found in the ORDER_URL_TAG and CHECKOUT_URL_TAG tables.

We have added four new tables:

• CHECKOUT_URL_TAG
• DISCOUNT_APPLICATION
• ORDER_URL_TAG
• DISCOUNT_ALLOCATION

We have added two new columns, total_discount and pre_tax_price, to the ORDER_LINE table.

Snapchat Ads

We have added a new column, objective, to the CAMPAIGN_HISTORY table.

Stripe

We have added a new column, outcome_risk_score, to the CHARGES table.

Zendesk Support

We have added the following new columns 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

Improvements

Criteo

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.

We have updated the schema because Criteo has changed its API implementation from SOAP to REST. We have made the following changes:

• 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 the CATEGORY table.

Read our Criteo connector documentation.

Google Ad platform rebranding

Since acquiring DoubleClick, Google has re-branded all DoubleClick sources. We have renamed the DoubleClick connectors as follows:

• DoubleClick Campaign Manager to Campaign Manager
• DoubleClick for Publishers to Google Ad Manager
• AdWords to Google Ads

This name change applies to the Fivetran dashboard and our documentation.

Google Sheets

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.

Greenhouse

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 CRM

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 destination

Fivetran will create primary keys for a MySQL destination 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 Cloud

Fivetran now supports the s50 instance.

Zuora

We have released a new version of the Zuora connector that uses the REST API, moving off of the AQuA API.