Devart SSIS Universal Bundle V5.0.0

Released: Jun 25, 2026

Atualizações na V5.0.0

Recursos

ActiveCampaign

  • Added support for custom objects.
  • Added support for custom fields in the Accounts, Contacts, and Deals objects.
  • Added the new EmailActivities object.
  • Added the new ListId field in the Contacts object. You can use this field in filters to retrieve contacts from a specific list.
  • Improved support for the Contacts object: native filtering is used for the >, >=, <, and <= conditions on the CreatedDate and UpdatedDate fields.
  • Improved performance for the ContactLists object: data is now loaded to and from this object much faster.

Amazon Redshift

  • Added support for new Amazon S3 Regions.

BigCommerce

  • Added the new CustomerMetafields object.
  • Added the new ProductImageContents object for working with binary content of product images in BigCommerce.

FreshBooks

  • Added new objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, and JournalEntriesByAccountReport.
  • Added new report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, and TrialBalanceReport.

Freshdesk

  • Added support for INSERT, UPDATE, and DELETE DML operations for the TicketFields object.

HubSpot

  • Added support for HubSpot reports.
  • Added the Sensitive Data connection string parameter for accessing Sensitive Data fields.
  • Added new objects: Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions.

Jira

  • Added support for additional Jira objects.
  • Added support for custom objects for issues.
  • Added the Issues Custom Fields Merge Behavior option specifying how Jira's custom fields from different projects are combined into one Issues object.

Mailchimp

  • Added new objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, Stores.

Marketo

  • Improved support for the Leads object, which now supports native filtering by the CreatedAt field in Bulk Extract mode.

MySQL

  • Added support for SingleStore (formerly MemSQL).

NetSuite

  • Added support for NetSuite API v2.
  • Added support for the NetSuite 2024.2 release of API v1.
  • Added support for OAuth login by NetSuite Connection Manager.

Oracle

  • Added support for the JSON data type in Oracle Database 21c, 23ai, and 26ai.
  • Added support for the BOOLEAN data type in Oracle Database 23ai and 26ai.

PostgreSQL

  • Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone.

Pipedrive

  • Added the Projects object for Pipedrive API v1.
  • Added the following objects for the Pipedrive API v2: Activities, DealFollowers, OrganizationFollowers, Organizations, PersonFollowers, Persons, ProductFollowers, and UserFollowers.
  • Added the following fields to the Data object: ActiveFlag, AddTime, AssignedToUserId, BusyFlag, CalendarSyncIncludeContext, ChangeSource, ChangeSourceAgent, CompanyId, ConferenceMeetingClient, ConferenceMeetingId, ConferenceMeetingUrl, DealDropboxBcc, Done, DueDate, DueTime, Duration, FieldKey, GoogleCalendarEtag, GoogleCalendarEventId, GoogleCalendarId, IsBulkUpdateFlag, ItemId, LastNotificationTime, LastNotificationUserId, LeadId, Location, LocationLocality, LocationRoute, LocationStreetNumber, LocationSubpremise, LocationSublocality, LogTime, MarkedAsDoneTime, NewValue, Note, NotificationLanguageId, OldValue, OrganizationId, PersonDropboxBcc, PersonId, ProjectId, PublicDescription, RecMasterActivityId, RecRule, RecRuleExtension, ReferenceId, ReferenceType, Series, SourceTimezone, Subject, Type, UpdateTime, and UserId.

QuickBooks

  • Added the TaxExemptionReasonId field to the Customer object.
  • Added new 50 QuickBooks report objects.

Salesforce

  • Added support for version 64.0 of the Salesforce Web Services API.
  • Added support for the Server-to-Server authentication.
  • Added the Preserve Names connection string parameter to preserve the original names of custom objects and fields, including the __c suffix.

Shipstation

  • Added support for ShipStation API v2.

Snowflake

  • Added support for new Amazon S3 Regions.

Stripe

  • Added the BillingMeters object.
  • Added the read-only SubscriptionDiscounts and AllSubscriptionDiscounts objects to provide extended discount information for records in the Subscriptions and AllSubscriptions objects.
  • Added support for Payment Plans in the Invoices object.
  • Added fields from the new API to the Subscriptions, SubscriptionItems, AllSubscriptions, and AllSubscriptionItems objects.
  • Added support for the UPDATE operation for the Coupons object.
  • Added support for INSERT, UPDATE, and DELETE DML operations for the WebhookEndpoints object.
  • Added support for selecting records by Id for the ApplicationFees and Reviews objects.
  • Removed support for the deprecated Orders, Returns, SKUs, and UsageRecords objects, which are no longer available. Use the BillingMeters object instead of UsageRecords, and use the Products and Prices objects instead of SKUs and Orders.
  • Changed the metadata behavior for the Subscriptions, AllSubscriptions, SubscriptionItems, and AllSubscriptionItems objects.

SugarCRM

  • Added the RowsAndColumns, Summation, and SummationWithDetails reports.

SurveyMonkey

  • Changed the behavior of the primary key, which has been extended for the CollectorRecipients object to ensure uniqueness across all records. The CollectorRecipients primary key includes the Id, CollectorId, and MessageId fields.
  • Changed the behavior of the primary keys, which have been extended for the SurveyResponses object. Now it includes the Id, CollectorId, and SurveyId fields.
  • Removed the primary key from the SurveyResponsesAnswers object, because the combination of fields isn't unique, and Null values aren't allowed.

Zendesk

  • Added the SectionId and AuthorId fields to the Article object.
  • Added the CategoryId field to the Section object.

Zoho CRM

  • Added support for Zoho CRM API v8.
  • Changed the behavior: the API Version connection option now has only two supported elements - Preferred (currently API v8, but subject to change) and Deprecated (currently API v2).
  • Added the BulkRead option to the connection string. It enables the Bulk Read API of Zoho CRM for querying large data volumes.
  • Added support for Canada, Japan, Saudi Arabia, and UK domains in the Connection Editor for Zoho CRM connections.

Zoho Books

  • Added the SalesReceipts object.
  • Added support for nested objects within the LineItems field of the Bills object.
  • Added support for the Saudi Arabia domain in the Connection Editor for Zoho Books connections.
  • Improved selection of BankTransactions records for all available statuses.
  • Improved filtering records by the Status field.
  • Improved support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects.

Zoho Inventory

  • Added the ItemDocuments object.
  • Added the Use Custom Fields connection string parameter to start working with custom fields.

Zoho People

  • Added the TimesheetDetails object.
  • Added the Suppress Extended Requests connection string parameter to save API calls when querying the Timesheets object.

Correções

  • Fixed multiple issues related to API support for cloud data sources.
  • Fixed an issue with displaying Unicode characters during installation.

MySQL

  • Fixed an issue that caused the 'Bad handshake' error when opening a connection.

Oracle

  • Fixed an issue with XMLTYPE handling in Direct mode when Unicode=False.

PostgreSQL

  • Fixed an issue that caused the 'Authentication failed in ssl mode' error when opening a connection.
  • Fixed an issue that caused the 'Unsupported frontend protocol' error when connecting to PostgreSQL 8.0.
  • Fixed an issue with saving MONEY data type values.
  • Fixed an issue with negative MONEY values displayed in accounting format when using protocol 2.
  • Fixed an issue with trailing zeros in the fractional part of NUMERIC data type.
  • Fixed incorrect handling of TIMESTAMPTZ values when the Use Session Timezone connection string parameter was set to True.

QuickBooks

  • Fixed an issue that caused the 'Required param missing' error when performing DELETE operations on the TimeActivity table.

SQLite

  • Fixed an issue with using the URI format in the Data Source connection string parameter.