John Hester wrote:
>> Augusto Alonso wrote:
>> We need a CLIENT Universe ODBC driver for Linux OS.
>> Does any body know if it is true what that old email says?
> 
> We use OpenLink ODBC drivers on RedHat AS 3.0 with UV 10.1.4 as a
> client for SQL Server (http://www.openlinksw.com).


I will remind folks that the way to accomplish many tasks is by taking a
more indirect approach.  You don't need to make SQL queries direct from
your U2 database, or parse relational results into your MV database.  You
can give queries a name, call a middle-tier that executes that named
process, and return a set of data that is much better suited for
manipulation in the MV environment.  It is not required and probably not
preferred to have SQL queries managed in the U2 environment by relational
DBA's.  These people can modify the queries as required with their own
tools without bothering U2 developers.  And by not hard-coding SQL queries
into your MV DBMS, you are allowing for queries to be run against any
relational environment with no changes at all to your back-end.

This is the basic premise behind web services and SOA (strongly advocated
by IBM), though it doesn't always need to be called by such names.  A more
common name is "delegation", where one person asks someone else to do
something and just get back with the results.  The person who delegates
does not need to be burdened with how the task is performed - you don't
need to link new and specific tools into your U2 application every time you
need to perform a new and unique function.

To discuss specific tasks, fell free to contact me:
TG@ please.remove.this.firstNebula-RnD.com
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to