DSXchange

Posted: **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...

Posted: **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.

Posted: **Wed Mar 07, 2012 3:03 pm**

UNIX drivers for MS Access do not ship with DataStage.

Posted: **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.

Posted: **Thu Mar 08, 2012 7:43 am**

Thank you all for your responses...

DSXchange

Read MS access database in Datastage

Read MS access database in Datastage