My requirement is to access MS Access DB from DataStage 7.5.1 parallel jobs. Can i use the ODBC stage to do that. Else what is the best way to do it. The data volume that I am looking at is not huge.
nvuradi wrote:My requirement is to access MS Access DB from DataStage 7.5.1 parallel jobs. Can i use the ODBC stage to do that. Else what is the best way to do it. The data volume that I am looking at is not huge.
Thanks in Advance.
Naren
We had connected to MSAccess ..U will need a DSN (UserDSN/SystemDSN) to be configured .Then an ODBC Stage can be used . If you are using it on unix you may want to have MicrosoftAccessDrivers to connect via ODBC i suppose .
Link the .mdb to SQL-Server, use the SQL-Server ODBC driver to talk to SQL-Server.
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