Introduction

In this section we'll explain what types of data sources enterprises need to integrate data from, and how SSIS supports this wide variety of data sources.

After a short description of data source categorization, you'll find links to specific data sources to have more about how that specific data source can be connected to SSIS. And finally, at the bottom of this article, you'll see the full list of available
data sources for SSIS.

Data Source Types and Categories

Data Sources are the source and destinations where SSIS can read/write data. In this section we will have a view of connectors (i.e. Microsoft OleDB provider for Oracle), capabilities (fast load), and tips & tricks per data
source.

One way to categorize data sources is to separate them into logical chunks of how the target data is stored & processed. We can slice the data sources into Application Systems, Database Systems, Queue Systems and Protocols, and Unstructured & semi-structured
data formats. Below, you'll see popular data source brands in each category and a link to more information about how SSIS can connect to these data sources.

DATA SOURCE CATEGORIES

Application Systems

SAP

Siebel

Microsoft Excel

Hyperion (Essbase, Planning, Financial Management)

Cloud Accounting Applications

FreshBooks

QuickBooks

Cloud Marketing Applications

MailChimp

Salesforce Marketing Cloud (ExactTarget)

Customer Relationship Management Systems (CRMs)

Salesforce

Microsoft Dynamics CRM

Zoho CRM

SugarCRM

Database Systems (RDBMS)

Microsoft SQL Server

Oracle

Sybase

IBM DB2

Teradata

MS Access

MySQL

PostgreSQL

Queue Systems & Protocols

An often asked aspect of SSIS: The list of protocols and queue systems SSIS can talk to:

Legend

[1] Product is in beta

[2] Although this provider can connect to and use versions of Oracle up to and including Oracle 10gR2, it does not support database constructs (such as BLOB/CLOB data types) introduced after Oracle 8.0)

[3] Product is in beta

[4] Product is in beta

§ What does "Vendor Support with SSIS" column mean?

YES in that column means that the vendor actually tested their solution with SSIS and can be contacted if there are any issues with their connector when used with SSIS.

NO means, we don't know, maybe - but it’s not confirmed. It’s a provider out in the market, and since SSIS supports standard interfaces like ADO.NET and OLEDB, it’s expected the provider might work with SSIS. But it has not been tested by Microsoft, and we
don’t know if the vendor did any testing.

Note: This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.