myStorage – SelfStorage Business Intelligence Platform on Caravel
A couple of days ago, airbnb – one of the shared economy flag ships – released it’s own BI platform to the open source community. Comparable to solutions like Kibana from Elastic – it’s much more BI than LOG driven. Those of you who know Logstash and Kibana know what I mean! 🙂 For our kind of business Caravel seems like a much better fit! It cares about security and you can build your own global KPI Dictionary to include the same values into several dashboards. Let’s get started!
- Install Docker http://www.docker.com
- Install the Docker Image from Caravel (pls. check http://hub.docker.com for latest version)
After you have started the docker container, pls. ensure that you have the python drivers installed for your database. We decided to run our mysql database from out storage software.
Setup your connection string
Here you can add a new connection and pass the mysql uri like this:
Add tables to run your queries
One of the problems you might face, that you need to know which tables are existing. If you aren’t sure about it, you can go back to the database connection uri and click the TEST Button and all tables in the database will be listed on the page.