Hi,
I would like to pull data from MS-Access database.How do i do that in datastage.
Thanks in advance.
Nilesh
Pulling data from MS-Access
Moderators: chulett, rschirm, roy
Pulling data from MS-Access
Nilesh Malekar
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.
DirectConnect used to sell ODBC drivers for various platforms, but I am sure that there are others.