data dictionary

[BKins]

We are development a custom app with TRIRIGA. I have put together a
sort of development plan of all BOs, the fields within each BO, the
Associations between BOs, GUI mock ups, etc. As I develop it would be
nice to have a data dictionary that showed what has been developed
within the system so that I could compare with my plan and make sure I
have not over looked anything. I assume there is a way to create
something that would show each Module/BO, say a query that looked for
a certain prefix on each Module and BO (e.g. LIKE 'cst%') and show
fields and associations that relate to those Modules/BOs. How would I
get started developing this "report" within TRIRIGA. If this is not
available, then I know that I can do this as a query within the DB
(assuming that I can figure out the translation between Module/BOs and
the tables), but it would be nice to have in the system itself! :-)

Any help/guidance would be greatly appreciated!

Thanks,

Ben

[Eric]

TRIRIGA itself doesn't currently have a "meta-reporting" feature built
in. They used to have an undocumented utility to generate an XMI file
for a selected module (XML Metadata Interchange, basically a UML
model), which you could then report out of using various UML modeling
tools. Last time I tried it though (around 2.1.8 or so) I couldn't
get it working.

The team I work with have a product that provides this functionality
-- it is a web-based utility that you can upload an Object Migration
package to, and it will generate documentation on the objects,
associations, queries, workflows etc. contained in the package and
their relationships to other objects. Let me know if you're
interested, I can set up a demo for you.

If you have some fairly rudimentary needs, I can give you some
guidance on what tables you would query out of to get most of the meta-
information.

Eric

[Ken Janes]

I am trying out "Personal Brain 5" as a presentaton/documentation
tool, mostly to document high level customization for a non-tech
audience. Its kind of like a supercharged association tab. I would
like to find a way to upload a "Brain" from a migration package rather
than inputting it all manually.

\ken

> > Ben- Hide quoted text -
>
> - Show quoted text -

[BKins]

Ken,

WOW the Brain app is pretty cool looking! Have you purchased it (the
Pro or Core version)? While it looks very cool and could be helpful,
as you said, as a presentation layer, but it doesn't appear to justify
the the price -- maybe the free will do though... But it would be
nice not to have to enter it yourself :-)

Thanks,

Ben

[BKins]

Thanks Eric! I had asked this same question to John Smart, and his
short answer was "no". He did, as you, mentioned the previous
(failed?) reporting tool TRIRIGA had, but he said it turn out not too
worth it.

I love to get a demo your new product. I am always interested in see
new tech/apps! Let me know when I could get a demo of this tool.

Thanks again,

Ben

On Jan 5, 6:27 pm, Eric <eric.gl...@gmail.com> wrote:

[Eric Glass]

This is actually exactly the sort of thing we are targeting; in addition to the basic reports, we also output the migration package contents as an XMI file for use with UML tools (similar to what the old TRIRIGA tool provided for the live system).  Looking at the Personal Brain XML import/export format, it wouldn't be terribly difficult to add support for this.  How do you currently organize your documentation... do you have a "thought" node for each Business Object, and just put related info in the Notes section, or do you model all the associations etc. as links between them?  If you have a sample you could send that'd be great to look at, just to see how you are using the tool.

--
You received this message because you are subscribed to the Google Groups "triDeveloper" group.
To post to this group, send email to tridev...@googlegroups.com.
To unsubscribe from this group, send email to trideveloper...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trideveloper?hl=en.

[Barlow, Jim (US - McLean)]

Great discussion guys!!!

 

Ben – Late to the dance here after the other responses, but we did a similar approach…our convention was to add all new fields to a library object first for standardization, with each new element carrying a flag that indicated it was custom and a date.  We could then run SQL queries to get all custom work, even with date thresholds.  Then the use of the description field at the entity level made more sense because we could rapidly extract and summarize the changes since a certain date or since a certain version.

 

Ken – Funny you’re pursuing The Brain…I’m fooling around this for socializing data structures, standards across a really messed up large enterprise.  I agree there’s merits in this presentation layer.

 

Eric – If you schedule some type of demo, I’d love to see your approach, count me in.

 

jim

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message. 

Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]

[Ken Janes]

Yes, I created several types of thought nodes, different colours.
(custom BO/ Custom GUIs). I label the links with the Association
string (this is nice because it only displays the string when you
mouse over it). I use the notes section to list custom fields in the
BO or other data such as "Copy of triWhatever..."

Unfortunately my free trial has expired. The Brain still works but I
can't edit it. It contains details on our customizations (which I now
can't remove) so I don't think I can send you the Brain file. I could
take some screen shots though, but that really doesn't do the model
justice. It's nice to see it "in motion"

One thing I would do differently though is use more Parent/Child links
even if the BOs aren't hierarchical (perhaps to better illustrate the
order of their use (ie: RE Transaction Plan as a "predecessor" to RE
Project).

\ken

> > trideveloper...@googlegroups.com<trideveloper%2Bunsubscribe@google­groups.com>

> > .
> > For more options, visit this group at

> >http://groups.google.com/group/trideveloper?hl=en.- Hide quoted text -

[KCHou78]

Hi there, I'm new to this group and have also been searching for a way
to create a Tririga Data Dictionary. A developer in my group has
almost got this down using sql queries into tridata itself and
displaying the dictionary on a web page. Any one thoughts on this
method?

Kenny

[BKins]

I have created a sort of data dictionary in the past using SQL then
created a report to show this, but I would prefer to do this within
tririga. Using SQL is "plan B".

Here is how I have done this in the past (using SQL Server on another
system (non-tririga). If you are using Oracle I know there is a way
to do this same thing, but it has been years since I have used
Oracle.):

SELECT Tbls.TABLE_NAME AS [Table], Cols.COLUMN_NAME AS [Column],
Cols.IS_NULLABLE AS [Allows Nulls?],
Cols.DATA_TYPE AS Type
FROM INFORMATION_SCHEMA.TABLES AS Tbls INNER JOIN
INFORMATION_SCHEMA.COLUMNS AS Cols ON
Tbls.TABLE_NAME = Cols.TABLE_NAME
WHERE (Tbls.TABLE_NAME NOT LIKE 'sys%') AND (Tbls.TABLE_NAME <>
'dtproperties') AND (Tbls.TABLE_SCHEMA <> 'INFORMATION_SCHEMA')
ORDER BY [Table], Cols.ORDINAL_POSITION

This will return *all* tables and their fields (probably not what you
want), but maybe a good starting point if you can figure out how query
for only the tables you want. I have not looked that extensively at
the table structure in the tririga's DB, but I assume there is a way
to define criteria that would only show you the tables you want.

Hope this helps!

Ben

[Eric]

Here is an example output from the object documentation tool that our
team has built:

http://groups.google.com/group/trideveloper/web/example-docs.zip

Our application is a web-based service that processes Object Migration
zipfiles; so you can export your objects from TRIRIGA, upload the
zipfile, and get back a set of generated documentation.

We're still working through how we plan on making this utility
available (I'm pushing for a free hosted service, so that people in
the development community at large can easily upload migration
packages and automatically generate documentation). We are still
adding functionality and reports, and may at some point provide
customized reports as some sort of value-add service. If this
interests you, send me some feedback via e-mail (eric.glass at
gmail.com) and I can provide that to my management to gauge interest/
demand etc.

Eric

[BKins]

Eric,

I have reviewed the example you provided and it looks great! When is
this going to be released for use?

Thanks,

Ben

[Michael Baker]

Any update from anyone on this? We are looking to generate a Data Dictionary also.

I tweaked the sql below to work for Oracle but I'm still sitting at 107,692 rows of results. That's a heck of a lot to sift thru and define each field.

Regarding the zip file link somone posted...it's 2 years old and of course the link is invalid now. Got a newer link? Any more progress on using Brain?

Thanks,

Mike

[Beverley Thomas]

Michael,

There are 2 ways that I can see that you would be able to achieve your objective without querying the database directly.

The first being the Object Migration feature of TRIRIGA itself.  If you go into the OM tool and ask for an export of everything that has change after a certain date this will pull all the objects, forms, workflows, queries etc into an export package.  Evaluating what this has pulled will get you most of the way to where you're trying to get

The other method that springs to mind is a tool that SERCO offers called Insight,  this tool can be found at http://insight.serco-na.com.  It takes in an object migration package and documents the findings. I believe this is free to use as they have advertised it at a few conferences that I have attended.  Haven't actually used it myself but the idea sounds good.

Hope this helps

Regards,

Bev Thomas
Asset Management & TRIRIGA Consultant
Operations & Supply Chain Management
IBM Global Business Services

Mobile: +44 7976 615 023 E-mail: bev.t...@uk.ibm.com www.ibm.com/gbs/uk/assetmanagement

Thanks,

Thanks,

Ben

--

You received this message because you are subscribed to the Google Groups "triDeveloper" group.

To view this discussion on the web visit https://groups.google.com/d/msg/trideveloper/-/0jCm9zJNMrQJ.

To post to this group, send email to tridev...@googlegroups.com.

To unsubscribe from this group, send email to trideveloper...@googlegroups.com.

For more options, visit this group at

http://groups.google.com/group/trideveloper?hl=en.

---

Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU