SSIS and Data Sources

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:

• MSMQ (Message Queue Task)
• (s)FTP (FTP Task) **
• HTTP/HTTPs (Web Service Task)
• IBM MQ Series*
• Tibco Rendezveus*
• Unstructured & Semi-structured Data
  • Microsoft Excel, CSV
  • Text
  • XML
  • EDI
• Ecommerce Applications
  • Bigcommerce
  • Magento

*not supported out-of-the-box, however, components can do this.

** sFTP is not supported out-of-the-box

↑ Back to top

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.

Related Articles

• SSIS Connection Managers: http://social.technet.microsoft.com/wiki/contents/articles/ssis-connection-managers.aspx
• SSIS - Microsoft SQL Server Connectors :http://social.technet.microsoft.com/wiki/contents/articles/ssis-microsoft-sql-server-connectors.aspx
• SSIS with Unstructured and Semi-Structured Excel, CSV Data: http://social.technet.microsoft.com/wiki/contents/articles/ssis-with-unstructured-and-semi-structured-excel-csv-data.aspx
• SSIS: Excel Connectors: http://social.technet.microsoft.com/wiki/contents/articles/1954.aspx 

↑ Back to top