Devart SSIS Data Flow Components について


Devart SSIS Data Flow Components allow you to integrate database and Cloud data via SQL Server Integration Services (SSIS). The components provide high performance data loading, convenient component editors, SQL support for Cloud data sources and many data source specific features. Devart SSIS Data Flow Components support Oracle, MySQL, PostgreSQL, DB2, MailChimp, ExactTarget, Salesforce, Microsoft Dynamics CRM, Zoho CRM, SugarCRM, Bigcommerce, Magento, QuickBooks and FreshBooks.

  • 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
  • Data Flow Source Component - An editor that visually displays the corresponding source objects and SSIS variables. It allows you to quickly configure your SELECT query that gets data.
  • Data Flow Destination Component - Allows fast data loading and has data source specific optimizations. Also offers advanced per-row error processing and allow returning generated IDs (primary key values) for records that were inserted successfully.
  • Data Flow Lookup Component - High-performance lookup transformation with advanced caching. To reduce the number of server round-trips, it uses SELECT statements that check several rows at once, and cache the returned data to avoid querying the same rows again.