Hello, I hope this should be the right forum if not, sorry for the inconvenience.
I'm in research for a platform that fulfill my needs for a Business Intelligence and ETL.
What we do have normally:
MySql 5.5 databases which stores all transactional information about our systems in tables which are in a relational model.
PHP 5.4 and Apache 2.2, all inside Centos 6.7 (components to run web apps we develop)
Those are my questions:
- Is Kibana what I need to do the BI and ETL job?
- Where do I define metrics and dimensions?
- Where is the ETL? Do I need one? Which one?
- Is information taken from transactional database or creates a new one to do the analytics job?
I really appreciate your help.