April 2025

Lite Connectors

Lite connectors are now available for the following sources:

Ordergroove

Schema changes

AccuLynx

Effective April 1, 2025 we use a new April 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to enhance its usability.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`LEAD_HISTORY`
table	New Table	`LEAD_HISTORY`
`MILESTONE_HISTORY`
table	New Table	`MILESTONE_HISTORY`

Checkout.com

Effective April 3, 2025 we use a new April 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

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

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`FINANCIAL_ACTION_BY_PAYOUT_REPORT`
table	New Table			`FINANCIAL_ACTION_BY_PAYOUT_REPORT`

Docebo

Effective April 1, 2025 we use a new April 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to align with source changes.

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.

3 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CATALOG_CONTENT`
table	New Table		`CATALOG_CONTENT`
`CATALOGUE_ITEM`
table	Discontinued Table	`CATALOGUE_ITEM`		Data is available in the `CATALOG_CONTENT` table.
`COURSE`
column	New Column		`category_name` 🔑

Microsoft Advertising

We have extended the free sync period until May 1, 2025 for the following metadata and reporting tables:

ASSET_GROUP_ATTRIBUTE_HISTORY
ASSET_GROUP_HISTORY
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_MAX_DAILY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_MAX_HOURLY_REPORT
PRODUCT_DIMENSION_PERFORMANCE_MAX_DAILY_REPORT
PRODUCT_DIMENSION_PERFORMANCE_MAX_HOURLY_REPORT

Be sure to exclude the tables that you don't want to sync and count towards paid MAR before May 1, 2025.

SmartHR

Effective April 1, 2025 we use a new April 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to prevent or resolve data integrity issues.

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 • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`EMPLOYEE_CUSTOM_FIELD`
column	Primary Key Change	`value` 🔑		No longer a primary key.
column	Primary Key Change		`index` 🔑	Added to primary key.

Improvements

Okta

We have added a new child table, PROFILE_MAPPING_PROPERTY, to the PROFILE_MAPPING table.
We have added a new columns, source_name and target_name to the PROFILE_MAPPING table.