-----Original Message-----
From: Wjhonson <wjhon...@aol.com>
To: u2-users <u2-users@listserver.u2ug.org>
Sent: Tue, Jul 16, 2013 9:42 am
Subject: Re: [U2] UML mapping tool for MV (UniVerse)
But with programmers able to create new DICT entries as they will, how do you
*keep* it spotless?
-----Original Message-----
From: Hona, David <david.h...@cba.com.au>
To: U2 Users List <u2-users@listserver.u2ug.org>
Sent: Mon, Jul 15, 2013 5:40 pm
Subject: Re: [U2] UML mapping tool for MV (UniVerse)
Regardless of the toolset, the first hurdle would be to normalise your database
to look like a relational one. Which is likely to be the greatest hurdle. Data
dictionaries in U2/PICK are optional are a purely for reporting purposes - they
can have duplicates and these can be conflicting. Even worse (as if you thought
it could be) - data dictionaries can be incomplete or wrong. This added to the
lack of enforcement of data integrity and constraints usually causes these
toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck!
Rocket released U2 Metadata Manager to assist in this respect and is designed
to
allow forward and backwards capability. Although, support for this in UV is
limited to the latest official release... so your alternative is UV/ODBC...
For UV/ODBC users - I have always recommended a separate UV account and data
dictionary that is spotless. For some this is the best option - why go against
the flow - when you create your own stream...
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
