Elevating Azure Data Factory Integration with CData Connect AI's SSIS Component Connectivity

CData Connect AI has expanded its Azure Data Factory integration with SQL Server Integration Services component connectivity, adding a third connection option alongside OData endpoints and its Virtual SQL Server API. The SSIS-based approach is intended to improve high-volume data transfer performance and support complex ETL tasks, including row-level transformations, fuzzy matching, lookups, cleansing, and custom C# or VB.NET script tasks. It also aims to simplify connections to varied data sources and support existing legacy SSIS packages, while scaling for increasing data volumes. Users can begin by creating a Connect AI trial, adding source connections and optional datasets, authenticating ADF through OAuth, and then accessing configured data and datasets within ADF.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.