We have been doing a lot of work on pulling social media data into the enterprise and using it against our traditional data warehouses to find some new insights. It can be quite interesting to pull twitter traffic on a product and tying that to retail sales and seeing the correlation between the two.
The technologies we have used are SQL Server 2008 R2, SharePoint 2010 and SilverLight. The solution we used to pull data from Twitter, Facebook, LinkedIn, YouTube and the top BLOG sites is a solution we developed so it could work in the enterprise and supported by I.T. It is a Windows Service that polls a list of active keywords on a timed basis and stores it in SQL Server.
If you have any questions, please feel free to contact us at www.ExtendedResults.com. This is a actual system we can deploy in your enterprise today!