Connecting to MySQL from SSAS 2008 Project

I am trying to connect to MySQL database from an SSAS 2008 project using MySql.Data.MySqlClient (MySQL Connector Net 6.1.2). I am able to create a datasource pointing to the MySQL database in BIDS successfully. But when I try to create a DSV based on that datasource by including a table from the underlying MySQL database, I am getting the attached error. Can someone please let me know the reason for this issue?
MySQLError.JPG
Srinivas_VengalaAsked:
Who is Participating?
 
EmesConnect With a Mentor Commented:
are you able to to export data from MySQL to flat csv file, and then load into the partitioned cube
0
 
EmesCommented:
Are You using  OLEDB or  ODBC.  try ODBC

this may also help you

http://www.devart.com/dotconnect/mysql/editions.html

0
 
Srinivas_VengalaAuthor Commented:
SSAS 2008 Supports only OLEDB and dotNet providers. I can't use ODBC.
0
 
Srinivas_VengalaAuthor Commented:
Closing this abandoned question to post a new question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.