Data Sources

In this section I'll explain what types of data sources enterprises need to integrate data from, and how SSIS supports these 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. [1]

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, S4), 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,[2] 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)
  • Salesforce
• 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*
  • Bluray Ripper
    
  • Tibco Rendezveus*
• Unstructured & Semi-structured Data
  • Microsoft Excel, CSV
  • Text
  • XML
  • EDI

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

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

[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 its not confirmed. It’s a provider out in the market, and since SSIS supports standard  lpn to rn programs interfaces like ADO.NET and OLEDB,[4]its 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.

Awesome tutorial. Check it out. WoW Accounts
External Links:

Best Computers Shops

hisse senedi fiyatları