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

Cloud Data Warehouses

Azure Synapse Analytics
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

Adobe Commerce
BigCommerce
Cin7 Core
ShipStation
Shopify
Zoho Inventory
Zoho Invoice

Cloud Accounting Applications

QuickBooks Online
FreshBooks
Zoho Books

Project Management Applications

Asana
Jira
Podio

Helpdesk Applications

Freshdesk
Zendesk
Zoho Desk

Communication Applications

Slack

Payment Processing Applications

Stripe

Other Applications

SurveyMonkey
WordPress
Zoho People

 

You can find more details in the Compatibility article.

 

 

ExpandedToggleIcon        See Also