Jun 20 2017 02:11 AM
Hi,
I installed your Piwik image successfully on Azure VM: easy. Based on Bitnami.com image.
Now the next step which is more troublesome.
I want to tap the mysql info of this Piwik instance and store the for me essential data on the Azure SQLServer data warehouse, where other customer data resides. I can't find out how it works, tried many documentation tips, mostly based on setting up a connection between a LOCAL mysql instance and ms Azure SQLserver, based on DataFactory.
It simply doesn't work.
note:
- local machine SSH connection with the Piwk instance (via putty/localhost) works all fine, full access.
- i tried the data gateway (data factory) on my local machine: connection with Azure SQLSErver is OK, but no connection with the Azure based mysql instance.
- I tried several ports which are common in mysql setup, even new ports defined at Azure Endpoints.
Can someone help me out? i'd very grateful ;-)k