[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1075
  • Last Modified:

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
0
Srinivas_Vengala
Asked:
Srinivas_Vengala
  • 2
  • 2
1 Solution
 
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
 
EmesCommented:
are you able to to export data from MySQL to flat csv file, and then load into the partitioned cube
0
 
Srinivas_VengalaAuthor Commented:
Closing this abandoned question to post a new question.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now