Devart is glad to announce the release of SSIS Data Flow Components 1.13 with support of OAuth 2.0 authentication for Dynamics CRM and a number of improvements for other cloud sources and databases.
The new version of SSIS Data Flow Components for Dynamics CRM allows users to connect to Dynamics CRM using OAuth 2.0 authentication. They can perform web login to Dynamics CRM instead of specifying their user id and password in the connection settings. This also means that when you store an OAuth 2.0 connection in your SSIS package, in fact, an OAuth 2.0 refresh token is stored instead of user id and password.
Besides, the new version of SSIS Components now support Dynamics CRM MultiSelect Option Set columns and PostgreSQL composite types. SSIS Data Flow Components for Magento now can obtain and load order items information for sales orders, and thus, allow you importing new sales orders into Magento 2.x. We have also improved web login process in SSIS Data Flow Components for BigQuery, allowing you to use system default browser.
Additionally, SSIS Data Flow Components for Mailchimp now support the Opened table, providing access to the information about subscribers who opened a campaign email.