Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite

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.

share|improve this question

2 Answers

up vote 3 down vote

You can do this using MyODBC. Install the connector, then just set up a DSN and use it as normal.

share|improve this answer
up vote 2 down vote

You can also create a linked server connection to the MySQL DB using ODBC. Openquery can be used to query the MySQL DB from within SSMS. See these links for Openquery, SQL2008-MySQL linked server.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.