Connect from SSRS 2008 R2 to Hadoop

February 16, 2015

no comments

A colleague of mine from another company had contacted me. He needed to connect from SSRS 2008 R2 to Hadoop in a version of Cloudera 5.2. Now I admit that working in the municipality I don’t have any experience yet in working with the cloud, so it’s hard giving advice without personal experience…
So, I asked Google how to connect from SSRS 2008 R2 to Hadoop and got an answer from Microsoft that was actually sending me to look elsewhere:

“The Microsoft SQL Server SQOOP Connector for Hadoop is now part of Apache SQOOP 1.4 and we are not providing a separate download anymore. Please note that Microsoft’s HDInsight service includes the connector as well.”

So I continue my search and indeed see that SQOOP does offer a download. Even found a detailed post about how to use SSRS against Hadoop. But apparently it’s all in vain as my colleague actually found from Cloudera a solution in form of an ODBC Connector, which he told me worked great for him. So I guess this means there are various ways to connect from SSRS R2 to Hadoop…

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>