CData Connect AI vs. CData Python Connectors vs. SSIS PowerPack vs. create-api.dev Comparison Chart

CData’s AI offering is centered on Connect AI and associated AI-driven connectivity capabilities, which provide live, governed access to enterprise data without moving it off source systems. Connect AI is built as a managed Model Context Protocol (MCP) platform that lets AI assistants, agents, copilots, and embedded AI applications directly query over 300 data sources, such as CRM, ERP, databases, APIs, with a full understanding of data semantics and relationships. It enforces source system authentication, respects existing role-based permissions, and ensures that AI actions (reads and writes) follow governance and audit rules. The system supports query pushdown, parallel paging, bulk read/write operations, streaming mode for large datasets, and cross-source reasoning via a unified semantic layer. In addition, CData’s “Talk to your Data” engine integrates with its Virtuality product to allow conversational access to BI insights and reports.

SSIS PowerPack is a collection of 70+ high-performance, drag-and-drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy-to-use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more. SSIS PowerPack also includes high-quality FREE commercial components and tasks with full support/upgrade. Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Nested attributes, CData Section). Automatically Split exported XML data into multiple files by Size or Number of records. Read XML Document and extract single or multiple properties by name or using XPath expression.