Is there any Universe ODBC driver for download?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Sun Sep 12, 2004 9:19 am
Is there any Universe ODBC driver for download?
Dear all,
Is there any Universe ODBC driver for download? I want to use the driver to connect to DataStage Universe database to perform some query.
Any help is appreciated, thanks!
Gordon
Is there any Universe ODBC driver for download? I want to use the driver to connect to DataStage Universe database to perform some query.
Any help is appreciated, thanks!
Gordon
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
AFAIK there never was an ODBC driver supplied to talk to UniVerse, because DataStage could use BCI/UCI and not need a driver.
IBM do not market a UNIX-based ODBC driver for UniVerse but there are third-party ones out there.
IBM do not market a UNIX-based ODBC driver for UniVerse but there are third-party ones out there.
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: 18
- Joined: Sun Sep 12, 2004 9:19 am
Hi Ray, do you have any idea that if we want to write a Web based application to retrieve some metadata (for example, job properties, routines) from DataStage?ray.wurlod wrote:AFAIK there never was an ODBC driver supplied to talk to UniVerse, because DataStage could use BCI/UCI and not need a driver.
IBM do not market a UNIX-based ODBC driver for UniVerse but there are third-party ones out there.
-
- Participant
- Posts: 18
- Joined: Sun Sep 12, 2004 9:19 am
We want to set up a web application for people to browse metadata of a specified DS server. The application could be J2EE or .NET architecture. People can use IE to browse metadata such as job properties (same in Designer), routine source codes, imported table definitions, etc.kduke wrote:You could do this in a shell or perl script. You could uv, uvsh, ds or dssh to execute SQL to retrieve information. You could also use dsjob.
What exactly do you want?
I know dsjob command, but it can only retrieve information about some basic project/job properties. It cannot retrieve information like routine properties and many other things.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My choice would be RedBack. This sits on both sides of the firewall, managing potentially many web-side connections with many fewer database connections.
RedBack works with UniVerse. It should work with DataStage, though its BASIC programs would need to be recompiled under DS. Since all are now owned by IBM it may be worth requesting.
However...
It remains the case, for now, that the way that metadata are stored for DataStage is not in the public domain. So, even if you could access it via the web, you would not have the information needed to retrieve the information you seek.
A more open Repository database is promised for the Hawk release (coming soon to a vendor near you), in which case a wider range of Web tools will clearly become available.
RedBack works with UniVerse. It should work with DataStage, though its BASIC programs would need to be recompiled under DS. Since all are now owned by IBM it may be worth requesting.
However...
It remains the case, for now, that the way that metadata are stored for DataStage is not in the public domain. So, even if you could access it via the web, you would not have the information needed to retrieve the information you seek.
A more open Repository database is promised for the Hawk release (coming soon to a vendor near you), in which case a wider range of Web tools will clearly become available.
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: 18
- Joined: Sun Sep 12, 2004 9:19 am
Hi Ray, could you please tell me more information about RedBack? I have no idea about this at all.
In addition, I have another idea that is to use uvsh to connect to the remote Universe server and do some query to tables like DS_JOBS. The web application fetches and analizes the output then returns the metadata to the browser. Do you think it is applicable?
In addition, I have another idea that is to use uvsh to connect to the remote Universe server and do some query to tables like DS_JOBS. The web application fetches and analizes the output then returns the metadata to the browser. Do you think it is applicable?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
MetaStage doesn't have a nice Web front end, though the two views that can be brought into a browser are getting close. Problem is, that's OK for an intranet - what are the issues with the internet?
RedBack is a separate IBM product for managing Web connections to UniVerse and UniData databases. Read about it at IBM's website
RedBack is a separate IBM product for managing Web connections to UniVerse and UniData databases. Read about it at IBM's website
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:
Not Red Brick. RedBack. Two very different products. RedBack would not be appropriate for the MetaStage directory; it only talks to UniVerse and UniData. The MetaStage directory is (currently) a "database of your choice".
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.