Devart SSIS Data Flow Components allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).
Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.
Supported Data Sources
What You Can Do with Devart SSIS Data Flow Components
Export data from various sources to different file formats
Import XML, CSV, and other files to cloud applications and databases
Synchronize cloud applications and databases
Migrate from one cloud application to another
Replicate data from various cloud applications to relational databases
Load data between various cloud and relational data sources
Integrate various data sources via SSIS
Migrate from one database to another
Included Components
For each of the supported data sources, Devart SSIS Data Flow Components include:
Data Flow Source Component
Devart SSIS Source components come with convenient and user-friendly editor that visually displays the corresponding source objects and SSIS variables. It allows you to quickly configure your SELECT query that gets data. SQL SELECT statements are supported both for databases and cloud sources.
Data Flow Destination Component
Devart SSIS Destination components allow fast data loading and has data source specific optimizations. They offer advanced per-row error processing and allow returning generated IDs (primary key values) for records that were inserted successfully.
Data Flow Lookup Component
Devart SSIS Lookup components offer high-performance lookup transformation with advanced caching. To reduce the number of server round-trips, they use SELECT statements that check several rows at once, and cache the returned data to avoid querying the same rows again.
Devart SSIS Data Flow Components Compatibility and Requirements
Requirements
Devart SSIS Data Flow Components require Microsoft SQL Server 2008*, 2012, 2014, 2016, 2017, or 2019 Integration Services.
* Devart SSIS Data Flow Components for Dynamics CRM don't support Microsoft SQL Server 2008 Integration Services.
Currently Devart SSIS Data Flow Components support the following databases:
Oracle
Devart SSIS Data Flow Components for Oracle support Oracle servers 18c, 12c, 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions.
MySQL
Devart SSIS Data Flow Components for MySQL support MySQL server versions 8.0, 5.7, 5.6, 5.5, 5.4, 5.1, 5.0, 4.1, 4.0 and 3.23 including Embedded servers (starting with 4.1), 64-bit MySQL servers, Percona, and MariaDB.
PostgreSQL
Devart SSIS Data Flow Components for PostgreSQL support PostgreSQL server since 7.1 version to 13, EnterpriseDB, Pervasive Postgres SQL servers.
DB2
Devart SSIS Data Flow Components for DB2 support DB2 for LUW: 8.0 and higher.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved
