We built our BI connector a few years ago for all the reasons you outline. Definitely worth a spin if you have this challenge again. Basically makes MongoDB look like MySQL (if that floats your boat :-)).