March 2026: New Connectors, Editor Upgrades & More
ETL & Reverse ETL
March's release cycle focused on expanding connector coverage, deepening the Expression Editor's capabilities, and closing reliability gaps across the pipeline.
Introducing the Reworked Expression Editor
The Expression Editor has been redesigned to make building expressions faster - new copy and insert buttons let you add any expression directly, no manual typing required. Clicking any function now opens a detail panel on the right showing its full description, parameters, and usage - no more hunting through documentation. A parameter legend below the syntax line makes it clear at a glance which inputs are required and which are optional, and related functions are now surfaced contextually to help users discover the right tool for the job. We also added a dedicated DateTimeConverter, removing the need to manually locate, input, and convert datetime fields when working with date expressions. A built-in cURL import rounds out the update, letting users utilize pre-build Postman API calls without leaving the editor.
Introducing NetSuite REST API Support
The ETL platform now supports NetSuite via its REST API using SuiteQL, giving users a modern, query-based alternative to the JDBC connector for accessing NetSuite data. This month also includes a JDBC driver upgrade from version 8.10.136.0 to 8.10.184.0, improving compatibility and stability for existing NetSuite JDBC connections.
Introducing the Universal OAuth Connector
The Universal OAuth Connector now supports HTTP Basic Authentication as part of the OAuth 2.0 flow, enabling connections to providers that require this handshake. Automatic token refresh has also been implemented.
Introducing the Native Shopify Source
The native Shopify source component now supports both full load and incremental loading, with pre-defined objects aligned to the approach used by the HubSpot connector. The underlying OAuth connector issue that previously caused Shopify authentication failures has been resolved as part of this work.
New Connectors
- Gmail Connector: Users can now ingest CSV and Excel attachments directly from a Gmail inbox using service account authentication, with support for both full and incremental load modes and automatic metadata extraction.
- Google Sheets Connector: A new bidirectional connector lets users read from and write to Google Sheets using service account authentication, supporting both source and destination use cases within the same job.
- Constant Contact Connector: Users can now connect to Constant Contact via OAuth 2.0, fetch contact objects and email campaigns, and use dynamic field discovery during schema import.
- SharePoint as a Destination Component: SharePoint can now be used as a write destination within the package designer, in addition to its existing role as a source.
New Features
- Schedule Webhook Notifications: Users can now receive service hook notifications for schedule lifecycle events - creation, activation, and deactivation - keeping external systems in sync with job schedules.
- Import cURL from Postman: The REST API source component now includes an import cURL button, allowing users to paste a cURL command directly from Postman to pre-populate the request configuration.
- Save and Validate Option: A Save and Validate option has been added to the Save button dropdown in the Package Designer, allowing users to trigger validation without leaving the editing context.
- File Storage Header and Data Row Customization: Users can now specify which row contains headers and which row data begins during CSV and Excel file imports, handling files with non-standard layouts.
- Previewer Error Detail: The Previewer now displays specific error log output instead of a generic error message, making it easier to diagnose preview failures.
Improvements
- Schema preview in source components now supports up to 800 fields, up from 500, giving users a more complete view of wide tables.
- Search inputs have been added to the connections dropdown and the components list in the package designer, reducing navigation time when working with large connector sets.
- The SharePoint destination editor consolidates the document library and folder path into a single field, with clearer labeling and alignment with the source component layout.
- The REST API source component now auto-detects and suggests the correct JSONPath after schema load, reducing manual configuration for nested JSON responses.
- The SFTP connector now supports Ed25519 key pairs for public key authentication and has been upgraded to handle modern OpenSSH servers that require ETM (Encrypt-then-MAC) algorithms.
- The schema importer timeout has been increased from 30 to 60 seconds, reducing failures on slower or larger schemas.
Bug Fixes
- Fixed multiple expression editor issues: backdrop clicks closing the underlying modal, the popup reappearing after background dismissal, flickering tooltips, unreliable autocomplete, and incorrect display on smaller screens.
- Fixed a bug where the Curl() function was not routing through proxy servers, causing preview failures for API endpoints with IP whitelisting.
- Resolved UTF-8 encoding corruption when ingesting Korean, Chinese, or Japanese characters via the REST API source and the Curl() UDF.
- Fixed HubSpot source issues where number fields were incorrectly typed as Float instead of Double, and the incremental load date variable was set incorrectly.
- Fixed a Salesforce source issue where previewing objects with hundreds of fields produced HTTP errors.
- Fixed an issue where global variables were not applied correctly during component preview, and resolved a package validation failure for File Storage sources using Parquet files.
- Fixed an issue where error logs in Job Details were truncated, and resolved an OAuth popup that remained open after authentication completed.
Performance Enhancements
- Salesforce schema fetching now uses concurrent API calls, reducing wait times when loading objects with large field sets.
- Database queries underlying dataflow exports have been optimized, resolving timeout errors for large packages.
Thanks for using the product - keep the feedback coming and let us know what you'd like to see next!
2 months ago