Connecting to MySQL database from Analysis Services I need to know whether it is possible or not to get data from a MySQL database and create a Cube in Analysis Services 2008. If so, tell me how to connect to MySQL Database from Analysis Services.
You can do this using MyODBC. Install the connector, then just set up a DSN and use it as normal.