SSIS Data Flow Components 5.0: New Features, API Updates, and Expanded Platform Support

We are thrilled to announce the release of SSIS Data Flow Components version 5.0. This release includes updates across database connectors, cloud services, and APIs. It adds new objects, improves data type support, introduces new authentication options, and expands API coverage for more than 20 platforms.

Key highlights of SSIS Data Flow Components 5.0

ActiveCampaign: Deeper integration
Amazon Redshift & Snowflake: New Amazon S3 Regions
BigCommerce: New objects
FreshBooks: Major expansion
Freshdesk: DML improvements
HubSpot: New objects and Sensitive Data support
Jira: Custom objects and fields
Mailchimp: New e-commerce objects
Marketo: Bulk Extract improvements
NetSuite: New API versions and OAuth
Oracle: Expanded data type support
Pipedrive: API v2 and new objects
PostgreSQL: Improved date/time handling
QuickBooks Online: New reports
Salesforce: API v64.0 and server-to-server authentication
ShipStation: API v2
Stripe: New billing objects and DML support
SugarCRM: New reports
SurveyMonkey: Updated object metadata
Zendesk: New fields
Zoho Books: New objects and nested support
Zoho CRM: API v8 and Bulk Read API
Zoho Inventory: Custom fields
Zoho People: New object

ActiveCampaign: Deeper integration

SSIS Data Flow Components for ActiveCampaign receive one of the most comprehensive updates in this release:

• Custom objects are now fully supported, allowing you to read and write data beyond the standard ActiveCampaign schema.
• Custom fields for the Accounts, Contacts, and Deals objects are now available.
• The new EmailActivities object is added for tracking email interaction data.
• A new ListId field in the Contacts object enables filtering by list.
• Performance for the ContactLists object has been improved: data is now loaded both from and to this object much faster.
• Native filtering is now used for >, >=, <, and <= conditions on the CreatedDate and UpdatedDate fields of the Contacts object, improving query efficiency.

Amazon Redshift and Snowflake: New Amazon S3 Regions

Both SSIS Data Flow Components for Redshift and SSIS Data Flow Components for Snowflake now support the latest Amazon S3 Regions, ensuring compatibility with new AWS infrastructure and supporting data residency requirements.

BigCommerce: New objects

SSIS Data Flow Components for BigCommerce add two new objects to expand your e-commerce data integration capabilities:

• CustomerMetafields – provides access to custom metadata associated with customers.
• ProductImageContents – enables working with the binary content of product images in BigCommerce.

FreshBooks: Major expansion

SSIS Data Flow Components for FreshBooks receive an expanded set of accounting and reporting objects:

• New data objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, and JournalEntriesByAccountReport.

• New report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, and TrialBalanceReport.

The new objects extend support for accounting data integration scenarios.

Freshdesk: DML improvements

SSIS Data Flow Components for Freshdesk now support INSERT, UPDATE, and DELETE DML operations for the TicketFields object, enabling full programmatic management of ticket field definitions, not just reading them.

HubSpot: New objects and Sensitive Data support

SSIS Data Flow Components for HubSpot gain important new capabilities in this release:

• HubSpot reports are now supported, making it possible to extract pre-built analytics data directly through SSIS.
• A new Sensitive Data connection string parameter enables access to protected fields.
• The following new CRM objects are added: Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions, expanding the range of HubSpot entities you can work with in your integration pipelines.

Jira: Custom objects and fields

SSIS Data Flow Components for Jira now offer:

• Support for additional Jira objects, broadening data access beyond the core issue-tracking entities.
• Custom objects for Issues, enabling you to work with project-specific schemas.
• A new Issues Custom Fields Merge Behavior option that controls how custom fields from different Jira projects are combined when loading Issues data, thereby giving you precise control over cross-project data consolidation.

Mailchimp: New e-commerce objects

SSIS Data Flow Components for Mailchimp add a full suite of e-commerce objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, and Stores. These additions make it straightforward to synchronize your Mailchimp store data with your data warehouse or CRM system.

Marketo: Bulk Extract improvements

SSIS Data Flow Components for Marketo now support native filtering by the CreatedAt field in Bulk Extract mode for the Leads object to enable efficient incremental extracts of large Marketo lead datasets.

NetSuite: New API versions and OAuth

SSIS Data Flow Components for NetSuite are updated with:

• Support for NetSuite API v2, the latest generation of the NetSuite REST-based API.
• Support for the NetSuite 2024.2 release of API v1 for continued legacy compatibility.
• OAuth login support via the NetSuite Connection Manager. This authentication method is more secure and standardized, and it eliminates the need to store credentials directly.

Oracle: Expanded data type support

SSIS Data Flow Components for Oracle now support the JSON data type for Oracle Database 21c, 23ai, and 26ai, enabling integration of semi-structured JSON data in your ETL pipelines. In addition, the BOOLEAN data type is now supported for Oracle Database 23ai and 26ai, simplifying data mapping for applications that rely on native boolean columns.

Pipedrive: API v2 and new objects

SSIS Data Flow Components for Pipedrive add new coverage:

• The Projects object is added for Pipedrive API v1.
• For Pipedrive API v2, the following new objects are introduced: Activities, DealFollowers, OrganizationFollowers, Organizations, PersonFollowers, Persons, ProductFollowers, and UserFollowers.
• New fields are added to the Data object to expose additional metadata.

PostgreSQL: Improved date/time handling

SSIS Data Flow Components for PostgreSQL introduce the Use Session Timezone connection string parameter. This new option gives you control over how PostgreSQL date/time values are interpreted and converted during data transfer by applying the active session time zone instead of a fixed offset.

QuickBooks Online: New reports

SSIS Data Flow Components for QuickBooks Online add 50 new report objects, expanding the financial reporting data available for extraction from QuickBooks. Additionally, a new TaxExemptionReasonId field is added to the Customer object.

Salesforce: API v64.0 and server-to-server authentication

SSIS Data Flow Components for Salesforce now support:

• Salesforce Web Services API version 64.0, ensuring compatibility with the latest Salesforce platform features and schema changes.
• Server-to-server authentication, a more secure OAuth flow that enables non-interactive, machine-to-machine integrations that don’t require user login prompts.

ShipStation: API v2

SSIS Data Flow Components for ShipStation now support ShipStation API v2, aligning with the latest API version and ensuring continued, reliable access to order management and shipping data.

Stripe: New billing objects and DML support

SSIS Data Flow Components for Stripe receive a broad set of improvements:

• A new BillingMeters object is added to replace the deprecated UsageRecords.
• New read-only objects SubscriptionDiscounts and AllSubscriptionDiscounts expose extended discount information linked to subscriptions.
• Support for payment plans is added for the Invoices object.
• UPDATE operation support is added for the Coupons object.
• INSERT, UPDATE, and DELETE operations are now supported for the WebhookEndpoints object.
• Records can now be selected by Id for the ApplicationFees and Reviews objects.
• The following deprecated objects have been removed as they are no longer available in the Stripe API: Orders, Returns, SKUs, and UsageRecords. Use BillingMeters instead of UsageRecords; use Products and Prices instead of SKUs and Orders.
• Metadata has been updated for the Subscriptions, AllSubscriptions, SubscriptionItems, and AllSubscriptionItems objects to reflect the current Stripe API schema.

SugarCRM: New reports

SSIS Data Flow Components for SugarCRM now support three report types: RowsAndColumns, Summation, and SummationWithDetails. These reports enable extraction of pre-aggregated and summary-level data from SugarCRM without additional post-processing steps.

SurveyMonkey: Updated object metadata

SSIS Data Flow Components for SurveyMonkey include several important behavioral updates to ensure data uniqueness and reliability:

• The primary key for the CollectorRecipients object is extended to include Id, CollectorId, and MessageId.
• The primary key for the SurveyResponses object is extended to include Id, CollectorId, and SurveyId.
• The primary key has been removed from the SurveyResponsesAnswers object because SurveyResponsesAnswers doesn’t have a unique combination of non-null fields.

Zendesk: New fields

SSIS Data Flow Components for Zendesk add new fields to improve knowledge base data integration:

• SectionId and AuthorId are added to the Article object.
• CategoryId is added to the Section object.

These fields enable more precise hierarchical navigation and authorship tracking within Zendesk Guide content.

Zoho Books: New objects and nested support

SSIS Data Flow Components for Zoho Books add and improve several integration points:

• The new SalesReceipts object is added.
• Nested objects in the LineItems field of the Bills object are now supported.
• Handling of CustomFields and CustomFieldHash fields is improved for SalesOrders, Bills, CreditNotes, and CustomerPayments objects.
• Selection of BankTransactions records now covers all available statuses.
• Filtering records by the Status field is improved for more reliable and consistent results.

Zoho CRM: API v8 and Bulk Read API

SSIS Data Flow Components for Zoho CRM now support Zoho CRM API v8, the latest version of the Zoho CRM platform API. Additionally, a new BulkRead connection string parameter enables the Zoho CRM Bulk Read API for efficiently querying large data volumes.

Zoho Inventory: Custom fields

SSIS Data Flow Components for Zoho Inventory introduce:

• A new ItemDocuments object for managing documents associated with inventory items.
• A new Use Custom Fields connection string parameter that enables working with custom fields in Zoho Inventory.

Zoho People: New object

SSIS Data Flow Components for Zoho People add:

• A new TimesheetDetails object for detailed timesheet data extraction.
• A new Suppress Extended Requests connection string parameter that reduces the number of API calls made when querying the Timesheets object.

Get started with SSIS Data Flow Components 5.0

Version 5.0 is available now. If you are an existing customer, upgrade through your Devart account. If you are new to Devart, download a free 30-day trial.