The Ultimate SSIS Integration Suite
Hundreds of High-performance SSIS Components. Simplify data movement, integration, & transformation with codeless connectivity
- 200+ data flow components & tasks
- Codeless integration with cloud apps, databases & more
- Enterprise-class performance & security
- Azure Data Factory compatible
Integrate Everything with SSIS: Cloud Apps, Databases, Data Warehouses, & More
Leverage SQL Server to do more with the most comprehensive and advanced set of SQL Server Integration Services components. Synchronize or replicate cloud applications and databases, import & export to various files and cloud storage solutions, connect back-office processes through SSIS workflows, and so much more.
Codeless Integration
Drop-in SSIS data flow components and tasks enable rapid integration of data, file transfer, messaging, and more.
All-Inclusive Subscriptions
Unrivaled data integration capabilities delivered through comprehensive MSDN-style SSIS subscriptions.
Enterprise-Class Design
Built with the same reliability, scalability, performance & security powering leading data integration solutions.
Data-Centric Architecture
A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more.
Available SSIS Components
Powerful SSIS Data Flow Components for SQL Server integration.
(API Driver)
SSIS Data Flow Components in Action!
Watch the video overview for a first-hand look at the powerful data integration capabilities included in the CData SSIS Component Suite.
The most advanced SSIS components anywhere
Universal Data Connectivity - On-Premise or Cloud
Connect to the data sources that power your business: CRM, ERP, Accounting, Marketing, Collaboration, Social, NoSQL Databases, Data Warehouses, Files, Cloud Storage, and more!
Light-Years Beyond REST Connectors
Next-level codeless data connectivity. Each component includes a robust SQL-92 Engine that seamlessly supports bulk operations, push-down, dynamic schema & metadata discovery, and unmatched performance.
- String, Date, Numeric SQL Functions
- Collaborative Query Processing
- Query Folding / Pushdown
- Replication and Caching
Secure File Transfer & Messaging Tasks
The CData SSIS Tasks extend SQL Server with powerful secure file transfer, storage, networking, encryption and compression capabilities. With the CData SSIS Tasks, users can integrate end-to-end file and data movement.
Cloud-Ready (Azure Data Factory)
Moving on-premises SSIS workloads to Azure can reduce the operational costs of managing infrastructure, increase availability with the ability to specify multiple nodes per cluster and deliver rapid scalability. The CData SSIS Components fully support Azure Data Factory deployment.
Learn More: Deploy CData SSIS Components to Azure Data Factory
Included Encryption & Compression
The CData SSIS Tasks offer file encryption/decryption and compression/decompression across the most commonly used file and streaming formats, including OpenPGP, AES, Zip, Jar, GZip, etc.
High-Performance Bulk/Batch Data Loading
The CData SSIS Data Flow components are built from the same high performance engine that powers some of the leading data integration solutions in the industry. All components support advanced bulk/batch import and export capabilities at unrivaled speeds.
Robust API Support (REST/JSON/OData)
Don't see a Data Flow component for the data source that you need? CData Subscriptions include API components (REST/JSON/OData, etc) for integration with every and any data source. The components make API integration truly low-code, dramatically simplifying JSON consumption and OData service integration.
Seamless Integration With Visual Studio
Fully integrated with the SQL SSIS Visual Studio .NET environment and Microsoft Business Intelligence Development Studio at design-time. Supports Microsoft SQL Server Integration Services (SSIS) 2012, 2014, 2016, 2017, 2019, and beyond.
Drag-And-Drop SSIS Development
CData drop-in Tasks and Data Flow Components require no additional development and are easy to deploy.
Robust SQL Support For Cloud Apps & NoSQL
Use the SQL you already know to connect to data from any cloud application or database. Integration with any source is as simple as SELECT * from [Cloud App]
Enterprise-Class Security
Includes standard enterprise-class security features, such as TLS/SSL data encryption for all client-server communications.
All-Inclusive Subscriptions
Our value-packed Professional and Enterprise SSIS subscriptions offer essential data connectivity to many popular applications, databases, and APIs.
- Comprehensive access to SSIS Data Flow Components & Tasks.
- One year of free updates, upgrades, new releases, and support.
- Enterprise and Professional options.
With the CData SSIS Components & Tasks you can...
- Synchronize SQL Server with data from any data source.
- Automate integration processes like mass imports / updates, data cleansing, and de-duplication.
- Bulk/batch import/export from cloud applications, databases, and files.
- Replicate data to offload queries from operational systems to reduce load and increase performance.
- Integrate secure messaging, compression, encryption & secure file transfer with SSIS workflows.
- Connect data to analytics for BI and reporting.
- Archive critical application data for disaster recovery.
Included Components
Data Flow Source
Write queries, not code. Powered by a robust high-performance query engine, the CData SSIS Data Flow source components allow users to query any application, database, or service without writing complex integration or transformation code.
Data Flow Destination
Pipeline data to anywhere - from cloud applications to cloud storage, NoSQL databases, and data warehouses. The CData SSIS Data Flow destination components make it easy to back up, replicate, or synchronize data across your organization.
Data Flow Lookup
All Data Flow components include a complementary high-performance lookup transformation component allowing users to supplement or validate the data in your data flow. Includes configurable caching to minimize server round trips and a flexible SQL query interface.
SSIS Tasks
Easy-to-use SSIS Tasks provide robust, enterprise-ready Internet connectivity, secure messaging, and file transfer capabilities for SSIS developers.