| • | 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 |
| • | 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 |
| • | 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 |
| • | ActiveCampaign is supported |
| • | DEAR Inventory is supported |
| • | EmailOctopus is supported |
| • | Freshworks CRM is supported |
| • | Google Analytics is supported |
| • | Insightly CRM is supported |
| • | ShipStation is supported |
| • | Twitter Ads is supported |
| • | Zoho Inventory is supported |
| • | Zoho Invoice is supported |
| • | Zoho People is supported |
| • | Salesforce Web Services API version 52.0 is supported |
| • | 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) |
| • | SSH is supported in the Direct mode (Oracle) |
| • | The messages about subscription status in the License Info dialog are supplemented with additional information |
| • | 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) |
| • | 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) |
| • | 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 |
| • | 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 |
| • | 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 FreshBooks API (alpha) is supported |
| • | The behaviour is changed: now we force using TLS 1.2 for Salesforce Marketing Cloud |
| • | 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 |
| • | 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) |
| • | 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) |
|
What's New in Devart SSIS Data Flow Components 3.1