Hi All,
Would you please help me by telling how to import MS-ACCESS file into Datastage server 8.0.1?
Is there any stage available for the same.
thanks in advance
Importing MS-ACCESS File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only way you will do this directly from UNIX is if you have a UNIX-based ODBC driver for MS Access. No such driver ships with DataStage, so it is up to you to find one.
An alternative is to dump your table(s) from Access into some kind of flat file format on Windows, FTP those files to UNIX, and process them there with Sequential File stage(s).
An alternative is to dump your table(s) from Access into some kind of flat file format on Windows, FTP those files to UNIX, and process them there with Sequential File stage(s).
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You follow the installation instructions that came with the driver.
To configure a DSN, you need to do two things; the first is to put an appropriate entry into the .odbc.ini file in the DataStage Engine directory (which is where all DSNs visible to DataStage are recorded). The other is to record that DSN in the uvodbc.config file in your project; this file records those DSNs that are to be visible from the particular project.
To configure a DSN, you need to do two things; the first is to put an appropriate entry into the .odbc.ini file in the DataStage Engine directory (which is where all DSNs visible to DataStage are recorded). The other is to record that DSN in the uvodbc.config file in your project; this file records those DSNs that are to be visible from the particular project.
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.