Is there anybody who had experience of PW and some cloud BI solution integration?
We've got tons of orders, users, products, etc in our PW db. Now we want to analyse all this data using cloud BI.
Would it be wise to have db replica and connect it via sql as here - https://www.periscope.io/ ?
Or less-sql solutions like http://www.alteryx.com/ ?
In both cases data cube setup would require knowledge of PW db structure.
Is it safe to rely that structure won't change? If not safe, then what would you recommend?