Connecting Hadoop on Azure to your Amazon S3 Blob storage

When working with Hadoop on Azure, you may be used to the idea of putting your data in the Cloud.  In addition to using Azure Blob Storage, another option is connecting your Hadoop on Azure cluster to query data against Amazon S3.  To configure Hadoop on Azure to connect to it, below are the steps (with the presumption that you already have an Amazon AWS / S3 account) and have uploaded data into your S3 account. 1) Log into your Amazon AWS Account  and click onto Security Credentials 2) Obtain your access credentials – you’ll need both your Access Key…

Rate this:

SQL Server/PDW Hadoop Connectors

Stargate-SG1 Quote from SG-1 episode Bad Guys: (Vala is attempting to power the stargate with a Goa’uld bomb.) Vala: There’s a 70% chance that if we dial manually we’ll be able to establish a connection, and a 50% chance the bomb will just go off. Lt. Col. Mitchell: That a 120%. Vala: Well there’s some crossover where we establish a wormhole and it blows up. Lt. Col. Mitchell: [on the radio] Jackson, did you catch any of that? Dr. Jackson: Yeah, 100% chance we should have brought someone who knows what they’re doing.     In the posting Parallel Data…

Rate this:

Delegation, Claims, Active Directory….Again?! Frak!

As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment.  In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated. Today Lee had followed up with his new posting Testing the Claims To Windows Token Service for different identities which is an important read because: It includes the full script of the how to test the whether different identities can work properly within the c2wts…

Rate this:

Dude, Where’s my PowerPivot workbook?

In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or SkyDrive.  What we’re referring to here is the fact that you went ahead and saved your PowerPivot workbook to the SharePoint, typically through the Excel Save As or Save to SharePoint function as noted in the posting: Uploading #PowerPivot for Excel workbook using “Save As”…

Rate this:

Ramblings about missing time … and #PowerPivot sneak peek!

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse!  Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…

Rate this:

Troubleshooting #PowerPivot Excel Services connectivity

You’re on your way to PowerPivot for SharePoint functionality – you’ve uploaded your PowerPivot for Excel workbook to your SharePoint PowerPivot Gallery.  You view the thumbnails of your report and they look nice.   From the thumbnail, you click on the report you want to see, and the report renders nicely.   But then you click on a slicer, and then all of a sudden you get an error like the one below.   What can you do?  Well, for starters, the key thing is to %commonprogramfiles%\Microsoft Shared\Web Server Extensions\14\LOGS\ folder and review the ULS logs which contain a lot…

Rate this: