How to connect Analysis Services to Netezza?

HI,

Netezza is ODBC compliant data warehousing applicance. There seems no way to connect SSAS to Netezza as SSAS does not support ODBC data sources.

Has any body ever tried it? Please provide any feedback, comments etc.

Thanks

Saeed

SSAS will allow you to connect through .Net providers or OLEDB providers, so you have 2 choices

1) ODBC .Net Provider http://www.microsoft.com/downloads/details.aspx?familyid=6ccd8427-1017-4f33-a062-d165078e32b1&displaylang=en

2) There is an "OLEDB Provider for ODBC", this used to be part of MDAC, I know it was in MDAC 2.7, but I have not used it since then. I think MDAC is currently at 2.8 SP1 http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en

Also from what I can see there appears to be atleast one 3rd party company offering OLEDB to ODBC "bridge" drivers.

sql