Connecting to MySQL from SSAS 2008 Project

Posted on 2009-12-16
Last Modified: 2016-02-12
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?
Question by:Srinivas_Vengala
    LVL 14

    Expert Comment

    Are You using  OLEDB or  ODBC.  try ODBC

    this may also help you


    Author Comment

    SSAS 2008 Supports only OLEDB and dotNet providers. I can't use ODBC.
    LVL 14

    Accepted Solution

    are you able to to export data from MySQL to flat csv file, and then load into the partitioned cube

    Author Closing Comment

    Closing this abandoned question to post a new question.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now