Read MS access database in Datastage

svga · Post by **svga** » Wed Mar 07, 2012 12:43 pm

Hi,

We have a requirement to read the MS access database and the datastage is installed in linux server. Can we use ODBC stage to acheive this scenario. Please advise.

Thank you...

chulett · Post by **chulett** » Wed Mar 07, 2012 2:03 pm

You'll need 'MS Access' ODBC drivers for UNIX to do that. You'll need to check to see if that shipped with the product, if not they will need to be purchased.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2012 3:03 pm

UNIX drivers for MS Access do not ship with DataStage.

qt_ky · Post by **qt_ky** » Wed Mar 07, 2012 6:20 pm

Easysoft has a product that should work. I haven't tried it myself, but I do think they offer a free trial. Then you can purchase it or search from some other vendor.

svga · Post by **svga** » Thu Mar 08, 2012 7:43 am

Thank you all for your responses...