MetaStage repository

[admin]

-----Original Message-----
From: Tom@KnowledgeNetCo.com [mailto:Tom@KnowledgeNetCo.com]
Sent: Monday, October 13, 2003 3:33 AM
To: datastage-users@oliver.com
Subject: MetaStage repository


Hi PPL,

I was wondering if any of you out there had some documentation of how the
underlying MetaStage repository tables all fit together.

I am looking at all the tables that make up the repository database and I
struggling to see what info is kept in which tables and how these tables
are linked together.

I've tried reverse engineering the database, but that did not help much and
I have also looked at the various model diagrams but they do not translate
into the db tables all that well.

So if anyone has done something similar before and has any useful
documentation on this, would you be as kind as let me know about it.

Thanks for the help,
Tom.


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

[admin]

-----Original Message-----
From: udo.neumann@eds.com [mailto:udo.neumann@eds.com]
Sent: Monday, October 13, 2003 4:11 AM
To: datastage-users@oliver.com
Subject: Antwort: MetaStage repository


Hi Tom,

the only documentation is the object layer of the repository. Based on
this you are able to write custom reports with the build in query builder.
An other way is (since MS 6 or 2.2.4) to generate "SQL-Tables" (relational
schema) from MS and on top of this use your own report tool.

Regards,
Udo




"Tom@KnowledgeNetCo.com"

[admin]

-----Original Message-----
From: stewart.hanna@ascentialsoftware.com
[mailto:stewart.hanna@ascentialsoftware.com]
Sent: Monday, October 13, 2003 6:19 AM
To: datastage-users@oliver.com
Cc: Tom@KnowledgeNetCo.com
Subject: RE: MetaStage repository


Hi Tom,

If your goal is to query the database using SQL or a BI tool then I suggest
you get your hands on version 6 or 7. A new SendToDB option was made
available which also included a bundled JSP web interface to query it. This
option populates a Comman DSA Meta Model which can be queried using plain
english SQL.

Otherwise I suggest reading the MetaStage documentation in regards to how
the models are used and what it offers. You need to read also the Metabroker
PDF for each one you are using. You should never need to query the database
directly, this really won't get you very far. Using the MetaStage Explorer
you can build any type of query you like, save it and then execute when ever
you need it.

More importantly you can then build a Template on this query and visualise
the results, produce online documentation or export the metadata results.

I hope this helps.

Stewart

-----Original Message-----
From: Tom@KnowledgeNetCo.com
To: datastage-users@oliver.com
Sent: 13/10/2003 4:33 AM
Subject: MetaStage repository

Hi PPL,

I was wondering if any of you out there had some documentation of how
the
underlying MetaStage repository tables all fit together.

I am looking at all the tables that make up the repository database and
I
struggling to see what info is kept in which tables and how these tables
are linked together.

I've tried reverse engineering the database, but that did not help much
and
I have also looked at the various model diagrams but they do not
translate
into the db tables all that well.

So if anyone has done something similar before and has any useful
documentation on this, would you be as kind as let me know about it.

Thanks for the help,
Tom.


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .