We were extracting data out of Netezza into txt files, loading into a SQL Server DB and processing our SSAS cube(s) from there.
We want to change that and load the cube directly from Netezza.
Can anyone give me pointers / ideas / gotchas on this?
You're taking it out of Netezza to put into SSAS? Netezza should easily blow the doors off anything SSAS can do.
Have you tried just using the Netezza database as a ROLAP source? That would be my first port of call.
If you're not getting mind-blowing speed out of your NZ box try pushing more keys into the lower grain tables (e.g. push Account down into an Invoice Detail table so that you can distribute on Account)
Good luck.
So long as you can make am oledb/odbc connection to it, you should be able to make the cube from that.
I wouldn't though. Cubes run best on static data, so I'd still do a regular extraction.
No one has followed this question yet.