DSXchange

Posted: **Tue Sep 23, 2008 3:11 pm**

We are trying to connect Ascential DS 7.5 (which is on UNIX) with MS Analysis Server (which is on Windows) to get Cube data. Ascential is on a Unix box and MS Analysis Server is on Windows.

1. What ODBC driver can we use to make this connection?
2. Is there support for JDBC drivers in DS?

Any input will be greatly appreciated.

Posted: **Wed Sep 24, 2008 12:41 am**

If you can let your cube been read generaly on UNIX via ODBC DataStage can set up there.

If not you need on of this:

(a) DataStage as Server on you Windows PC
(b) Copy as flat file or else the data to UNIX

DSXchange

ODBC driver from DS(UNIX) to MS CUBE Analysis Server(Window)

ODBC driver from DS(UNIX) to MS CUBE Analysis Server(Window)