July 2026

Lite Connectors

Lite connectors are now available for the following sources:

Logs

Dynatrace External Logging

We now support Dynatrace as an external logging service. You can connect Dynatrace at both the account and destination levels to collect and query your Fivetran logs. We are gradually rolling out this feature to all accounts.

To set up the Dynatrace logging service, go to Account Settings > General> External Logging, or go to your destination settings in your Fivetran dashboard. For more information, see our Dynatrace Setup Guide.

Schema changes

AdRoll

We have added new dimension columns to the ALL_ADS, ALL_ADGROUPS, ALL_CAMPAIGNS, and ALL_ADVERTISABLES report types. These columns contain additional dimension fields returned by the AdRoll API and can be selected in your connection's Dimensions configuration.

New columns — ALL_ADS

actualStatusString
adcrabEID
adsManagerPermalink
callToAction
campaignType
channel
disapprovalReason
facebookPermalink
instagramPermalink
isDynamic
labelsString
linkedInPermalink
previewURL
remoteStatus
syncError
syncStatus
utmCampaign
utmContent
utmMedium
utmSource
utmTerm

New columns — ALL_ADGROUPS

actualStatusString
adsManagerPermalink
adType
kpiCurrency
kpiGoal
kpiMetric
processingStatus
significantFlightEndDate
significantFlightStartDate
syncError
syncStatus

New columns — ALL_CAMPAIGNS

abmType
actualStatusString
adsManagerPermalink
automationEID
automationName
automationNodeEID
billingAuthStatus
budgetEndDate
budgetGoal
budgetSettingsString
budgetStartDate
budgetType
campaignGroupEID
campaignGroupName
disabled
funnelStage
isBillable
isBudgetBalancingAutomated
isConnectedChannel
isFrozen
isIntegrated
klaviyoFlowEID
klaviyoFlowName
newsletterScheduled
newsletterScheduledDate
newsletterSends
playbookEID
playbookName
playbookType
processingStatus
proxyStrategyEID
proxyStrategyIsFrozen
proxyStrategyName
proxyStrategyStatus
syncError
syncStatus
targetingType
useCase

New columns — ALL_ADVERTISABLES

businessUnit
isAbmCustomer

Cornerstone

Effective July 14, 2026 we use a new July 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

179 total changes • 118 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ASSESSMENT_TEST`
table	New Table		`ASSESSMENT_TEST`
`CULTURE_CORE`
table	New Table		`CULTURE_CORE`
`CURRICULUM_STRUCTURE_CORE`
table	New Table		`CURRICULUM_STRUCTURE_CORE`
`GOAL`
column	Discontinued Column	`active_flag`
column	Discontinued Column	`aligned_with`
column	Discontinued Column	`categories_list`
column	Discontinued Column	`created_by_id`
column	Discontinued Column	`created_by_name`
column	Discontinued Column	`deleted_flag`
column	Discontinued Column	`difficulty_to_achieve_title`
column	Discontinued Column	`marked_as_final`
column	Discontinued Column	`marked_as_final_date`
column	Discontinued Column	`num_attachment`
column	Discontinued Column	`parent_goal_title`
column	Discontinued Column	`perspective_title`
column	Discontinued Column	`status_title`
column	Discontinued Column	`target_date`
column	Discontinued Column	`visible_to_others`
column	New Column		`compatibility_goal_status_id`
column	New Column		`due_date`
column	New Column		`is_active`
column	New Column		`is_marked_as_final`
column	New Column		`is_visible_to_others`
column	New Column		`last_touched_date_utc`
column	New Column		`parent_goal_id`
column	New Column		`progress_status_id`
column	New Column		`reference`
column	New Column		`type_id`
`JOB_REQUISITION_TARGET_OU_CORE`
table	New Table		`JOB_REQUISITION_TARGET_OU_CORE`
`REQUISITION_CF`
column	New Column		`last_touched_date_utc`
`REQUISITION_LOCATION`
table	Discontinued Table	`REQUISITION_LOCATION`		Data is available in the `JOB_REQUISITION_TARGET_OU_CORE` table.
`TEST`
table	Discontinued Table	`TEST`		Data is available in the `ASSESSMENT_TEST` table.
`TRAINING`
column	Discontinued Column	`classification`
column	Discontinued Column	`electronic_signature_required`
column	Discontinued Column	`is_ojt_enabled`
column	Discontinued Column	`keywords`
column	Discontinued Column	`latest_version`
column	Discontinued Column	`lo_billing_entity_name`
column	Discontinued Column	`lo_create_dt`
column	Discontinued Column	`lo_created_by`
column	Discontinued Column	`lo_created_by_fullname`
column	Discontinued Column	`lo_created_by_user_ref`
column	Discontinued Column	`lo_currency_code`
column	Discontinued Column	`lo_currency_symbol`
column	Discontinued Column	`lo_email_option_id`
column	Discontinued Column	`lo_end_dt`
column	Discontinued Column	`lo_eval_01`
column	Discontinued Column	`lo_eval_02`
column	Discontinued Column	`lo_eval_03`
column	Discontinued Column	`lo_instructor`
column	Discontinued Column	`lo_language`
column	Discontinued Column	`lo_material_status`
column	Discontinued Column	`lo_material_type_active`
column	Discontinued Column	`lo_object_id`
column	Discontinued Column	`lo_owners_ids`
column	Discontinued Column	`lo_postwork_titles`
column	Discontinued Column	`lo_prework_titles`
column	Discontinued Column	`lo_provider`
column	Discontinued Column	`lo_provider_active`
column	Discontinued Column	`lo_provider_address_1`
column	Discontinued Column	`lo_provider_address_2`
column	Discontinued Column	`lo_provider_city`
column	Discontinued Column	`lo_provider_mailstop`
column	Discontinued Column	`lo_provider_state`
column	Discontinued Column	`lo_provider_zip`
column	Discontinued Column	`lo_publication_created_by`
column	Discontinued Column	`lo_publication_created_date`
column	Discontinued Column	`lo_publication_published`
column	Discontinued Column	`lo_ref`
column	Discontinued Column	`lo_root_id`
column	Discontinued Column	`lo_root_ref`
column	Discontinued Column	`lo_root_title`
column	Discontinued Column	`lo_secondary_training_provider`
column	Discontinued Column	`lo_skills`
column	Discontinued Column	`lo_status`
column	Discontinued Column	`lo_timezone_code`
column	Discontinued Column	`lo_title`
column	Discontinued Column	`lo_training_ref`
column	Discontinued Column	`lo_type`
column	Discontinued Column	`lo_type_id`
column	Discontinued Column	`object_type`
column	New Column		`effective_eval_01_id`
column	New Column		`effective_eval_02_id`
column	New Column		`effective_eval_03_id`
column	New Column		`email_option_id`
column	New Column		`gcid`
column	New Column		`is_multi_assignment_allowed`
column	New Column		`is_multi_request_allowed`
column	New Column		`is_multi_request_orig_approval_applied`
column	New Column		`lo_create_date`
column	New Column		`lo_end_date`
column	New Column		`proficiency_level`
column	New Column		`provider_reference`
column	New Column		`publication_create_date`
column	New Column		`publication_created_by_user_id`
column	New Column		`reference`
column	New Column		`source_object_id`
column	New Column		`thumbnail_location`
`TRAINING_ASSIGNMENT_CORE`
table	New Table		`TRAINING_ASSIGNMENT_CORE`
`TRAINING_ASSIGNMENT_USER`
column	Discontinued Column	`pu_is_dymanic_remove`
column	Discontinued Column	`pu_object_id`
column	Discontinued Column	`pu_proxy_id` 🔑		No longer a primary key.
column	Discontinued Column	`pu_user_id` 🔑		No longer a primary key.
column	New Column		`is_dynamic_removed`
column	New Column		`last_touched_date_utc`
column	Primary Key Change		`proxy_id` 🔑	New primary key.
column	Primary Key Change		`user_id` 🔑	New primary key.
`TRAINING_AVAILABILITY_BY_OU_CORE`
table	New Table		`TRAINING_AVAILABILITY_BY_OU_CORE`
`TRAINING_LOCAL_CORE`
table	New Table		`TRAINING_LOCAL_CORE`
`TRAINING_MATERIAL_TYPE_CORE`
table	New Table		`TRAINING_MATERIAL_TYPE_CORE`
`TRAINING_MATERIAL_TYPE_LOCAL_CORE`
table	New Table		`TRAINING_MATERIAL_TYPE_LOCAL_CORE`
`TRAINING_PROVIDER_CORE`
table	New Table		`TRAINING_PROVIDER_CORE`
`TRAINING_TYPE_CORE`
table	New Table		`TRAINING_TYPE_CORE`
`TRAINING_TYPE_LOCAL_CORE`
table	New Table		`TRAINING_TYPE_LOCAL_CORE`
`TRANSCRIPT`
column	Discontinued Column	`archived`
column	Discontinued Column	`exempt_approver_reason`
column	Discontinued Column	`exempt_reason`
column	Discontinued Column	`is_archive`
column	Discontinued Column	`last_touched_dt_utc`
column	Discontinued Column	`training_purpose`
column	Discontinued Column	`training_purpose_category`
column	Discontinued Column	`user_lo_assignor`
column	Discontinued Column	`user_lo_assignor_ref`
column	Discontinued Column	`user_lo_num_attempts`
column	Discontinued Column	`user_lo_status_group_id`
column	Discontinued Column	`user_lo_timezone_code`
column	New Column		`is_hidden_in_ui`
column	New Column		`last_touched_date_utc`
column	New Column		`license_expiration_dt`
column	New Column		`license_id`
column	New Column		`license_status_id`
column	New Column		`training_purpose_category_id`
column	New Column		`training_purpose_id`
`TRANSCRIPT_DELIVERY_METHOD_LOCAL_CORE`
table	New Table		`TRANSCRIPT_DELIVERY_METHOD_LOCAL_CORE`
`TRANSCRIPT_STATUS_LOCAL_CORE`
table	New Table		`TRANSCRIPT_STATUS_LOCAL_CORE`
`USERS`
column	Discontinued Column	`address_1`
column	Discontinued Column	`address_2`
column	Discontinued Column	`appr_id`
column	Discontinued Column	`appr_mailstop`
column	Discontinued Column	`appr_name_first`
column	Discontinued Column	`appr_name_last`
column	Discontinued Column	`appr_ref`
column	Discontinued Column	`approval`
column	Discontinued Column	`city`
column	Discontinued Column	`company_no`
column	Discontinued Column	`country`
column	Discontinued Column	`hire_date_last`
column	Discontinued Column	`hire_date_orig`
column	Discontinued Column	`i_mgr_email`
column	Discontinued Column	`i_mgr_id`
column	Discontinued Column	`i_mgr_name_first`
column	Discontinued Column	`i_mgr_name_last`
column	Discontinued Column	`indirect_manager_name`
column	Discontinued Column	`indirect_manager_ref`
column	Discontinued Column	`is_user_absent`
column	Discontinued Column	`mailstop`
column	Discontinued Column	`mgr_email`
column	Discontinued Column	`mgr_id`
column	Discontinued Column	`mgr_mailstop`
column	Discontinued Column	`mgr_name_first`
column	Discontinued Column	`mgr_name_last`
column	Discontinued Column	`mgr_ref`
column	Discontinued Column	`state`
column	Discontinued Column	`tax_override`
column	Discontinued Column	`tax_override_unit`
column	Discontinued Column	`termination_type`
column	Discontinued Column	`type`
column	Discontinued Column	`vat_number`
column	Discontinued Column	`zip`
column	New Column		`absent`
column	New Column		`address_id`
column	New Column		`approvals`
column	New Column		`approver_id`
column	New Column		`company_number`
column	New Column		`indirect_manager_id`
column	New Column		`last_hire_date`
column	New Column		`manager_id`
column	New Column		`original_hire_date`
column	New Column		`type_id`

FireHydrant

Effective July 2, 2026 we use a new July 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

9 total changes • 6 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`POST_MORTEM_REPORT`
table	Discontinued Table	`POST_MORTEM_REPORT`		Data is available in the `RETROSPECTIVE_REPORT` table.
`POST_MORTEM_REPORT_ADDITIONAL_DETAIL`
table	Discontinued Table	`POST_MORTEM_REPORT_ADDITIONAL_DETAIL`
`POST_MORTEM_REPORT_QUESTION`
table	Discontinued Table	`POST_MORTEM_REPORT_QUESTION`
`POST_MORTEM_REPORT_QUESTION_AVAILABLE_OPTION`
table	Discontinued Table	`POST_MORTEM_REPORT_QUESTION_AVAILABLE_OPTION`
`POST_MORTEM_REPORT_QUESTION_CONVERSATION`
table	Discontinued Table	`POST_MORTEM_REPORT_QUESTION_CONVERSATION`
`POST_MORTEM_REPORT_TAG_LIST`
table	Discontinued Table	`POST_MORTEM_REPORT_TAG_LIST`
`RETROSPECTIVE_REPORT`
table	New Table		`RETROSPECTIVE_REPORT`
`RETROSPECTIVE_REPORT_FIELD`
table	New Table		`RETROSPECTIVE_REPORT_FIELD`
`RETROSPECTIVE_REPORT_SECTION`
table	New Table		`RETROSPECTIVE_REPORT_SECTION`

Front

We have added new custom_* columns to the CONVERSATION table to sync data from Front conversation custom fields.

Jira

We now capture deletes for the ASSET_OBJECT table using the _fivetran_deleted column. Perform a resync to backfill historical data.

Loopio

Effective July 1, 2026 we use a new July 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

13 total changes • 0 possible breaking changes

Table/column	Change type	New name
`LIBRARY_ENTRIES`
column	New Column	`alert_text`
column	New Column	`usage_counts_project_usage_count`
column	New Column	`usage_counts_times_copied`
column	New Column	`usage_counts_total_usage_count`
`PROJECT_ENTRIES`
column	New Column	`answer_text`
column	New Column	`assignee_id`
column	New Column	`assignee_type`
column	New Column	`question`
column	New Column	`reviewer_id`
column	New Column	`reviewer_type`
`PROJECT_ENTRIES_COMPLIANCE_ANSWER`
column	New Column	`label`
`PROJECT_SUMMARY`
column	New Column	`completed_date`
column	New Column	`template_id`

PagerDuty

Effective July 1, 2026 we use a new July 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`USER_DELEGATION`
table	New Table		`USER_DELEGATION`
`USERS_SESSION`
table	Discontinued Table	`USERS_SESSION`		Data is available in the `USER_DELEGATION` table.

Personio

Effective July 2, 2026 we use a new July 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

33 total changes • 8 possible breaking changes

Table/column	Change type	Old name	New name
`ATTENDANCE`
column	Discontinued Column	`break`
column	Discontinued Column	`employee_id`
column	Discontinued Column	`is_holiday`
column	Discontinued Column	`is_on_time_off`
column	New Column		`created_at`
column	New Column		`is_auto_generated`
column	New Column		`person_id`
`PROJECT`
column	Discontinued Column	`attributes_active`
column	Discontinued Column	`attributes_created_at`
column	Discontinued Column	`attributes_name`
column	Discontinued Column	`attributes_updated_at`
column	New Column		`assigned_to_all`
column	New Column		`billable`
column	New Column		`client_name`
column	New Column		`cost_center_id`
column	New Column		`created_at`
column	New Column		`description`
column	New Column		`end_date`
column	New Column		`name`
column	New Column		`parent_project_id`
column	New Column		`project_code`
column	New Column		`project_type`
column	New Column		`start_date`
column	New Column		`status`
column	New Column		`updated_at`
`REPORT_EMPLOYEE_ATTRIBUTE_ABSENCE_OVERVIEW`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_ABSENCE_OVERVIEW`
`REPORT_EMPLOYEE_ATTRIBUTE_ABSENCE_PERIOD`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_ABSENCE_PERIOD`
`REPORT_EMPLOYEE_ATTRIBUTE_COST_CENTER`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_COST_CENTER`
`REPORT_EMPLOYEE_ATTRIBUTE_DURATION`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_DURATION`
`REPORT_EMPLOYEE_ATTRIBUTE_ENTITY`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_ENTITY`
`REPORT_EMPLOYEE_ATTRIBUTE_PERFORMANCE_KPI`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_PERFORMANCE_KPI`
`REPORT_EMPLOYEE_ATTRIBUTE_PERFORMANCE_TARGET`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_PERFORMANCE_TARGET`
`REPORT_EMPLOYEE_ATTRIBUTE_TEXT`
table	New Table		`REPORT_EMPLOYEE_ATTRIBUTE_TEXT`

Workday Financial Management

We've added a new table, ALLOCATION_POOL_HIERARCHY. The table contains allocation pool hierarchy definitions used for organizing and categorizing allocation pools.

We've added a new table, ALLOCATION_POOL_HIERARCHY_POOL. The table contains the allocation pool members that belong to each allocation pool hierarchy.

Workday HCM

We have added a new column, city, to the CANDIDATE table.

We have stopped syncing data into the costing_override_worktag_ids column of the WORKER_COSTING_ALLOCATION_DETAIL table since we sync the same data in the id column of the WORKER_COSTING_ALLOCATION_DETAIL_WORKTAG table. You can now discontinue using the costing_override_worktag_ids column in your downstream transformation, and remove it from your destination.

Improvements

Confluent Cloud

We now support OAuth 2.0 authentication for the Confluent Cloud connector. You can select your authentication method (API Key or OAuth 2.0) using either one of the following:

Connection setup form: Use the new Authentication method field.
Fivetran REST API: Specify either API_KEY or OAUTH in the new auth_method parameter.

For more information, see our setup guide and Fivetran REST API.

Expensify

We have improved data integrity for the REPORT_ACTION_LIST and REPORT_APPROVER tables. We now use a 31-day lookback window during incremental syncs for these tables.

FTP

We have added a new feature, Dynamically extract tables. You can now define a single regex pattern with a named capture group, (?<table>...), to automatically extract table names from file paths. This feature automatically creates and maps destination tables based on your file naming patterns, eliminating the need for manual intervention.

To support this feature, we have made the following changes to the connection setup form:

Added a new option, File mapping, that allows you to choose between Define per table and Dynamically extract tables.
Added a new field, Table extraction pattern, to specify your own regex pattern.
Added a new button, Preview, to validate the specified regex pattern.

Key benefits include:

Simplified configuration: Avoids repetitive setup for multiple entities.
Automatic table creation: Captures new entities as they appear in your source, without additional configuration.

For more information, see our Dynamic Table Mapping tutorial and setup instructions.

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

We now support specifying custom primary keys for tables created through dynamic table mapping.

Mambu

We have changed our sync strategy for the DEPOSIT_TRANSACTION table. We now incrementally sync the table.