matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.92k stars 2.66k forks source link

Matomo integration with Apache SuperSet & other BI tools #15355

Open siva538 opened 4 years ago

siva538 commented 4 years ago

Hello Matomo Team,

This is a request for enabling integration with Apache SuperSet and/or any other BI visualization tools. As the data sources are growing across the organizations and so is the sizes of the data, there is a necessity for the visualization of data (of Matomo) in correlation with other business generated data.

Connectivity enabling with rest of the BI tools will help the data stay relevant and useful (and is not limited to only custom reports of Matomo) for analysis purposes.

It would also be helpful for providing connectivity with Apache Spark or other tools, so the data can be correlated in the DW system for both historic and predictive analysis.

In case there are any systems already doing such analysis using these tools, please help point us there.

Thanks a lot.

mattab commented 4 years ago

Thanks for suggestion @siva538 - so far there are usually two ways to connect to these tools: Direct SQL connection to Matomo SQL database, or API access. Learn more: https://matomo.org/faq/how-to/faq_24536/