Conection to be established between Ms Access and DataStage

[Shree0410]

We are running DS 7.0 on AIX and I have a situation to conenct to a Microsoft Access database on a Windows server.

Please tell me how I can achieve this.

[DSguru2B]

Heres a post that i found which will be helpful.

[Shree0410]

I end up in more confusion

[kcbland]

Link the MS-Access to SQL-Server, then use SQL-Server ODBC driver on your Unix machine to access SQL-Server. Or, consider finding the perl libraries that allow you to read .xls and .mdb files on Unix and use a script to pull out your data.

[Shree0410]

Can I establish the connection bwtween Ms Access and DataStage directly using the DSN, user name and password to the database?

What are the constraints/limitations to this approach?

[jdmiceli]

Hi all!

Following along the lines of DSguru's suggestion with the items in the link provided, you might experiment with the read-only functionality provided by the MDB Tools project found here: http://mdbtools.sourceforge.net/.

Please bear in mind, I am a DS newbie and I have no idea if this would work in any way. I am also not an mdbtools person; it is just something I found that works on Unix/Linux that provides some select capabilities against MS Access.

Hope it helps,
Bestest!

[kcbland]

There is no Ascential supplied ODBC drivers for MS-Access on the Unix platform. You must either gain third-party drivers, use an indirect-bridge via something like SQL-Server, or use a custom set of drivers and write some data extraction scripts.