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.
Conection to be established between Ms Access and DataStage
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Hmmmm....
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!
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!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle