access to oracle
Moderators: chulett, rschirm, roy
access to oracle
Hi ,
My source is MS access but I can not load using ODBC as datastage is installed on unix and access is windows ..
We do not have drivers for ODBC ..
What is the other way I can load MS access to Oracle.
Can we do it on Database (MS access - Oracle) level without using Datastage ?
I found one tool which converts Access to oracle(online) but it is one time load and converts from local copy of database ( on my desktop)
I want to conect to remote Ms access database ,extract data and load into staging area in oracle tables .
Please guide ....
Thanks.
My source is MS access but I can not load using ODBC as datastage is installed on unix and access is windows ..
We do not have drivers for ODBC ..
What is the other way I can load MS access to Oracle.
Can we do it on Database (MS access - Oracle) level without using Datastage ?
I found one tool which converts Access to oracle(online) but it is one time load and converts from local copy of database ( on my desktop)
I want to conect to remote Ms access database ,extract data and load into staging area in oracle tables .
Please guide ....
Thanks.
You can do separate steps - one to dump the Access data to files and transfer them to UNIX, then a DataStage job to load to Oracle. An Enterprise Scheduler can easily tie them together. Or purchase ODBC drivers and do everything from DataStage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
For DataStage? The pdfs in your PC's "Docs" directory. Otherwise, the vendor: http://www.datadirect.com/index.ssp would be a good place, I would think.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Knowledge, don't know if this will help you. Can you convert your Access Database into a .csv file and then read it in Datastage as a sequential file? Once you are able to read it you should be able to do what ever you need to do with it. Once the .csv is created FTP it from windows to your UNIX source directory before doing anything else. Don't know how big your Access database is and how frequently it is updated? You would manually need to do the .csv conversion process or write a Macro to do it.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The present tense plural form of the verb "to be" is spelled "are", not "r".
DSXchange is not a mobile telephone, and we expect users to employ professional standards of written English, not least because it is a difficult enough language for those whose first language is not English without resorting to SMS-style abbreviations and other pretensions.
DSXchange is not a mobile telephone, and we expect users to employ professional standards of written English, not least because it is a difficult enough language for those whose first language is not English without resorting to SMS-style abbreviations and other pretensions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.