July 2026

Lite Connectors

Lite connectors are now available for the following sources:

Profound

Schema changes

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.

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.