Pulling data from MS-Access

nilesh · Post by **nilesh** » Mon Jul 16, 2007 10:25 pm

Hi,

I would like to pull data from MS-Access database.How do i do that in datastage.

Thanks in advance.
Nilesh

ArndW · Post by **ArndW** » Mon Jul 16, 2007 10:39 pm

You will connect to MS-ACCESS using ODBC. If your DataStage server is also on Windows then you can use the drivers supplied by Microsoft and use MS-ACCESS directly. If your DataStage server is on another platform you will have to find a source for ODBC connectivity, as those drivers are not part of the scope of DataStage.

DirectConnect used to sell ODBC drivers for various platforms, but I am sure that there are others.