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 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.
An often asked aspect of SSIS: The list of protocols and queue systems SSIS can talk to:
*not supported out-of-the-box, however, components can do this.
** sFTP is not supported out-of-the-box
↑ Back to top
AIX 5.0 and later, AS400 4.5 and later
7.x, 8.0 on UNIX
7.x, 8.0 on Windows
7.x through 8.1 on z/OS
V5R1 through V5R4 for iSeries (AS/400)
SAP Netweaver BI 7 and above
- SAP Table Access, Queries, BW Cubes, BAPIs, ABAP Reports
Essbase
Planning
Financial Management
Marketing Cloud (ExactTarget)
3.3 to 5.1 on Open Systems (UNIX, Windows, OpenVMS)
- Requires SQL Server Integration Services 2005/2008
[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.
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.