I've distilled down what I've read so far:
-> ETL to SQL? MoSQL? BitYota like solution -> Write Ruby and Push to Gecko -> Solutions like JSONStudio -> Other?<p>If you have done this before would be great to hear from you.
excellent thank you @saraTraore
well, I'm not sure if it would fit here but I use http://humongous.io to filter down and visualize my data (average ecommerce mongodb). Hope it helps.