Custom ADO.NET providers make interesting data available to SSIS

The ADO.NET providers coming out of RSSBus make some interesting data sources available to SQL Server Integration Services packages through the ADO.NET Connection Manager and Source adapter. The documentation for each of these is available online and includes screen shots. Free trial downloads are also available.

Imagine how you could creatively transform, if not your fortune, at least your QuickBooks data, or filter a large volume of SMTP email, or report on the output of your PowerShell scripts.

The following ADO.NET providers are in production and for sale:

  • QuickBooks.
  • PowerShell.
  • Google Services.
  • Salesforce.com.

The following providers are in beta as of this writing (10/4/2011), but available for trial download:

  • SharePoint.
  • Twitter.
  • Email (POP and SMTP).
  • Facebook.
  • Google Spreadsheets.
  • Amazon SimpleDB.

Plus, since these are standard ADO.NET providers, you can hook them up through Server Explorer in Visual Studio to explore. Here's an example of what the QuickBooks provider exposes:

QuickBooks provider in Server Explorer

At the bottom of the page, you can also vote on which provider you'd like to see next from RSSBus. Options include Microsoft Dynamics CRM, and eBay, SAP, Siebel, and Peachtree.

Thanks to Eric Madariaga of RSSBus (@emadari on Twitter) for bringing these providers to my attention.