Devart SSIS DataFlow Components History

This page lists the functionality added in each version of SSIS DataFlow Components. To view the full changelog including bug fixes, consult the Devart SSIS DataFlow Components revision history.

New features in Devart SSIS DataFlow Components 1.14

  • SSH is supported in the Direct mode (Oracle)

New features in Devart SSIS DataFlow Components 1.13

  • Dynamics OAuth is supported (Dynamics CRM)
  • The MultiSelect Option Set columns are supported (Dynamics CRM)
  • The composite data types are supported (PostgreSQL)
  • The OrderItems field is added to the SalesOrder table in Magento API v2 provider (Magento)
  • The INSERT operation is supported for the SalesOrder table in Magento API v2 provider (Magento)
  • 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)

New features in Devart SSIS DataFlow 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)

New features in Devart SSIS DataFlow 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

New features in Devart SSIS DataFlow Components 1.10

  • PostgreSQL 11 is supported
  • OAuth 2 is added for ExactTarget connections
  • The JSON and JSONB data types are supported (PostgreSQL)
  • 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
  • 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 (Salesforce Marketing Cloud)
  • 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

New features in Devart SSIS DataFlow 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

New features in Devart SSIS DataFlow Components 1.8

  • New FreshBooks API (alpha) is supported
  • The behaviour is changed: now we force using TLS 1.2 for Salesforce Marketing Cloud source

New features in Devart SSIS DataFlow Components 1.7

  • Marketo is supported
  • The ConsentLookup type is supported for the Zoho CRM source
  • 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 sources

New features in Devart SSIS DataFlow 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)

New features in Devart SSIS DataFlow 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)
  • Magento API v2 is supported (Magento)
  • 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 installation wizard is improved: now it detects the previous version and allows removing it automatically
  • The behaviour is changed: the Password and SecurityToken parameters are now sensitive (Salesforce)

21-Sep-2015 New features in Devart SSIS DataFlow Components 1.0

  • The first release of Devart SSIS DataFlow Components