What's New

What's New in Devart SSIS Data Flow Components 3.0

•	Added support for SQL Server Integration Services 2022 (SSIS 2022)

•	Added support for SurveyMonkey

•	Added support for Shopify

•	Added support for Zendesk

•	Added support for SQL Server 2022

•	Added support for Oracle 23c

•	Added support for MariaDB 11

•	Added support for PostgreSQL 16

•	Added support for Adobe Commerce 2.4

•	Added support for NetSuite 2023.2

•	Added support for Salesforce Web Services API version 59.0

•	Added support for Shopify API version 2024-04

•	Introduced the Initialization Command and Run Once Command options to the SSIS Connection Manager

•	Supported connection to servers with enabled Security Banners in Direct mode (Oracle)

•	Added support for the Private App authorization (HubSpot)

•	Added support for the Portfolios object (Asana)

•	Added the CostRate field to the TimeActivity object in QuickBooks Online

•	Added the Phone field to the Customers object in Shopify

•	Stripe is supportedImplemented support for Zendesk Custom Lookup Fields

•	Optimized filtering and caching for V3 Product-related tables in BigCommerce

•	Default protocol set to TLS 1.2 (MailChimp)

•	Renamed SSIS Data Flow Components for DEAR Inventory to SSIS Data Flow Components for Cin7 Core

•	Renamed SSIS Data Flow Components for Magento to SSIS Data Flow Components for Adobe Commerce

•	Renamed SSIS Data Flow Components for QuickBooks to SSIS Data Flow Components for QuickBooks Online

What's New in Devart SSIS Data Flow Components 2.1

•	Windows 11 official support

•	Zoho CRM API v4 is supported

•	Implemented support for SQLite

•	Implemented support for SQL Server

•	Implemented support for PostgreSQL 15

•	Azure Database for MySQL is supported

•	Azure Database for PostgreSQL is supported

•	New App for Dynamics 365 signed by Microsoft

•	People API for Google Workspace is supported

•	The TicketMetricEvents object is added Zendesk

•	Salesforce Web Services API version 55.0 is supported

•	TLS 1.2 protocol is now used by default for MailChimp

•	The DealsStageHistory read-only table is added Zoho CRM

•	New BigCommerce table ProductCustomsInformation was added

•	The DealsStageHistory read only table is added in Zoho CRM

•	Added modern encryption algorithms for MySQL and PostgreSQL

•	The default browser is used for the Web Login authorization

•	The PriceListRecords object support is improved BigCommerce

•	The new "Query API" connection parameter is added for Zoho CRM

•	The default browser is now used for the Web Login authorization

•	Parent Company - Child Company connection importing - now supported in HubSpot

•	The Wishlists, WishlistItems, PriceListAssignments, and OrderMetaFields objects are added for BigCommerce

•	SSIS Data Flow Components for Exact Target - renamed to SSIS Data Flow Components for Salesforce Marketing Cloud

•	SSIS Data Flow Components for Microsoft Dynamics 365 - renamed to SSIS Data Flow Components for Microsoft Dynamics 365

•	SSIS Data Flow Components for Azure SQL Data Warehouse - renamed to SSIS Data Flow Components for Azure Synapse Analytics

•	In-built encryption support for SQLite databases implemented: AES-128, AES-192, AES-256, Blowfish, CAST-128, RC4, Triple DES

•	The new "Login CustomerId" option for using a manager account to access an operating customer account is added for Google Ads

•	COQL Query for Zoho CRM is supported to speedup the process of query execution. COQL is available for the following objects: Accounts, Contacts, Deals, Campaigns, Tasks, Cases, Events, Calls, Solutions, Products, Vendors, PriceBooks, Quotes, SalesOrders, PurchaseOrders, Invoices Zoho CRM

What's New in Devart SSIS Data Flow Components 2.0

•	ActiveCampaign is supported

•	Asana is supported

•	DEAR Inventory is supported

•	EmailOctopus is supported

•	Freshdesk is supported

•	Freshworks CRM is supported

•	Google Ads is supported

•	Google Analytics is supported

•	HubSpot is supported

•	Insightly CRM is supported

•	Jira is supported

•	NetSuite is supported

•	Pipedrive is supported

•	Podio is supported

•	SendPulse is supported

•	ShipStation is supported

•	Slack is supported

•	Snowflake is supported

•	Streak is supported

•	Stripe is supported

•	Twitter Ads is supported

•	WordPress is supported

•	Zoho Books is supported

•	Zoho Desk is supported

•	Zoho Inventory is supported

•	Zoho Invoice is supported

•	Zoho People is supported

•	Salesforce Web Services API version 52.0 is supported

What's New in Devart SSIS Data Flow Components 1.15

•	PostgreSQL 13 is supported

•	SQL validation in Devart DB2 Source Editor is improved: Int and Double parameters are now quoted to avoid "syntax error" hover text

•	Additional mode of parameter substitution in the query in the SSIS Data Flow Source component: substitution as is, without escaping (MySQL, Oracle, PostgreSQL, DB2)

What's New in Devart SSIS Data Flow Components 1.14

•	SSH is supported in the Direct mode (Oracle)

•	The messages about subscription status in the License Info dialog are supplemented with additional information

What's New in Devart SSIS Data Flow Components 1.13

•	Dynamics OAuth is supported (Dynamics 365)

•	The MultiSelect Option Set columns are supported (Dynamics 365)

•	The composite data types are supported (PostgreSQL)

•	The OrderItems field is added to the SalesOrder table in Adobe Commerce API v2 provider (Adobe Commerce)

•	The INSERT operation is supported for the SalesOrder table in Adobe Commerce API v2 provider (Adobe Commerce)

•	The Opened table is added to Mailchimp API v3 provider (Mailchimp)

•	The behaviour is changed: the TIMESTAMP column is mapped to System.DateTimeOffset instead of System.DateTime (Google BigQuery)

•	The behaviour is changed: web login now uses the operating system default browser for logging in to BigQuery (Google BigQuery)

What's New in Devart SSIS Data Flow Components 1.12

•	SQL Server Integration Services 2019 (SSIS 2019) is supported

•	The SubscriberStatusEvent table is supported (Salesforce Marketing Cloud)

•	OAuth 2 is supported by QuickBooks Connection Manager

•	Filtering lookup fields is supported (Zoho CRM)

What's New in Devart SSIS Data Flow Components 1.11

•	PostgreSQL 12 is supported

•	The ShippingAddress* fields are added to the SalesOrder table in Magento V2 (Magento)

•	The new authentication type ServerToServer is implemented (Salesforce Marketing Cloud)

•	The behaviour is changed: now we force using TLS 1.2 for SugarCRM source

What's New in Devart SSIS Data Flow Components 1.10

•	PostgreSQL 11 is supported

•	BigCommerce API version 3 is supported (BigCommerce)

•	OAuth 2 is added for ExactTarget connections

•	The JSON and JSONB data types are supported (PostgreSQL)

•	The possibility to set object name via user variable in destination components is implemented

•	The new Local SQL Engine connection string parameter is added for turning off local SQL processing (cloud sources)

•	The parsing error message returned by Devart ExactTarget Destination is improved (Salesforce Marketing Cloud)

•	The error message when a value of one type cannot be converted to another type in the Oracle Destination component with the BulkInsert operation is improved

•	The behaviour is changed: now we force using TLS 1.2 for Zoho CRM

•	The behaviour is changed: now we force using TLS 1.2 for Magento

•	The behaviour is changed: web login now uses the operating system default browser for logging in to Mailchimp

•	The Magento connection editor is improved: now you can switch Service Version on the main screen of the connection editor

•	The Mailchimp connection editor is improved: now you can switch API Version on the main screen of the connection editor

•	Multi-targeting in Devart components is supported: storing assembly name and its version in the name of Devart component in package XML (*.dtsx) is no longer required

What's New in Devart SSIS Data Flow Components 1.9

•	Azure Data Factory V2 Integration Runtime (ADFv2 IR) is supported

•	Zoho CRM API v2 is supported

•	The "Default Cloud Storage Bucket" parameter is added to the Google BigQuery connection

What's New in Devart SSIS Data Flow Components 1.8

•	New FreshBooks API (alpha) is supported

•	The behaviour is changed: now we force using TLS 1.2 for Salesforce Marketing Cloud

What's New in Devart SSIS Data Flow Components 1.7

•	Marketo is supported

•	The ConsentLookup type is supported for Zoho CRM

•	The Bulk API functionality is implemented in the Devart Salesforce Source component via its BulkQuery property (Salesforce)

•	The OptimizeQuery property is added to the Devart Salesforce Source component to use optimizations for retrieving large amount of data (Salesforce)

•	The performance of the SSIS Lookup component is improved due to using one IN clause instead of many OR clauses (MySQL, PostgreSQL)

•	The behaviour is changed: now we force using TLS 1.2 for FreshBooks and QuickBooks

What's New in Devart SSIS Data Flow Components 1.6

•	SQL Server Data Tools (SSDT) in Visual Studio 2017 is supported

•	Azure SQL Data Warehouse is supported

•	Google BigQuery is supported

•	Amazon Redshift is supported

•	The UseBulkApi parameter, specifying whether to use Bulk API or SOAP API, is added to the Devart Salesforce Destination component (Salesforce)

•	The behaviour is changed: now Column Mappings are not reset after Refresh in the Devart Salesforce Destination editor (Salesforce)

•	The behaviour is changed: now the Devart Sugar Destination component uses Bulk API (SugarCRM)

What's New in Devart SSIS Data Flow Components 1.5

•	Microsoft SQL Server 2016 is supported in SSIS DataFlow components

•	The Conditions, PriceAdjuster_Type, PriceAdjuster_Value, WeightAdjuster_Type and WeightAdjuster_Value fields are added to the ProductRules entity (BigCommerce)

•	The "Include Deleted Records" option is added to Devart Salesforce Source Editor (Salesforce)

•	The new Assignment Rule Id property is implemented in Devart Salesforce Destination (Salesforce)

•	The "Use Assignment Rules" connection string parameter for using default Assignment Rule is added to the Salesforce connection (Salesforce)

•	The ParallelBatchProcessing option is added to the Devart Salesforce Destination component for specifying the mode used for upload: Parallel or Serial (Salesforce)

•	The SSIS Data Flow Components version info is added to the License Info window

•	A not sensitive Host parameter is added to SSIS DevartSalesforce connection manager (Salesforce)

•	The behaviour of the product installer is changed: now it checks whether another version of the product is installed

•	The behaviour is changed: the Password and SecurityToken parameters are now sensitive (Salesforce)