Page 1 of 1
Pulling data from MS-Access
Posted: Mon Jul 16, 2007 10:25 pm
by nilesh
Hi,
I would like to pull data from MS-Access database.How do i do that in datastage.
Thanks in advance.
Nilesh
Posted: Mon Jul 16, 2007 10:39 pm
by ArndW
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.