February 2021

Dashboard Improvements

We've redesigned the connector list to make it easier to find the connector you're looking for, even if you have thousands of connections. We've enabled searching as well as filtering by status and source type to help you find your way quickly. We've also implemented some significant performance improvements, so the connector list will load quickly.

fcl

Fivetran Singapore Servers

We have added new servers in Singapore. We will now sync all Singapore users' data to these servers so that your data remains in the Singapore region.

For more information, see our data residency documentation.

Magic Folder

We have released the beta version of Fivetran Magic Folder connectors. With Magic Folder connectors, you can sync multiple files from your cloud folder as unique tables to your destination. Magic Folder connectors are available for the following sources:

Priority-First Sync

You can now check the priority-first sync progress in your Fivetran dashboard.

If your connector supports priority-first sync, you will see 'Priority-First Sync' displayed as the sync type in the Sync History chart in the dashboard's Status tab when you click the sync bar during the initial sync.

pfs-info

Click View in the sync info pop-up to check the initial sync progress for each table.

pfs-details

Transformations for dbt Core

Setup tests

We added setup tests in the dbt Transformations setup form. When you click Save & Test, Fivetran checks the credentials and connection to your repository.

Previously, Firetran synced projects immediately after you clicked Save & Test. Now Fivetran syncs your project within a few minutes after the setup tests succeed.

New connectors

Coupa

Coupa is a cloud platform for business spend management.

Read our Coupa connector documentation.

Delighted

Delighted is an online solution that enables businesses to gather and measure actionable feedback from customers, employees, partners, and vendors.

Read our Delighted connector documentation.

Pipedrive

Pipedrive is a sales CRM and pipeline management platform.

Read our Pipedrive connector documentation.

Sage Intacct

Sage Intacct is a cloud-based financial management and services provider.

Read our Sage Intacct connector documentation.

SurveyMonkey

SurveyMonkey is an online survey development tool to create and run surveys.

Read our Survey Monkey connector documentation.

Schema changes

Eloqua

We now add a prefix, custom_, to a custom column name if we find a standard column with the same name in the FORM_SUBMISSION table.

If your FORM_SUBMISSION table contains custom columns and standard columns with the same names, contact support to re-sync your FORM_SUBMISSION table. See our Eloqua ERD for more information on the standard columns in the FORM_SUBMISSION table.

HubSpot

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

We have added a new column, is_merged, to the DEAL table to track merged deals. If you'd like to sync historical data for this column, re-sync the DEAL table.

Iterable

We have added a new column, email_list_ids, to the USER_HISTORY table. The email_list_ids column stores details of all the lists (an array of all the List IDs) that a user is subscribed to.

Jira

We now support the Satisfaction and Satisfaction date fields of Jira Service Management (formerly Jira Service Desk).

Lever

We have added a new table, POSTING_DISTRIBUTION_CHANNEL, which contains your postings' distribution channel information. The POSTING_DISTRIBUTION_CHANNEL table is a child table of the POSTING table.

Mailchimp

We have added two new columns, source and unsubscribe_reason, to the MEMBER table.

If you'd like to sync your historical data from the source and unsubscribe_reason columns, contact our support team.

Recharge

We have added the following new columns to the CUSTOMER table:

first_charge_processed_at
number_active_subscriptions
number_subscriptions

Salesforce

We now sync the following system tables by default and have removed them from the Schema tab on your connector details page:

FIVETRAN_API_CALL
FIVETRAN_QUERY
FIVETRAN_FORMULA
FIVETRAN_FORMULA_HISTORY

Shopify

We have added the following new columns to the FULFILLMENT table:

shipment_status
tracking_numbers
tracking_urls

We have added the following new columns to the FULFILLMENT_ORDER_LINE table:

order_id
product_id
variant_id
fulfillable_quantity
fulfillment_service
gift_card
grams
name
price_set
price
properties
quantity
requires_shipping
sku
taxable
title
variant_title
vendor

Stripe

We have added a new field, calculated_statement_descriptor, to the CHARGE table.

We have added the following new fields to the INVOICE table:

status_transitions_finalized_at
status_transitions_marked_uncollectible_at
status_transitions_paid_at
status_transitions_voided_at

Improvements

Adobe Analytics

The Adobe Analytics connector now allows you to create and sync data from multiple configurations. See our setup instructions for more details.

New connections created after February 9, 2021, will support this new functionality by default.

Apache Kafka

We have added support for Simple Authentication and Security Layer (SASL) authentication with SCRAM-SHA-512.

AWS CloudTrail

Our AWS CloudTrail connector is now generally available.

Read our AWS CloudTrail connector documentation.

AWS Inventory

Our AWS Inventory connector is now generally available.

Read our AWS Inventory connector documentation.

Azure Database for MySQL

Our Azure Database for MySQL connector is now generally available.

See our Azure Database for MySQL setup instructions.

Azure Monitor

Our Azure Monitor log service is now generally available.

Read our Azure Monitor documentation.

Campaign Manager

Now you can select Custom Floodlight variables in the PATH_TO_CONVERSION reports.

GitHub

We can now sync commits from deleted branches that were associated with pull requests. We are gradually rolling out this improvement to all existing connections. If you have missing commits in your destination, re-sync your connection.

Mandrill

We have fixed a bug where the Mandrill server was sending email events data with an invalid TIMESTAMP value with extra digits appended to it. We now consider the first ten digits and discard the extra digits to get the actual TIMESTAMP value.

Pardot

The Pardot connector now supports authorization using Salesforce OAuth. You can now authenticate with an SSO-enabled user account. See our setup instructions for more details.

New connections created after February 16, 2021, will support this new functionality by default.

Salesforce

We now support custom metadata type objects. We are gradually rolling out this new feature to all existing connections. If you'd like to enable this feature on your connector, contact our support team.

Snowflake

We have added a new optional field Role to the Snowflake destination setup form. If you want Fivetran to use a role other than your default role, enter the role’s name during the destination setup in the Role field. See our setup instructions for more information.

SQL Server

We can now sync tables that do not have all of their columns included in their CDC instances. For these tables, we only sync the columns that are present in the CDC instance. To include excluded columns, delete your old CDC instance and create a new one that includes all columns.

This improvement is applicable for the following SQL Server connectors:

Generic SQL Server
Amazon RDS for SQL Server
Azure SQL Database
Azure SQL Managed Instance

Twitter Ads

We now support syncing data for the media_creative entity. See our MEDIA CREATIVE table documentation for more information.

Zendesk Sunshine

Our Zendesk Sunshine connector is now generally available. Read our Zendesk Sunshine connector documentation.

We have added a new connector setup test to check if you have enabled the Events API in your account. See Zendesk's Events API documentation for more information.

REST API Improvements

Jira

Our Jira connector no longer uses the use_webhooks configuration field.