Hello:
How to make a connection of Matlab application to MS SQL OLAP database?
Any ideas?

Thanks,
GB

I've never worked with Matlab, so I don't know if it's ODBC/OLE DB compliant,
or has a language that can refer to ADOMD, but more information is needed
here.

Does the connection have to be interactive, or is the connection needed just
to pull data out of Analysis Services non interactively?

If you need to pull data out of Analysis Services in a batch-type mode, you
can use DTS, and put the data where you need it, as long as the target is
ODBC or OLEDB (or excel, Access, text file or any other supported DTS
recipient format) compliant.

If you need to connect and interact directly with Analysis Services cellsets
and if Matlab can make reference to ADOMD or ADOMD.Net, ADOMD is the way to
go.

Good luck.


"GB" wrote: