November 2024

Connector SDK

Fivetran Connector SDK

We have released the beta version of our Connector SDK.

Fivetran Connector SDK allows you to code a custom data connector using Python and deploy it as an extension of Fivetran. Fivetran automatically runs the connector at your scheduled frequency and manages the required compute resources. See our Connector SDK Quickstart Setup Guide to begin writing your connector.

fivetran-connector-sdk PyPI package

We have released version 0.11.21.1 of the PyPI package. We now show the connector_id in the success message of the fivetran deploy command.

We have released version 0.11.14.1 of the PyPI package. This release adds the following:

• Support for Python version 3.12.
• Adds a --force flag to fivetran deploy command which bypasses the connector exists check.

fivetran-api-playground PyPI package

We have released version 0.11.21.1 of the PyPI package. This release adds changelog section to our PyPI package.

We have released version 0.11.14.1 of the PyPI package. This release adds support for Python version 3.12.

Lite Connectors

Lite connectors are now available for the following sources:

• AccuLynx
• Algolia
• Betterworks
• Cimis
• Clazar
• Clubspeed
• Coassemble
• Compliance Checkpoint
• Dialpad
• Everflow
• Exact Online
• ExpenseIn
• e-conomic
• Formstack
• FourKites
• Freshsales
• Freshsuccess
• Google Classroom
• Google Tasks
• GreenPowerMonitor
• Jamf
• Jibble
• JobNimbus
• Khoros Communities
• Konnect Insights
• Lucca
• Mailjet
• Malomo
• Nice
• Nylas
• Packiyo
• PandaDoc
• Pigment
• Placer.ai
• Prisma Cloud
• REVIEWS.ai
• Rundeck
• SafeBase
• Sage HR
• Sana
• Sentry
• SugarCRM
• Unicommerce
• Vimeo
• Visit by GES
• Visma
• Walmart Marketplace
• Web Scraper
• Wicked Reports
• Xactly

Hybrid Deployment support

The following Lite connectors now support the Hybrid Deployment model:

Logs

Log event api_call removed

We have removed the api_call from the log event list. Use the new event, extract_summary, instead.

For more information, see our Logs documentation.

New Account Overview page

We have added a new Overview page on the Fivetran dashboard. The page provides you with a comprehensive overview of your account and enables you to see and manage your connectors, transformations, and destinations.

Read more about the new page in our documentation.

Transformations

Hybrid Deployment support

You can now set up Transformations for destinations with Hybrid Deployment configured.

Transformations for dbt Core

Updated dbt Quickstart package

We have updated the Quickstart packages for the following connectors:

• Amplitude to version 0.5.0
• Apple Search Ads to version 0.4.1
• Facebook Ads to version 0.8.0
• HubSpot to version 0.20.0
• Iterable to version 0.13.0
• Jira to version 0.19.0
• LinkedIn Ad Analytics to version 0.9.1
• Recurly to version 0.5.1
• Reddit Ads to version 0.3.1
• Zendesk Support to version 0.18.1

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

New connectors

Reltio

Reltio is a cloud-native master data management (MDM) platform. Read our Reltio connector documentation.

Yahoo DSP

Yahoo DSP is a marketing platform from Yahoo. Read our Yahoo DSP connector documentation.

Schema changes

Affinity

Amazon Ads

We have extended the free MAR period for the CAMPAIGN_PLACEMENT_REPORT_INCOMING prebuilt report.

All usage for this report will count towards free MAR until January 15, 2025.

We've added the following columns to the AD_GROUP_LEVEL_REPORT and ADVERTISED_PRODUCT_REPORT tables:

• add_to_list
• qualified_borrows
• royalty_qualified_borrows

We've added the following columns to the CAMPAIGN_LEVEL_REPORT, CAMPAIGN_PLACEMENT_REPORT_INCOMING, TARGETING_REPORT, and TARGETING_KEYWORD_REPORT tables:

• add_to_list
• qualified_borrows
• royalty_qualified_borrows
• top_of_search_impression_share

We've added the following columns to the ADVERTISED_PRODUCT_REPORT and PURCHASED_PRODUCT_TARGETING_REPORT tables:

• add_to_list
• add_to_list_from_clicks
• purchases_other_sku14d
• purchases_other_sku1d
• purchases_other_sku30d
• purchases_other_sku7d
• qualified_borrows
• qualified_borrows_from_clicks
• royalty_qualified_borrows
• royalty_qualified_borrows_from_clicks

See Amazon's reporting documentation for more details.

We have deprecated the following Sponsored Display version 2 reporting tables in accordance with Amazon's deprecation calendar:

• 'SD_AD_GROUP_REPORT'
• 'SD_ASIN_REPORT'
• 'SD_CAMPAIGN_REPORT'
• 'SD_MATCHED_TARGET_REPORT'
• 'SD_PRODUCT_AD_REPORT'
• 'SD_TARGET_REPORT'

NOTE: The tables listed above have stopped receiving new data. However, we've renamed these tables in your destination by adding the '_v_2' suffix to each of them. You still have access to old data.

We have added support for the following Sponsored Display version 3 reporting tables:

• 'SD_AD_GROUP_REPORT_V_3'
• 'SD_CAMPAIGN_REPORT_V_3'
• 'SD_MATCHED_TARGET_REPORT_V_3'
• 'SD_PRODUCT_AD_REPORT_V_3'
• 'SD_PURCHASED_PRODUCTS_REPORTS'
• 'SD_TARGET_REPORT_V_3'

NOTE: Until November 15, 2024, all usage related to these new reports counts towards free MAR.

Apple App Store

Our Apple App Store connector now uses the App Store Connect API to sync your data.

The connector schema has been updated. To better understand the differences between the two schemas, see our Previous Vs. New API Tables Mapping article. To directly compare the two connector schemas, see the links below:

• App Store Connect API schema - current version
• App Store Connect API schema - previous version

Braintree

We have added two new columns, billing_period_start_date and billing_period_end_date, to the TRANSACTION table. We are gradually rolling out this change to all existing connectors. Until the change is available for your connector, you may observe these columns as null in your destination table.
Contact our support team to re-sync the table and backfill the historical data for these columns.

Chameleon

ChargeDesk

Cin7 Core

Coupa

We have added a new table, SUPPLIER_PREFERRED_COMMODITIES_MAPPING. The table stores the preferred commodities of a supplier.

DCL Logistics

Expensify

Facebook Ads

Due to changes to the Facebook API, for the unique_actions and cost_per_unique_action_type custom report fields, we now support only the following action_type breakdowns:

• link_click
• onsite_conversion_messaging_first_reply
• onsite_conversion_total_messaging_connection
• outbound_click

We no longer support the following action_type breakdowns for the unique_actions and cost_per_unique_action_type fields:

• add_payment_info
• add_to_cart
• app_custom_event
• app_custom_event.fb_mobile_achievement_unlocked
• app_custom_event.fb_mobile_activate_app
• app_custom_event.fb_mobile_add_payment_info
• app_custom_event.fb_mobile_add_to_cart
• app_custom_event.fb_mobile_add_to_wishlist
• app_custom_event.fb_mobile_complete_registration
• app_custom_event.fb_mobile_content_view
• app_custom_event.fb_mobile_d2_retention
• app_custom_event.fb_mobile_d7_retention
• app_custom_event.fb_mobile_initiated_checkout
• app_custom_event.fb_mobile_level_achieved
• app_custom_event.fb_mobile_purchase
• app_custom_event.fb_mobile_rate
• app_custom_event.fb_mobile_search
• app_custom_event.fb_mobile_spent_credits
• app_custom_event.fb_mobile_tutorial_completion
• app_custom_event.other
• app_engagement
• app_install
• call_confirm_grouped
• checkin
• click_to_call_call_confirm
• click_to_call_callback_request_submitted
• click_to_call_native_20s_call_connect
• click_to_call_native_60s_call_connect
• click_to_call_native_call_placed
• click_to_join_new_channel_member
• comment
• commerce_event
• complete_registration
• credit_spent
• group_join
• initiate_checkout
• landing_page_view
• lead
• leadgen_grouped
• like
• mobile_app_install
• offline_conversion
• offline_conversion.add_payment_info
• offline_conversion.add_to_cart
• offline_conversion.add_to_wishlist
• offline_conversion.complete_registration
• offline_conversion.initiate_checkout
• offline_conversion.lead
• offline_conversion.other
• offline_conversion.purchase
• offline_conversion.search
• offline_conversion.view_content
• offsite_conversion
• offsite_conversion.fb_pixel_add_payment_info
• offsite_conversion.fb_pixel_add_to_cart
• offsite_conversion.fb_pixel_add_to_wishlist
• offsite_conversion.fb_pixel_complete_registration
• offsite_conversion.fb_pixel_custom
• offsite_conversion.fb_pixel_initiate_checkout
• offsite_conversion.fb_pixel_lead
• offsite_conversion.fb_pixel_purchase
• offsite_conversion.fb_pixel_search
• offsite_conversion.fb_pixel_view_content
• omni_achievement_unlocked
• omni_activate_app
• omni_add_to_cart
• omni_add_to_wishlist
• omni_app_install
• omni_complete_registration
• omni_custom
• omni_initiated_checkout
• omni_level_achieved
• omni_purchase
• omni_rate
• omni_search
• omni_spend_credits
• omni_tutorial_completion
• omni_view_content
• onsite_app_add_to_cart
• onsite_app_purchase
• onsite_app_view_content
• onsite_conversion.add_to_cart
• onsite_conversion.add_to_wishlist
• onsite_conversion.click_to_call
• onsite_conversion.donate
• onsite_conversion.find_location
• onsite_conversion.flow_complete
• onsite_conversion.initiate_checkout
• onsite_conversion.lead
• onsite_conversion.lead_grouped
• onsite_conversion.message_to_buy
• onsite_conversion.messaging_20s_call_connect
• onsite_conversion.messaging_60s_call_connect
• onsite_conversion.messaging_block
• onsite_conversion.messaging_business_calling_call_answered
• onsite_conversion.messaging_business_calling_call_initiated
• onsite_conversion.messaging_business_calling_call_missed
• onsite_conversion.messaging_business_calling_opt_in_accepted
• onsite_conversion.messaging_business_calling_opt_in_denied
• onsite_conversion.messaging_business_calling_opt_in_sent
• onsite_conversion.messaging_conversation_replied_7d
• onsite_conversion.messaging_conversation_started_7d
• onsite_conversion.messaging_order_created_v2
• onsite_conversion.messaging_order_shipped_v2
• onsite_conversion.messaging_user_call_placed
• onsite_conversion.messaging_user_depth_2_message_send
• onsite_conversion.messaging_user_depth_3_message_send
• onsite_conversion.messaging_user_subscribed
• onsite_conversion.messaging_welcome_message_view
• onsite_conversion.other
• onsite_conversion.post_save
• onsite_conversion.purchase
• onsite_conversion.view_content
• onsite_web_add_to_cart
• onsite_web_app_add_to_cart
• onsite_web_app_purchase
• onsite_web_app_view_content
• onsite_web_lead
• onsite_web_purchase
• onsite_web_view_content
• page_engagement
• photo_view
• post
• post_engagement
• post_reaction
• purchase
• rsvp
• search
• video_view
• view_content

Factbird

GitLab

Gladly

Google Ads

We have added two new metadata tables, AD_GROUP_BID_MODIFIER_HISTORY and CAMPAIGN_BID_MODIFIER_HISTORY.

HubSpot

Ironclad

Jira

We have added a new table, FIELD_PROJECT, with the following columns:

• field_id
• project_id

We are gradually rolling out these changes to all existing connectors. These changes are available only for Jira Cloud instances.

Perform a resync to fetch the historical data of the new table and columns.

NOTE: You must grant Fivetran the Administer Jira global permission to fetch the custom fields project's mapping data.

We have added a new table, ISSUE_USER_VOTE, with the following columns:

• issue_id
• user_id

We are gradually rolling out these changes to all existing connectors.

Perform a resync to fetch the historical data of the new table and columns.

NOTE: To capture ISSUE_USER_VOTE data, you must set the Allow users to vote on issues option to ON in your Jira account's general configurations.

Jira Align

Kustomer

We have added a new column, open_status_at, to the CONVERSATION_HISTORY table.

We have added the following new tables:

• BUSINESS_HOLIDAY
• BUSINESS_SCHEDULE
• BUSINESS_SCHEDULE_HOUR

We are gradually rolling out this change to all existing connectors.

Mambu

Medallia Agile Research

Navan

Ordway

Pipedrive

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

• billing_frequency
• billing_frequency_cycles
• billing_start_date

Productboard

Ramp

SolarWinds Service Desk

SparkPost

StackAdapt

StarRez

Teamwork

TikTok Ads

We added a buying_types filter to our calls to retrieve all possible buying_types entities {AUCTION, RESERVATION_RF, RESERVATION_TOP_VIEW} for the following tables:

• AD_HISTORY
• ADGROUP_HISTORY
• CAMPAIGN_HISTORY

We added the buying_type field to all three tables (AD_HISTORY, ADGROUP_HISTORY, CAMPAIGN_HISTORY) to reflect the buying_types filter value used in our data requests.

We added the following fields to the AD_HISTORY table (see the TikTok documentation for details):

• aigc_disclosure_type
• avatar_icon_web_uri
• brand_safety_postbid_partner
• brand_safety_vast_url
• branded_content_disabled
• call_to_action_id
• card_id
• carousel_image_index
• cpp_url
• creative_type
• dark_post_status
• deeplink_type
• dynamic_destination
• dynamic_format
• fallback_type
• identity_authorized_bc_id
• identity_id
• identity_type
• item_duet_status
• item_stitch_status
• music_id
• optimization_event
• page_id
• phone_number
• phone_region_calling_code
• phone_region_code
• product_set_id
• product_specific_type
• promotional_music_disabled
• shopping_ads_deeplink_type
• shopping_ads_fallback_type
• shopping_ads_video_package_id
• tiktok_page_category
• tracking_app_id
• tracking_pixel_id
• vast_moat_enabled
• vertical_video_strategy
• viewability_postbid_partner
• viewability_vast_url

We added the following fields to the ADGROUP_HISTORY table (see the TikTok documentation for details):

• adgroup_app_profile_page_state
• attribution_event_count
• bid_display_mode
• brand_safety_partner
• brand_safety_type
• click_attribution_window
• comment_disabled
• cpm
• delivery_mode
• discount_amount
• discount_percentage
• discount_type
• engaged_view_attribution_window
• feed_type
• identity_authorized_bc_id
• identity_id
• identity_type
• ios14_quota_type
• ios14_targeting
• is_smart_performance_campaign
• next_day_retention
• pre_discount_budget
• pre_discount_cpm
• predict_impression
• product_source
• promotion_target_type
• promotion_type
• promotion_website_type
• purchased_impression
• purchased_reach
• rf_estimated_cpr
• rf_estimated_frequency
• rf_purchased_type
• roas_bid
• saved_audience_id
• scheduled_budget
• search_result_enabled
• share_disabled
• shopping_ads_retargeting_actions_days
• shopping_ads_retargeting_custom_audience_relation
• shopping_ads_retargeting_type
• shopping_ads_type
• smart_audience_enabled
• smart_interest_behavior_enabled
• spending_power
• split_test_group_id
• split_test_status
• store_authorized_bc_id
• store_id
• String> tiktok_subplacements
• vbo_window
• vertical_sensitivity_id
• video_download_disabled
• view_attribution_window

We added the following fields to the CAMPAIGN_HISTORY table (see the TikTok documentation for details):

• app_id
• app_promotion_type
• bid_type
• budget_optimize_on
• campaign_app_profile_page_state
• campaign_product_source
• deep_bid_type
• is_advanced_dedicated_campaign
• is_search_campaign
• is_smart_performance_campaign
• objective
• optimization_goal
• postback_window_mode
• rf_campaign_type
• roas_bid
• rta_id
• rta_product_selection_enabled

Workable

Workday HCM

We have added the following new tables:

• ADDRESS_USE_FOR_REFERENCE
• ADDRESS_USE_FOR_TENANTED_REFERENCE
• ADDRESS_USAGE_TYPE
• ETHNICITY
• GENDER_IDENTITY
• LGBT_IDENTIFICATION
• LOCATION
• LOCATION_ADDRESS
• LOCATION_HIERARCHY
• LOCATION_TYPE
• LOCATION_USAGE
• PRONOUN
• QUALIFICATION_AWARD_AND_ACTIVITY
• QUALIFICATION_CERTIFICATION
• QUALIFICATION_CERTIFICATION_ATTACHMENT
• QUALIFICATION_COMPETENCY_ACHIEVEMENT
• QUALIFICATION_EDUCATION
• QUALIFICATION_INTERNAL_PROJECT_EXPERIENCE
• QUALIFICATION_JOB_HISTORY_ACHIEVEMENT
• QUALIFICATION_LANGUAGE
• QUALIFICATION_LANGUAGE_ABILITY
• QUALIFICATION_PROFESSIONAL_AFFILIATION
• QUALIFICATION_SPECIALITY_ACHIEVEMENT
• QUALIFICATION_TRAINING
• QUALIFICATION_WORK_EXPERIENCE
• SALARY_OVER_THE_CAP_COSTING_ALLOCATION_DETAIL
• SEXUAL_ORIENTATION
• WORKER_ALLOWANCE_PLAN
• WORKER_BONUS_PLAN
• WORKER_COMMMISION_PLAN
• WORKER_COSTING_ALLOCATION
• WORKER_COSTING_ALLOCATION_DETAIL
• WORKER_COSTING_ALLOCATION_INTERVAL
• WORKER_FUTURE_PAYMENT_PLAN
• WORKER_MERIT_PLAN
• WORKER_PERIOD_SALARY_PLAN
• WORKER_SALARY_AND_HOURLY
• WORKER_UNIT_ALLOWANCE_PLAN
• WORKER_UNIT_SALARY_PLAN

We have added the following columns to the WORKER and WORKER_HISTORY tables:

• user_name
• simplified_view
• user_language_code
• preferred_language_code
• locale_code
• hour_clock_code
• currency_code
• currency_numeric_code
• time_zone_code
• display_language_code

We are gradually rolling out these changes to all the existing connectors.

Improvements

Adyen

We have resolved an issue where the raw_acquirer_response column in the RECEIVED_PAYMENTS_REPORT table was not replicating.

Re-sync the table to update and populate the existing null values in your destination.

Aha!

We now incrementally sync the RELEASE table.

Amazon S3

We have improved the connector setup experience and made the following changes to the connector setup form:

• Added a new configuration option, Run connection test to perform an intermediate test during configuration
• Added a new configuration option, Preview Files to perform an intermediate test during configuration
• Added support for displaying fields based on the file type
• Added a new field, Quote character, to use an enclosing character
• Reorganised fields to make the setup form more intuitive
• Removed Infer as an option from the File Type field
• Removed the Enable Advanced Options toggle
• Changed the Null Sequence field to a toggle
• For the Delimiter field, we now use , as the default value
• For the Line Separator field, we now use \n as the default value

For more information, see our setup instructions. We are gradually rolling out these changes to all existing connectors.

Assembled

The Assembled connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Azure Blob Storage

The Azure Blob Storage connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Azure DevOps

The Azure DevOps connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Azure Event Hubs

The Azure Event Hubs connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Azure SQL Database

Azure SQL Database connectors configured for Hybrid Deployment now support Microsoft Entra ID (formerly Azure Active Directory) authentication.

Collibra

We have updated our sync strategy. We now re-import the ATTRIBUTE table once a month and no longer re-import the JOB table. Previously, we re-imported these two tables weekly.

commercetools

The commercetools connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Coupa

We have updated our sync strategy for the COMMODITY table. We now sync the table data using the commodities API endpoint.

Delighted

The Delighted connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

We have added table re-sync support. Previously, we only supported connector-level re-syncs.

NOTE: Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.

Factbird

We can now sync data from Factbird accounts with custom base URLs. To support this enhancement, we have made the following changes to the connector setup form:

• Added a new drop-down menu, Base URL, where you can select whether your account uses the default or a custom base URL
• Added the Custom base URL field for specifying your custom base URL

For more information, see our setup guide.

FreshTeam

We have added table re-sync support. Previously, we only supported connector-level re-syncs.

NOTE: Event-based tables and tables with a retention period at the source don't support this feature.

Gainsight Customer Success

The Gainsight Customer Success connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Google Ads

The Google Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Google Search Ads 360

We've added the following metadata tables to provide a more comprehensive schema:

• ad
• ad_group
• bidding_strategy
• campaign
• customer

We've added the following prebuilt reports to our Google Search Ads 360 connector:

• ad_conversion_action_and_device_report
• ad_device_report
• ad_group_conversion_action_and_device_report
• ad_group_device_report
• ad_group_report
• campaign_conversion_action_and_device_report
• campaign_device_report
• campaign_report
• customer_conversion_action_and_device_report
• customer_device_report
• customer_report
• keyword_conversion_action_and_device_report
• keyword_device_report
• keyword_report

Prebuilt reports are common report configurations that make it easier to get insight into your data without needing to create custom reports. For more details about this update, please refer to the Google Search Ads 360 ERD.

History mode support

History mode is now in beta for the following destinations:

• Azure Data Lake Storage
• OneLake
• S3 Data Lake

HubSpot

We have added support for HubSpot's Feedback Submissions API to sync the feedback submissions data in your HubSpot account. We are gradually rolling out this improvement to all existing connectors.

Impact

The Impact connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Ironclad

The Ironclad connector now supports OAuth 2.0 authentication. For more information, see our setup instructions.

Lever

The Lever connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Maxio SaaSOptics

We now re-import the INVOICE table once a week to capture updates and deletes.

We now re-import the TRANSACTION table once a day to capture updates and deletes. Previously, we only supported incremental sync for this table.

MongoDB

If your MongoDB server version is less than 4.0, you must upgrade to a supported version by March 1, 2025. Otherwise, the MongoDB drivers will no longer be compatible with your server version. Learn more in MongoDB's MongoDB's software lifecycle schedules documentation.

Navan

We now capture fixed-scale decimals for all columns containing financial data.

NetSuite SuiteAnalytics

The NetSuite SuiteAnalytics connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

OneLake

We have introduced new fields in the setup form: Workspace GUID and Lakehouse GUID.

For new connectors, these fields now replace the existing Workspace Name and Lakehouse Name fields.

For existing connectors, the new GUID fields have been added alongside the current Workspace Name and Lakehouse Name fields. We will sunset the original fields in a future update. Ensure that you update the new GUID fields before this change.

PayPal

The PayPal connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

PostgreSQL

We now support syncing the "oid" data type as LONG. See all supported data types in our PostgreSQL documentation.

PostgreSQL destination

All PostgreSQL implementations now support the Hybrid Deployment model. We are gradually rolling out this feature to all existing destinations. For more information, see the individual destination setup guides.

Recurly

The Recurly connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Salesforce

For roll-up summary fields that reference formula fields, we now round formula field values to their configured scale before calculating the roll-up summary result, aligning with Salesforce behavior. This improvement applies to BigQuery, Databricks, PostgreSQL, Redshift, and Snowflake destinations. For other destinations, we calculate the roll-up summary result without rounding.

We are gradually rolling out this change to all existing connectors.

SAP Concur

We have added a new field, Historical Sync Limit, to the connector setup form. This allows you to select a date to limit the historical data sync to. The historical sync limit applies to all incremental tables. This change applies to all new and existing connectors. For an existing connector, you can edit the connection details and select a date. We have also added support for the historical_sync_limit field for connectors created using the Create a Connector endpoint. For more information, see our REST API config.

NOTE: Updating the value of the Historical Sync Limit may trigger a complete connector resync.

We are gradually rolling out this feature to all connectors.

Sentry

The Sentry connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

ServiceNow

We have added support for Okta authentication. We will be gradually rolling out this feature to existing connections.

SFTP

We have improved the connector setup experience and made the following changes to the connector setup form:

• Added a new configuration option, Preview Files, to perform an intermediate test during configuration
• Added support for displaying fields based on the file type
• Added a new field, Quote character, to use an enclosing character
• Reorganised fields to make the setup form more intuitive
• Removed Infer as an option from the File Type field
• Removed the Enable Advanced Options toggle
• Changed the Null Sequence field to a toggle
• For the Delimiter field, we now use , as the default value
• For the Line Separator field, we now use \n as the default value

For more information, see our setup instructions and REST API configuration. We are gradually rolling out these changes to all existing connectors.

SharePoint

The SharePoint connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Shopify

We have fixed a data integrity issue in the currency column of the CUSTOMER table. If you observe null values for the column in your destination, trigger a re-sync of the CUSTOMER table.

Slack

The Slack connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Snowflake

We now support IAM role authentication to authorize S3 buckets associated with Snowflake destinations configured for the Hybrid Deployment model.

Spotify Ads

Our Spotify Ads connector is now generally available.

Read our Spotify Ads connector documentation.

Sprout Social

The Sprout Social connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

StackAdapt

We now capture deletes only for the following tables:

• ADVERTISER
• AUDIENCE
• CAMPAIGN
• CAMPAIGN_GROUP
• CONVERSION_TRACKER
• CREATIVE
• CUSTOM_SEGMENT_OPTION
• DEAL_GROUP
• RETARGETING_AUDIENCE
• SUPPLY_SOURCE_OPTION

Previously, we captured deletes for all the tables.

We have made the following changes to the sync strategy:

• We now incrementally sync the following tables and their child tables to capture new records:

  • INSIGHT_CAMPAIGN_AUDIENCE
  • INSIGHT_CAMPAIGN_AUDIENCE_AB
  • INSIGHT_CAMPAIGN_BID_FACTOR
  • INSIGHT_CAMPAIGN_CATEGORY
  • INSIGHT_CAMPAIGN_CREATIVE_TACTIC
  • INSIGHT_CAMPAIGN_DEAL
  • INSIGHT_CAMPAIGN_DEMOGRAPHIC
  • INSIGHT_CAMPAIGN_DEVICE
  • INSIGHT_CAMPAIGN_GEO
  • INSIGHT_CAMPAIGN_GROUP_AUDIENCE
  • INSIGHT_CAMPAIGN_GROUP_AUDIENCE_AB
  • INSIGHT_CAMPAIGN_GROUP_BID_FACTOR
  • INSIGHT_CAMPAIGN_GROUP_CATEGORY
  • INSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTIC
  • INSIGHT_CAMPAIGN_GROUP_DEAL
  • INSIGHT_CAMPAIGN_GROUP_DEMOGRAPHIC
  • INSIGHT_CAMPAIGN_GROUP_DEVICE
  • INSIGHT_CAMPAIGN_GROUP_GEO
  • INSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENT
  • INSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCE
  • INSIGHT_CAMPAIGN_RETARGETING_SEGMENT
  • INSIGHT_CAMPAIGN_SUPPLY_SOURCE
  • STATS_DELIVERY_ADVERTISER
  • STATS_DELIVERY_CAMPAIGN
  • STATS_DELIVERY_CAMPAIGN_GROUP
  • STATS_DELIVERY_CONVERSION_TRACKER
  • STATS_DELIVERY_NATIVE_AD

• We now re-import the remaining tables and their child tables during every sync to capture updates and deletes.

Talkdesk

The Talkdesk connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Teamwork

We no longer re-import the CALENDAR_EVENT, PROJECT_BUDGET,TIME_TRACKING, and USERS tables and its child tables once a week.

We incrementally sync the ACTIVITY, CALENDAR_EVENT, TASK, and TIME_TRACKING tables based on the updated timestamp.

Transcend

We can now sync data from Transcend accounts hosted in the US region. To support this enhancement, we have added a new drop-down menu, Region, to the connector setup form. For more information, see our setup guide.

Uservoice

The Uservoice connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Workday RaaS

If a selected primary key contains a null value in your reports, we display a warning on the connector dashboard and insert the record with a null value in your destination. If the destination does not support null values, we insert the row with the default value for the column instead.

Xero

We have improved the decimal precision of the currency_rate columns and now support a scale of 10 for decimal values in the currency_rate columns of the following tables:

• BANK_TRANSACTION
• BANK_TRANSFER
• CREDIT_NOTE
• INVOICE
• OVERPAYMENT
• PAYMENT
• PREPAYMENT

Previously, we supported a scale of 6 for decimal values and rounded the values to six decimal places.

Yahoo Search Ads Yahoo Japan

We have upgraded our Yahoo Search Ads Yahoo Japan connector to Search Ads API v15 from v12.

Zendesk Chat

The Zendesk Chat connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Zendesk Support

We have added a new field, Historical sync time frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connector, you can edit the connection details and set the time frame value. For more information, see our Historical sync time frame documentation.

We apply the historical sync limit to the following tables only:

• SATISFACTION_RATING
• TICKET
• TICKET_TAG
• TICKET_FIELD

We are gradually rolling out this feature to all connectors.

REST API Improvements

New Log Service Management endpoint to list logging services within account

We have implemented a new Log Service Management API endpoint for our REST API. You can now leverage the new List all logging services within account feature.