July 2022

Dashboard Improvements

Active Incident Banner

On the connector details page in your Fivetran dashboard, we now display the Active Incident Banner for Connector Incidents and the Alerts Error side panel when there is an active high priority incident posted on our Status page.

Notification send options

You can now send Fivetran notifications to any email address. Previously, you could only send notifications to other Fivetran users. Learn more in our Send notifications to any email address documentation.

You can also now send Fivetran notifications to any system that accepts email-based triggers. The following systems support email notifications:

• Slack
• Microsoft Teams
• Opsgenie
• PagerDuty
• ServiceNow

Learn more in our Send notifications to third-party systems documentation.

New connectors

Amazon Ads

Amazon Ads is an advertising service that uses the pay-per-click model. Sellers only pay when shoppers click sellers' ads.

Read our Amazon Ads connector documentation.

Salesforce Commerce Cloud

Salesforce Commerce Cloud is an ecommerce platform that provides unified, intelligent digital commerce experiences, both online and in the store.

Read our Salesforce Commerce Cloud connector documentation.

Workday HCM

Workday HCM is a cloud-based human capital management platform that brings HR, recruiting, staffing, benefits administration, compensation management and related functions together in one system.

Read our Workday HCM connector documentation.

Schema changes

Criteo

We have added a new report, ADSET_STATISTICS_HOURLY_REPORT.

Facebook Ads

We have added two new fields, cost_per_inline_link_click and inline_link_click_ctr, to the COMMON_FIELDS fields group for prebuilt reports.

Google Ads

We have added two new reports, CAMPAIGN_ASSET and CUSTOMER_ASSET.

We have added the asset.source field to the asset resource.

We have added the ad_group_asset.source field to the AD_GROUP_ASSET report.

We have added the following fields to the CAMPAIGN report:

• campaign.local_services_campaign_settings.category_bids
• campaign.manual_cpa
• campaign.performance_max_upgrade.performance_max_campaign
• campaign.performance_max_upgrade.pre_upgrade_campaign
• campaign.performance_max_upgrade.status
• campaign.shopping_setting.feed_label

We have replaced the following fields in the following reports:

• accessible_bidding_strategy.maximize_conversions.target_cpa with accessible_bidding_strategy.maximize_conversions.target_cpa, in the ACCESSIBLE_BIDDING_STRATEGY report
• bidding_strategy.maximize_conversions.target_cpa with bidding_strategy.maximize_conversions.target_cpa, in the BIDDING_STRATEGY report
• campaign.maximize_conversions.target_cpa with campaign.maximize_conversions.target_cpa, in the CAMPAIGN report

We have removed the following fields from the USER_LIST report:

• user_list.rule_based_user_list.date_specific_rule_user_list.end_date
• user_list.rule_based_user_list.date_specific_rule_user_list.rule.rule_item_groups
• user_list.rule_based_user_list.date_specific_rule_user_list.rule.rule_type
• user_list.rule_based_user_list.date_specific_rule_user_list.start_date

We have added the manual_cpa field to the CAMPAIGN_BIDDING_STRATEGY_HISTORY metadata table.

We have renamed the target_cpa field to target_cpa_micros in the CAMPAIGN_BIDDING_STRATEGY_HISTORY metadata table.

We have added the video_views metric to the AD_STATS prebuilt report. We automatically re-sync the AD_STATS table to capture the video views data. This re-sync is free.

HubSpot

We have added a new table, MERGED_DEAL. You can use this table to find the merged deals. To learn more, see Merge deals.

We have deprecated the is_merged column from the DEAL table. We will not delete the existing column from your destination table. For new records, we will populate this column as NULL in your destination table.

We now sync the OWNER table using version 3 of the HubSpot API. For more information, see HubSpot's API documentation. We no longer sync the following columns from the OWNER table because the new API version does not return them:

• portal_id
• type
• user_id_including_inactive

We will not delete the existing columns from your destination table. For new records, we will populate these columns as NULL in your destination table.

We have added the following new tables:

• OWNER_TEAM
• ROLE
• TEAM
• TEAM_USER
• USERS

NOTE: We capture deletes for the ROLE, TEAM, TEAM_USER, and USERS tables.

To sync the TEAM, ROLE, and USERS tables, you must re-authenticate the connector because the endpoints need the settings.users.read and settings.users.teams.read scopes.

Instagram Business

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

• reel_comment
• reel_likes
• reel_plays
• reel_reach
• reel_shares
• reel_total_interactions

Qualtrics

We have added a new table, SURVEY_EMBEDDED_DATA.

We have added a new column, loop_id, to the QUESTION_RESPONSE table.

We no longer sync the DISTRIBUTION_CONTACT table for non-XM users.

Improvements

Airtable

Our Airtable connector is now generally available.

Read our Airtable connector documentation.

Asana

We have added the Date and Person custom fields to the TASK and PORTFOLIO tables.

AWS Lambda

Our AWS Lambda function connector now supports syncing data using an S3 bucket. Now, when setting up the connector, you can select your Sync method and opt to Sync directly or Sync through S3 bucket. If you choose the Sync through S3 bucket method, your function must push the data in a valid JSON format. We sync the data from the S3 file instead of the function’s returned response. In the direct method, we sync the data we receive in the function’s returned response. For more information, see our Function request and response documentation.

Braze

The Braze connector now supports Azure Blob Storage. For more information, see our setup instructions.

DocumentDB

Our DocumentDB connector is now generally available.

Read our DocumentDB database documentation.

Eloqua

The Eloqua connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Eloqua's priority-first syncs fetch the most recent 7 days' worth of data from the CONTACT_ACTIVITY table. To learn more, see our priority-first sync documentation.

Google Ads

We have upgraded our Google Ads connector to version 11 of the Google Ads API. For more information, see Google's v11 release note.

Google Search Console

We now support custom reports in our Google Search Console connector.

Jira

Now you can connect to your Jira Cloud instance using an API token. Now you can connect to your Jira on-premise instance using an application link. Refer to our Jira Setup Guide for details.

OneDrive

You can now configure your OneDrive connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

Pipedrive

We have added a new optional field, Personal API token, to the connector setup form. Now, if you want to sync the PERMISSION* tables, you must provide your personal API token. For more information, see our setup instructions. If you don't provide the personal API token, we exclude the tables from the sync. Previously, we synced the PERMISSION* tables without the API token.

We now use the permission_set_id column as the primary key for the PERMISSION_ASSIGNMENT table.

Qualtrics

Our Qualtrics connector is now generally available. Read our Qualtrics connector documentation.

Start time of the next sync for failed syncs

For failed syncs, Fivetran now calculates the start time of the next sync by adding a retry interval, which varies depending on the sync frequency, to the time of the sync failure.

Workday HCM

Our Workday HCM connector is now generally available. Read our Workday HCM connector documentation.

REST API Improvements

Failed webhook notifications

We have implemented email notification that informs you about webhook event sending failure. To turn it on, go to Account notifications page and change the Receive an email when webhook events failed to be sent value.

Fivetran Platform Connector

We have added two new optional parameters, is_account_level_connector and group, to the Fivetran Platform Connector REST API Request. You can now opt to retrieve account-level logs.

Intercom

We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Intercom connector by adding the auth section to payloads.

Postman Collection Update

We have added the Webhook management endpoints to our Postman collection.