using mongodb with chartio
TRANSCRIPT
Using MongoDB with
Connecting MongoDB to Chartio
● Chartio does not currently support direct connections to NoSQL databases
● Users can connect MongoDB to Chartio through a tool developed by Stripe called MoSQL
● MoSQL creates and live-updates a PostgreSQL instance of your MongoDB data.
How does it work
● Running MoSQL imports the contents of your MongoDB database into a PostgreSQL instance, essentially creating a backup.
● The PostgreSQL database can then be connected to Chartio, ready for you to visualize your data.
● MoSQL keeps the Postgres database live-updated with the changes in your MongoDB, allowing you to run production services on your MongoDB and opens up your querying power to SQL.
Benefits of connecting MongoDB
● When connected to Chartio, MongoDB users are able to utilize SQL queries for their data visualization.
● We always encourage our customers to make a backup of their database, so by simply making a backup in PostgreSQL you can easily query your data through Chartio.
Customer Testimonial
Chris Winslett, Sales and Revenue Engineer at MongoHQ, gave us
his insights to the success of MongoDB with Chartio. In Chris' words,
"We use a combination of SQL, NoSQL, and other services - MongoDB, Postgres, Redis, Reimann, Google Analytics, etc. We needed a platform that would allow us to visualize, experiment, and collaborate with our data. We didn't want to learn new ETL processes, we just wanted a service. Every other service required us to engage with their data store - we had our data stores, we just wanted a front end."
Resources
● Our docs on connecting MongoDB to Chartio: http://knowledgebase.chartio.com/knowledgebase/2014/1/8/can-i-use-mongodb-with-chartio
● Learn more about MoSQL: https://github.com/stripe/mosql
● Learn more about Stripe: https://stripe.com/blog/announcing-mosql