HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Connecting to MySQL database from Analysis Services

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
connectinganalysisdatabasemysqlservicesfrom

Problem

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.

Solution

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

Context

StackExchange Database Administrators Q#2253, answer score: 3

Revisions (0)

No revisions yet.