I have a question that I can’t seem to figure the definitive answer to: If I want to use my Piwik log data in an external reporting tool like Tableau, and most of that data is auto-archived, the only way to query it is via the Reporting API… is that correct? Once the data is archived, there’s no way to query it directly via MySQL, right?
as long as you haven’t enabled that piwik deletes the
raw data after archiving (
Delete old visitor logs), the log of all visits stay in the Database.
I’d still recommend you to use the api instead of fetching from the database.