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

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ASU_ETL_DEV
Premium Member
Premium Member
Posts: 43
Joined: Tue Sep 09, 2008 1:56 pm

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

Post by ASU_ETL_DEV »

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.
ASU Developer
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

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
Wolfgang Hürter
Amsterdam
Post Reply