Overview

Devart SSIS Data Flow Components are a set of components for SQL Server Integration Services (SSIS) packages. These components allow loading data from and to various sources in SSIS Data Flows.

ExpandedToggleIcon        Components

For each of the supported data sources Devart SSIS Data Flow Components includes a Source component, a Destination component and a Lookup component. Devart SSIS Data Flow Components also include their own Connection Managers for each source. To quickly get started with Devart SSIS Data Flow Components, see the Getting Started section.

Source

Devart Source components allow extracting data from the corresponding sources and passing the data to other Data Flow components. Devart Source components provide convenient editors which allow you to quickly create a query to the data source. For cloud data sources, Devart Source components offer powerful SQL support for querying data.

Destination

Devart Destination components allow loading data to the corresponding sources. Devart Destination components have source-specific optimizations for high-performance data loading for some sources.

Lookup

Devart Lookup components allow joining the input data with the data from other tables in the corresponding data source.

Connection Manager

Devart Connection Manager allow connecting other Devart SSIS Data Flow Components to the corresponding data sources.

 

ExpandedToggleIcon        Data Source Support

Devart SSIS Data Flow Components are offered for the following data sources:

Databases

•DB2
•Oracle
•MySQL
•PostgreSQL
•SQLite
•SQL Server
•SQL Azure

Cloud Data Warehouses

•Azure SQL Data Warehouse
•Amazon Redshift
•Google BigQuery
•Snowflake

Ads and Conversion

•Google Ads
•Google Analytics
•Twitter Ads

Cloud CRMs

•Dynamics 365
•Freshworks CRM
•HubSpot
•Insightly CRM
•NetSuite
•Pipedrive
•Salesforce
•Streak
•SugarCRM
•Zoho CRM

Cloud Marketing Applications

•ActiveCampaign
•EmailOctopus
•Mailchimp
•Marketo
•Salesforce Marketing Cloud
•SendPulse

Ecommerce Applications

•BigCommerce
•DEAR Inventory
•Magento
•ShipStation
•Zoho Inventory
•Zoho Invoice

Cloud Accounting Applications

•QuickBooks
•FreshBooks
•Zoho Books

Project Management Applications

•Asana
•Jira
•Podio

Helpdesk Applications

•Freshdesk
•Zoho Desk

Communication Applications

•Slack

Payment Processing Applications

•Stripe

Other Applications

•WordPress
•Zoho People

 

You can find more details in the Compatibility article.

 

 

ExpandedToggleIcon        See Also