What's new in Devart SSIS Data Flow Components 2.1.411

Jul 31, 2023
  • Windows 11 official support
  • Implemented support for SQL Server
  • Implemented support for SQLite
  • In-built encryption support for SQLite databases implemented: AES-128, AES-192, AES-256, Blowfish, CAST-128, RC4, Triple DES
  • Azure Database for MySQL is supported
  • Azure Database for PostgreSQL is supported
  • Added modern encryption algorithms for MySQL and PostgreSQL
  • MariaDB 10.10 is supported
  • PostgreSQL 15 is supported
  • Zoho CRM API v4 is supported
  • New App for Dynamics 365 signed by Microsoft
  • People API for Google Workspace is supported
  • The default browser is used for the Web Login authorization
  • Salesforce Web Services API version 55.0 is supported
  • 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)
  • The new "Query API" connection parameter is added (Zoho CRM)
  • The DealsStageHistory read-only table is added (Zoho CRM)
  • The TicketMetricEvents object is added (Zendesk)
  • New BigCommerce table ProductCustomsInformation was added
  • The PriceListRecords object support is improved (BigCommerce)
  • The Wishlists, WishlistItems, PriceListAssignments, and OrderMetaFields objects are added (BigCommerce)
  • Parent Company - Child Company connection importing - now supported (HubSpot)
  • The new "Login CustomerId" option for using a manager account to access an operating customer account is added for Google Ads
  • SSIS Data Flow Components for Azure SQL Data Warehouse - renamed to SSIS Data Flow Components for Azure Synapse Analytics
  • SSIS Data Flow Components for Microsoft Dynamics CRM - renamed to SSIS Data Flow Components for Microsoft Dynamics 365
  • SSIS Data Flow Components for Exact Target - renamed to SSIS Data Flow Components for Salesforce Marketing Cloud
  • The bug with OrderDetails object filtering by OrderId is fixed (Shopify)
  • The error when reading the Shopify table InventoryLevels is fixed
  • Fixed bug with Orders and DraftOrders tables (Shopify)
  • Fixed bug with "Unexpected SugarType 'autoincrement'" error (SugarCRM)
  • Fixed bug with the error of reading data from Invoices and InvoiceProductDetails tables (Zoho CRM)
  • Fixed bug with SELECT query with WHERE clause (Zendesk)
  • Fixed bug with missing primary key in metadata (Marketo)
  • Fixed bug with Web Login authorization (HubSpot)

New in Devart SSIS Data Flow Components 2.0.16 (Oct 11, 2021)

  • 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

New in Devart SSIS Data Flow Components 1.12.1140 (Feb 20, 2020)

  • 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 in Devart SSIS Data Flow Components 1.10.864 (Jan 10, 2019)

  • Support for Zoho CRM API v2

New in Devart SSIS Data Flow Components 1.7.747 (Aug 10, 2018)

  • Support for Marketo, a well-known cloud lead management and marketing automation solution, is added. Now users can seamlessly integrate Marketo objects with other cloud applications and databases via the SQL Server Integration Services engine.

New in Devart SSIS Data Flow Components 1.5.247 (Aug 5, 2016)

  • Microsoft SQL Server 2016 is supported in SSIS DataFlow components