Hi there. I need to test the following if it’s possible at all:

Build cubes in SSAS 2008 Enterprise 64 bit based on a star schema stored in Infobright Windows 64 bit.
I need to test if I can deploy big cubes in SQL server without partitioning tables and cubes, thus not needing Enterprise version of SQL server.

I expect questions like “why do you need cubes…”, the answer is that I have an extremely efficient and low cost Bi front end for MS SSAS cubes, and upon a data explosion, I would like to have a fast alternative to SQL Server with partitioned tables…

Can I connect MS SSAS and Infobright in 64 bit? I can only find .Net provider 32 bit for MySQL. Is there any 64 bit one? What about Oledb provider for MySQL 32 and 64 bit?

I do need 32 and 64 bit connectors, since we all know MS BIDS is a 32 bit app, so it needs 32 bit driver even in the 64 bit product…

Thank you

Michael

Hi Michael,

I’m not quite sure what you’re trying to perform; can you further expand?  Infobright is embedded in mysql and cant be used in another db.

Best Regards,
Jeff

Thank you.
As my post says. I need to be able to build a SSAS 2005-2008 cube based on Infobright Data.

The problem is the availability of an OLEDB Driver for MySQL in 64 bit Windows.

ODBC is not officially supported by MS in new versions of SSAS, I have made tests with ODBC through OPENRECORDSET commands in SQL Server through an attached external server, but it doesn’t work with large tables ( I mean really big tables, 100 million records or more), I always get a Timeout Error…

Having a MySQL OLEDB Provider, for Windows 64 bit would do the trick…

regards

Michael

Hi,

You could install the MySQL ODBC driver, then use the OLEDB provider for ODBC on top of that.

Alternatively, there’s a commercial OLEDB driver for MySQL
here, but I’m not sure it’s available in 64-bit.

Geoffrey