Using MySQL as data source in Microsoft SQL Server Analysis Services
- by coldilocks
Hi,
I have installed the latest .net connector (http://www.mysql.com/downloads/connector/net/), I can add MySQL databases as Data Sources, I can even browse through the data from Business Intelligence Studio.
The problem is that I CANNOT create a datasource view, or if I do create one without tables, trying to add them after the fact gives me the…