Page 1 of 1
Connecting to MS Access DB from DataStage
Posted: Tue Mar 20, 2007 4:45 am
by nvuradi
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
Posted: Tue Mar 20, 2007 5:01 am
by Sainath.Srinivasan
Use ODBC or save as csv
Posted: Tue Mar 20, 2007 6:44 am
by ray.wurlod
Do you have an ODBC driver for Access on UNIX? If not you can't use ODBC.
Re: Connecting to MS Access DB from DataStage
Posted: Tue Mar 20, 2007 10:08 pm
by ag_ram
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 .
Posted: Tue Mar 20, 2007 10:29 pm
by ray.wurlod
There are no such things as drivers from Microsoft that run on UNIX. That was my original point.
Posted: Wed Mar 21, 2007 4:00 am
by nvuradi
ray.wurlod wrote:There are no such things as drivers from Microsoft that run on UNIX.
Then How do i connect to ACCESS??? Any work around??
Posted: Wed Mar 21, 2007 6:02 am
by Sainath.Srinivasan
Posted: Wed Mar 21, 2007 6:43 am
by kcbland
Link the .mdb to SQL-Server, use the SQL-Server ODBC driver to talk to SQL-Server.