Thursday, March 6, 2025
HomeProductsSSIS ComponentsNew in SSIS Data Flow Components 3.1: Optimized Performance & Expanded API...

New in SSIS Data Flow Components 3.1: Optimized Performance & Expanded API Support

We are thrilled to announce a major release of our SSIS Data Flow Components, powerful tools designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages. This update brings significant enhancements, including improved performance, support for new server versions and APIs, and the addition of new objects and properties to existing components.

Key highlights of SSIS Data Flow Components 3.1

Improved performance

  • Optimized Jira integration: Our SSIS Data Flow Components users can now experience faster data processing and synchronization with Jira, resulting in reduced ETL execution time and enhanced overall efficiency.

Support for new server versions

  • PostgreSQL 17 compatibility: We have integrated support for PostgreSQL 17 to make sure our users have access to its latest features and improved performance.

Expanded API support

  • Support for Shopify API version 2025-01: We have added support for the latest Shopify API version 2025-01, enabling our users to use its new features for more robust e-commerce data management.
  • HubSpot API support improvements:
    • Support for the HubSpot Conversations API: We have added support for the HubSpot Conversations API, enabling interaction with Messages, Threads, Inboxes, Channels, ChannelAccounts, and Actors objects.
    • Support for the HubSpot v3 Lists API: Support for the HubSpot v3 Lists API has been introduced, allowing management of Lists, ListFolders, ListMemberships, and ObjectNameListMemberships objects.

Support for new objects and properties

In this update, we’ve expanded the capabilities of our SSIS Data Flow Components by introducing support for new objects and enhancing existing ones with additional properties.

FreshBooks integration

  • Added support for the OtherIncome object, enabling users to manage additional income streams within their ETL processes.

G Suite integration

  • Introduced support for the CalendarEventExtendedProperties object, allowing for the inclusion of extended properties in calendar events.
  • Added the ExtendedProperties field to the existing CalendarEvents object, providing the ability to store and manage custom metadata associated with calendar events.

Stripe integration

  • Implemented support for AllSubscriptions and AllSubscriptionItems objects, facilitating comprehensive management of subscription data.
  • Introduced new fields to the Invoices object, offering more detailed invoicing information and improved financial data handling.

Zoho Books integration

  • Added support for the ItemBatches object, enabling detailed tracking and management of item batches within the inventory system.
  • Included CreatedDate and UpdatedDate fields to the Journals object, allowing monitoring of creation and modification timestamps for better auditing and record-keeping.

Zoho Inventory integration

  • Introduced support for the ItemBatches object, assisting in managing batch-specific inventory details.
  • Added the Batches field to both the Items and ItemAdjustmentLineItems objects, providing enhanced visibility and control over batch-related information within inventory items and adjustments.

Try our SSIS Data Flow Components today!

Experience the next level of data integration with Devart SSIS Data Flow Components. Download the installation files now to improve your workflows, optimize data processes, and gain deeper insights. Don’t miss out—start your free trial today and transform your data management routine!

For additional questions, please refer to our online documentation.

RELATED ARTICLES

Whitepaper

Social

Topics

Products