Integrate.io logo

Integrate.io Release Notes & Product Updates

An overview of the latest updates and product improvements. Got a product update or feature you'd like to see supported? Let us know - support@integrate.io

May 2026: Auth0 SSO, Salesforce Formula Sync & Ad Reporting

ELT & CDC
May's release cycle focused on deepening ad platform reporting coverage, expanding Salesforce sync control, and hardening pipeline reliability across connectors and notification workflows.

Introducing Auth0 SSO
Users can now sign in via SSO using Auth0, and organization admins can configure SSO and enforce IdP-only logins for their accounts, also giving teams a centralized, secure authentication path without managing individual credentials.

Salesforce Formula Field Sync
Salesforce formula fields can now be synced either globally for the entire source or on a per-table basis, giving teams granular control over which calculated fields are included in their pipelines. Formula fields are clearly marked in the UI, so users can identify and configure them without additional documentation lookups.

New Features
  • Snowflake Custom Host: Users can now specify an optional custom Snowflake host when configuring a Snowflake destination: supporting non-standard deployments and use cases like those of Yuki Data, a partner who's focused on optimizing data warehouse cost and spend on a custom Snowflake setup.
  • Google Ads Time-Variant Keyword and Budget Reports: Five new KEYWORDS_PERFORMANCE_REPORT streams (daily, weekly, monthly, quarterly, and yearly) are now available, along with a new BUDGET_PERFORMANCE_REPORT_BY_CAMPAIGN collection, making time-segmented keyword and budget data accessible for more granular paid-search analysis.
  • Google Ads All-Time Metrics Collection: A new `_TIMES` collection is now available for every Google Ads report, consolidating all-time aggregated metrics alongside the existing time-windowed streams - removing the need to union multiple reports to get full-range totals.
  • TikTok Ads Expanded Field Coverage: A broad set of additional fields is now available on ad_groups, ads, campaigns, creative_assets_videos, and pixels collections, with metrics and dimensions exposed on most report collections and dimension and metric selections persisted across sessions.
  • Destination Column Default Preservation: Existing column defaults on Redshift and Snowflake destination tables are no longer overwritten during pipeline runs, protecting intentional database-level defaults from being cleared by sync operations.

Improvements
  • When new tables are added to a Salesforce V2 source, their incremental replication key and streaming support are now saved automatically, so incremental syncs and streaming options work correctly for newly added tables without additional configuration.

Fixes
  • Chunking issue on composite string primary keys that could cause rows to be missed or duplicated during chunk-based syncs - now resolved.
  • Snowflake configuration validation no longer rejects pipelines where the custom host field is unset, allowing existing Snowflake pipelines to start normally.
  • PostgreSQL 14+ tables that had not been analyzed no longer stall on resync - reliable initial sync behavior has been restored.
  • Pipeline hooks no longer send duplicate email notifications when the same hook is attached to multiple pipelines.
  • Enterprise SAML users are no longer blocked at login when their identity provider does not set the `email_verified` attribute.
  • Data Observability sync lag alert no longer triggers a false positive when a sync returns no data.

Performance Enhancements
  • DB2 and BigQuery connectors now support parallel chunk workers for initial sync, splitting large tables across concurrent threads and reducing time-to-first-value when onboarding new sources or backfilling historical data.

Let us know what you think of these updates - your input shapes what we build next.

3 days ago

April 2026: Parallel Workers, DB2 Controls, and Analytics Enhancements

ELT & CDC
April's release cycle focused on accelerating initial syncs, expanding ad and analytics coverage, and tightening reliability across long-running CDC pipelines.

Introducing Parallel Workers for Initial Sync
Initial syncs from MySQL, PostgreSQL, Snowflake, and Redshift sources now run with parallel chunk workers, splitting large tables across multiple concurrent threads. The result is materially faster time-to-first-value when onboarding new sources or backfilling history, particularly on wide tables and large row counts where initial sync used to be the bottleneck before incremental CDC could take over.

New Features
  • Custom Table List Fetch for DB2: Users can now select specific tables when configuring a DB2 source instead of pulling the full catalog at connection time, eliminating the schema-fetch timeouts that previously blocked setup against databases with very high table counts. This option is currently feature-flagged and off by default.
  • ELT-to-ETL Initial Sync Script Generator for DB2 to BigQuery: The cross-product Initial Sync Script generator now supports DB2 (LUW) as a source and BigQuery as a destination, letting customers seed a BigQuery warehouse from DB2 through ETL and then hand off to ELT for ongoing CDC.
  • Expanded Google Ads Coverage: The Google Ads connector now exposes additional fields on the ad_group_ads and keyword_view collections, including bidding strategy, negative keyword flags, and a broader set of performance metrics like clicks, impressions, conversions, and view-through conversions for richer paid-search reporting.
  • Google Ads Incremental Reports: ACCOUNT_PERFORMANCE_REPORT, AD_PERFORMANCE_REPORT, and ADGROUP_PERFORMANCE_REPORT now sync incrementally instead of full-refresh, reducing API consumption and shortening sync windows for accounts with long reporting histories.
  • Adobe Analytics OAuth Server-to-Server: The Adobe Analytics connector has migrated from the JWT authentication flow to OAuth Server-to-Server, keeping pipelines compliant with Adobe's authentication roadmap and avoiding the disruption of the JWT sunset.
  • Trial Day Counter: Users without an active subscription now see remaining trial days in the dashboard, making it clearer how much evaluation time is left before a billing decision is needed.

Improvements
  • The TikTok connector now consolidates all `pixel_instant_page_events` collections into a single collection, simplifying downstream modeling and removing the need to union near-duplicate streams.
  • The MySQL connector's GTID handling has been reworked with a `gtidBaseline` value persisted in pipeline state, resolving connection failures when pipelines move to a new source server.
  • The DB2 connector's Generate CDC SQL script generation has been parallelized and the timeout extended from one to five minutes, preventing setup timeouts on larger DB2 schemas.
  • GA4 Export primary key uniqueness has been improved by including `user_pseudo_id`, `event_bundle_sequence_id`, and `batch_event_index` in the `event_custom_id` hash, eliminating duplicate-key collisions on high-volume GA4 streams.

Performance Enhancements
  • DB2 to BigQuery initial sync has been parallelized end-to-end, cutting initial-load wall time on the path most commonly used to seed BigQuery warehouses from DB2 sources.
  • The MySQL connector now uses a ten-second connection timeout by default, eliminating the TLS handshake failures that previously caused intermittent pipeline restarts on higher-latency source networks.

Take a look at what shipped this cycle and tell us which improvements you'd like to see go further.

about 1 month ago

March 2026: DB2 Integration, New Streams, and UI Fixes

ELT & CDC
We are excited to share a recap of the latest updates and enhancements made throughout March 2026. This month, we focused on improving user experience, adding new features, and enhancing the functionality of existing tools.

Introducing DB2 Integration
  • We are thrilled to announce the addition of support for IBM DB2 databases as a source in our platform. Users can now easily configure DB2 connections through a user-friendly interface, enabling the replication of tables and tracking changes using continuous data capture (CDC) functionality. The setup process is simplified with step-by-step guidance, and users can generate automated SQL setup scripts for CDC configuration.

New Features
  • Added a new stream for pixel events statistics to improve TikTok Ads reporting, providing additional fields for better insights.
  • The application will now request new permissions to read custom CRM objects and schemas, ensuring a more robust integration experience.

Improvements
  • Enhanced the user interface for displaying notifications related to removed collections, replacing transient messages with a clearer modal dialog for better user interaction.
  • Updated the labels for Snowflake account identifiers in forms to provide clearer instructions for users.
  • Improved the validation and error messages for Snowflake destination setup, making it easier for users to understand and rectify issues during configuration.

Bug Fixes
  • Fixed an issue where pipelines connected to DB2 would not transition into continuous sync mode after the initial sync.
  • Corrected a problem causing pagination to fail when using the last-record cursor with DB2 sources, ensuring smooth data extraction.
  • Resolved various UI issues, including tooltip errors and duplicated elements in the settings interface.

Performance Enhancements
  • Improved the speed of Salesforce schema discovery, allowing faster access to large organizations' schemas.
  • Optimized the handling of connection errors for Snowflake integration, enhancing the reliability of connection setups.
We encourage you to explore these updates and leverage the new capabilities to enhance your experience with our platform! 
2 months ago

February 2026: New Oracle & BigQuery Connectors and Enterprise Enhancements

ELT & CDC
We're excited to share the latest improvements made to our platform during February 2026. Our team has been hard at work expanding our connector ecosystem and streamlining workflows for an even better user experience.

Introducing Oracle Database Source Connector
  • Seamlessly integrate Oracle databases into your pipelines with our new LogMiner-powered CDC connector for real-time synchronization. This robust solution features automated type conversions, surrogate key support for tables without primary keys, and secure SSH tunnel compatibility. Backed by comprehensive documentation and enhanced error handling, it ensures a reliable and streamlined setup for even the most complex data configurations.
Introducing BigQuery Source Connector
  • Simplify your BigQuery integrations with our new source connector, featuring high-speed initial syncs via the Storage Read API and intelligent primary key identification. The integration includes enhanced data type handling and an updated incremental strategy that accurately reflects table changes during pipeline restarts. These improvements ensure more effective connection management and consistent data flow across your BigQuery environments.

New Features
  • Streamline warehouse destination management with the new "Auto-match from target client" option, simplifying the process of matching warehouse destinations by type and schema.
  • New support for S3Sink destinations and Avro file formats has been introduced, enabling enhanced data handling and storage options.
  • Surrogate key support has been extended to Oracle sources, allowing for better handling of tables without primary keys.

Improvements
  • Enhanced the layout and styling of the user interface for better user interaction, particularly around primary key selections and help text.
  • Updated the incremental strategy detection for BigQuery to ensure it accurately reflects changes in table settings during pipeline restarts.
  • Various UI improvements were made to clarify account locator formats and enhance help messages for better user guidance.

Bug Fixes
  • Fixed connectivity issues with Snowflake to improve reliability during data replication.
  • Addressed layout inconsistencies in the settings interface for improved usability.

Performance Enhancements
  • Implemented significant performance improvements in data processing, including memory management enhancements to prevent accumulation and speed up query performance.
  • Refined polling mechanisms for continuous data synchronization, ensuring rapid recovery from delays and streamlining overall operations.
We encourage you to explore these new features and improvements, designed to enhance your experience and improve your productivity with our product.
4 months ago

January 2026: SCD Type 2 Tracking and Amazon Marketplace Updates

ELT & CDC
We're excited to share the latest updates from January 2026! Here’s what’s new and improved for our customers.

Introducing History Mode
  • Track historical changes with our new History Mode feature, designed for Redshift and Snowflake. Easily toggle History Mode during table selection to enable SCD Type 2 tracking with dedicated columns for managing data changes. This feature ensures you maintain data integrity and track changes effectively, making data management seamless.
New Features
  • A dynamic start date field is now available for Amazon Marketplace, allowing for more flexible date setups.
  • Added a configuration entry for start date formatting in the tap-square form, enabling customization of date formats for better data handling.
Improvements
  • Improved error detection and management for AWS Marketplace credentials, leading to better error handling when issues arise.
  • Updated UI elements to provide clearer guidance on account privilege checks for Snowflake, ensuring a smoother user experience.
  • Enhanced the handling of source transaction timestamps for MySQL and SQL Server, streamlining data processing.
Bug Fixes
  • Resolved issues with the Snowflake account privilege check, ensuring accurate validation.
  • Fixed credential handling errors for AWS Marketplace, improving reliability.
We encourage you to explore these new capabilities and improvements to enhance your experience with our product!
4 months ago
Loading more updates...