February 2021link
Dashboard Improvementslink
We've redesigned the connector list to make it easier to find the connector you're looking for, even if you have thousands of connectors. 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.
Fivetran Singapore Serverslink
We're pleased to announce our new servers in Singapore. We will now sync all Singapore customers' data to these servers so that your data remains in the Singapore region.
See our Fivetran servers documentation for more information.
Magic Folderlink
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 Synclink
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.
Click View in the sync info pop-up to check the initial sync progress for each table.
Transformations for dbt Corelink
Setup testslink
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 connectorslink
Coupalink
Coupa is a cloud platform for business spend management.
Read our Coupa connector documentation.
Delightedlink
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.
FinancialForcelink
FinancialForce is an ERP and service automation tool built on the Salesforce platform.
Read our FinancialForce connector documentation.
Pipedrivelink
Pipedrive is a sales CRM and pipeline management platform.
Read our Pipedrive connector documentation.
Sage Intacctlink
Sage Intacct is a cloud-based financial management and services provider.
Read our Sage Intacct connector documentation.
SurveyMonkeylink
SurveyMonkey is an online survey development tool to create and run surveys.
Read our Survey Monkey connector documentation.
Schema changeslink
Eloqualink
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.
Facebook Ad Insightslink
We have deprecated the 28-days click and view attribution windows to support Facebook API changes.
HubSpotlink
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.
Iterablelink
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.
Jiralink
We now support the Satisfaction
and Satisfaction date
fields of Jira Service Management (formerly Jira Service Desk).
Leverlink
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.
Mailchimplink
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.
Rechargelink
We have added the following new columns to the CUSTOMER
table:
first_charge_processed_at
number_active_subscriptions
number_subscriptions
Salesforcelink
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
Shopifylink
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
Stripelink
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
Improvementslink
Adobe Analyticslink
The Adobe Analytics connector now allows you to create and sync data from multiple configurations. See our setup instructions for more details.
New connectors created after February 9, 2021, will support this new functionality by default.
Apache Kafkalink
We have added support for Simple Authentication and Security Layer (SASL) authentication with SCRAM-SHA-512
.
AWS CloudTraillink
Our AWS CloudTrail connector is now generally available.
Read our AWS CloudTrail connector documentation.
AWS Inventorylink
Our AWS Inventory connector is now generally available.
Read our AWS Inventory connector documentation.
Azure Monitorlink
Our Azure Monitor log service is now generally available.
Read our Azure Monitor documentation.
Azure MySQLlink
Our Azure MySQL connector is now generally available.
See our Azure MySQL setup instructions.
Campaign Managerlink
Now you can select Custom Floodlight variables in the PATH_TO_CONVERSION
reports.
Facebook Ad Accountlink
We have upgraded our connector to support Facebook Marketing API v9.0.
We no longer support the budget_rebalance_flag
field because Facebook has deprecated the field.
Facebook Ad Insightslink
We have upgraded our Facebook Ad Insights connector from version 7.0 to 9.0 of the Facebook Marketing API and handled deprecations and updates. Learn more about the deprecations and changes in the Facebook Marketing API v8.0 changelog and Facebook Marketing API v9.0 changelog.
GitHublink
We can now sync commits from deleted branches that were associated with pull requests. We are gradually rolling out this improvement to all existing customers. If you have missing commits in your destination, re-sync your connector.
Mandrilllink
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.
Pardotlink
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 connectors created after February 16, 2021, will support this new functionality by default.
Salesforcelink
We now support custom metadata type objects. We are gradually rolling out this new feature to all existing customers. If you'd like to enable this feature on your connector, contact our support team.
Snowflakelink
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 Serverlink
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
- SQL Server RDS
- Azure SQL Database
- Azure SQL Managed Instance
Twitter Adslink
We now support syncing data for the media_creative
entity. See our MEDIA CREATIVE table documentation for more information.
Zendesk Sunshinelink
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 Improvementslink
Jiralink
Our Jira connector no longer uses the use_webhooks
configuration field.