Using MS-Access db as source

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_ram
Participant
Posts: 30
Joined: Fri Apr 06, 2007 6:04 am
Location: Bangalore

Using MS-Access db as source

Post by ds_ram »

Hi
We have DS7.5.1 installed on Unix. How can we use MS-Access as source?
Is there any option out to extract data directly from MS-Access db? Please suggest.

Regards
Ramesh
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please try searching the forums, this has been asked and answered a number of times in the past.
-craig

"You can never have too many knives" -- Logan Nine Fingers
michaeld
Premium Member
Premium Member
Posts: 88
Joined: Tue Apr 04, 2006 8:42 am
Location: Toronto, Canada

Post by michaeld »

I think you would have to setup an ODBC connection to it and access it throught the ODBC stage. You may need to download a MS Access ODBC driver for UNIX.
Mike
Post Reply