Hi,
My member asked me 'Can we use the MS Access to handle the current data of DataStage? I get the .mdb file but it is empty. Can I load the data into the Access database?'
We are biginners of DataStage, so any advice will be appreciated.
Best Regards,
Can I use the DataStage data with Microsoft ACCESS?
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
The answer is yes.
Reporting Assistant - Doc_Tool.mdb
If you are asking about the doc_tool.mdb that comes with DataStage clients (it's in the Documentation Tool folder), you populate this with metadata using the DataStage Manager client.
Choose the tool in the toolbar that looks like a typewriter. This opens a dialog box in which you can select the components to be exported into doc_tool.mdb. When you click Update Now they are actually exported.
(On the Options tab the DSN should point to DSReporting.)
You can open the Reporting Assistant (which is actually a startup macro in doc_tool.mdb) from the Manager, or - if you have MS Access installed - directly from Windows Explorer.
Accessing from ODBC Stage
To get at Microsoft Access from an ODBC stage on UNIX you need to have configured an ODBC driver to connect to the mdb file in question, refer to that via the .odbc.ini file, and make an entry for the DSN in your uvodbc.config file in the project indicating that the DBMSTYPE is ODBC (and any other information required).
The answer is yes.
Reporting Assistant - Doc_Tool.mdb
If you are asking about the doc_tool.mdb that comes with DataStage clients (it's in the Documentation Tool folder), you populate this with metadata using the DataStage Manager client.
Choose the tool in the toolbar that looks like a typewriter. This opens a dialog box in which you can select the components to be exported into doc_tool.mdb. When you click Update Now they are actually exported.
(On the Options tab the DSN should point to DSReporting.)
You can open the Reporting Assistant (which is actually a startup macro in doc_tool.mdb) from the Manager, or - if you have MS Access installed - directly from Windows Explorer.
Accessing from ODBC Stage
To get at Microsoft Access from an ODBC stage on UNIX you need to have configured an ODBC driver to connect to the mdb file in question, refer to that via the .odbc.ini file, and make an entry for the DSN in your uvodbc.config file in the project indicating that the DBMSTYPE is ODBC (and any other information required).
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.