The latest release of Devart SSIS Data Flow Components expands support for cloud applications and databases with new objects and fields, updated API and metadata support, and improved authentication and data access capabilities across multiple connectors.
What’s new
The release delivers updates across a broad range of SSIS Data Flow Components, covering cloud services, SaaS applications, and major database platforms. The changes help keep integrations aligned with evolving data models, APIs, and connectivity requirements.
SSIS Data Flow Components for HubSpot
The release significantly extends HubSpot integration capabilities. SSIS Data Flow Components now support OAuth v3 API endpoints, custom unique identifier properties, and labeled associations, which are represented as objects with the _labels suffix.
The update also adds support for HubSpot reports and Sensitive Data fields through the new Sensitive Data connection string parameter. New supported objects include Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions.
SSIS Data Flow Components for Stripe
SSIS Data Flow Components now support Stripe API version 2026-01-28.clover and the new BillingMeters object, which replaces the deprecated UsageRecords object.
The release also updates metadata for a wide range of Stripe objects and expands data operations. Native filtering is now available for selected fields in CreditNotes and Readers, while nested objects are supported in several CreditNotes and Invoices fields. The update also adds UPDATE support for Coupons and INSERT, UPDATE, and DELETE operations for WebhookEndpoints.
In addition, several PaymentIntents fields now use the Int64 data type instead of Int32 to accommodate larger values. Deprecated Stripe objects and columns have been removed to keep the connector aligned with the current Stripe API.
SSIS Data Flow Components for Google BigQuery
Support for ingestion-time partitioned tables has been expanded with the _PARTITIONTIME pseudocolumn. Daily ingestion-time partitioned tables also support _PARTITIONDATE, which provides the DATE representation of _PARTITIONTIME.
SSIS Data Flow Components for Asana
The Asana connector now supports the PortfolioStatusUpdates object. New completion-related fields have also been added to the Tasks, CustomFields, and Projects objects, providing access to additional information about completed resources.
SSIS Data Flow Components for FreshBooks
FreshBooks integration now includes the TeamMember, TeamMemberRate, and ProjectTeamMemberRate objects, expanding access to team and project rate data.
SSIS Data Flow Components for NetSuite
The NetSuite connector adds support for the TransactionAccountingLines object in NetSuite API v2.
SSIS Data Flow Components for QuickBooks Online
The Item object now includes the PrefVendorRefId and PrefVendorRefName fields, providing access to preferred vendor information.
SSIS Data Flow Components for BigCommerce
The release corrects the maximum-length metadata for the CartId field in the CartCustomItems, CartGiftCertificateItems, CartLineItems, and CartMetafields objects.
SSIS Data Flow Components for Zoho CRM
Support for Zoho CRM API v2 has been expanded with the IMAGEUPLOAD, LAYOUT, LINETAX, MODULE, MULTIUSERLOOKUP, ROLLUP_SUMMARY, and TERRITORIES native data types.
SSIS Data Flow Components for Oracle, MySQL, and PostgreSQL
SSH connectivity for Oracle, MySQL, and PostgreSQL has been updated with support for PuTTY PPK3 private keys.
For PostgreSQL connections, the release also adds support for the SCRAM-SHA-256-PLUS authentication mechanism, providing compatibility with PostgreSQL environments that use channel-binding authentication.
With these updates, Devart SSIS Data Flow Components provide broader access to current APIs and data models while improving compatibility with modern authentication and security requirements.
Availability
The new version of Devart SSIS Data Flow Components is available for download. Existing customers with an active subscription can upgrade to the latest version to access the new features and improvements.
For more information about Devart Excel Add-ins and the supported data sources, visit our documentation.
