Connecting to MS Access DB from DataStage

nvuradi · Post by **nvuradi** » Tue Mar 20, 2007 4:45 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Mar 20, 2007 5:01 am

Use ODBC or save as csv

ray.wurlod · Post by **ray.wurlod** » Tue Mar 20, 2007 6:44 am

Do you have an ODBC driver for Access on UNIX? If not you can't use ODBC.

ag_ram · Post by **ag_ram** » Tue Mar 20, 2007 10:08 pm

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 .

ray.wurlod · Post by **ray.wurlod** » Tue Mar 20, 2007 10:29 pm

There are no such things as drivers from Microsoft that run on UNIX. That was my original point.

nvuradi · Post by **nvuradi** » Wed Mar 21, 2007 4:00 am

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??

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 21, 2007 6:02 am

Check this out

http://www.openaccesssoftware.com/produ ... access.asp

kcbland · Post by **kcbland** » Wed Mar 21, 2007 6:43 am

Link the .mdb to SQL-Server, use the SQL-Server ODBC driver to talk to SQL-Server.

DSXchange

Connecting to MS Access DB from DataStage

Connecting to MS Access DB from DataStage

Re: Connecting to MS Access DB from DataStage