Martin: Piwik stores your data locally in MySQL and exports to Excel, so just open the Excel export in Omniscope to get started. If you can write SQL, add the SQL statement returning the data you want from the Piwik MySQL database in an Omniscope database Connector for live refresh. Piwik publish an open API, so if this Idea gets enough votes, we can add an Omniscope direct Piwick API Connector, as we already have for Google Analytics.
(right now, we are also looking for input on solving this problem for users of Adobe Omniture Site Catalyst. Omniture already sell their Excel Client way of getting Omniture data into Excel - and from there to Omniscope - but some of our clients are asking for a direct Omniscope Connector, rather than go thorough Excel)