MEGA documented in SQL tables and querys

[cerrejon]

Hi, I can document how MEGA tables and SQL querys, or any reference document to do. regards

[jhorber]

Hello cerrejon

The question is not cristal clear

If your question is 'Is there a reference documentation for SQL tables or SQL queries used in HOPEX with SQL Server/Oracle storage?' the answer is no. MEGA considers this as an internal implementation and it is not documented.

If your question is 'Is there a reference documentation for concepts (MetaClass) used in HOPEX?' the answer is yes.

However this not a document. MEGA Studio enables to browe the metamodel using query tool, explorer tool, property page.

Metamodel diagram can also be used to understand specific areay of the metamodel

See also http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=50120000000mqh1AAA

ERQL queries are not documented. You can understand the metamodel browsing using the explorer tool.

Experienced users understand their meaning by reading the ERQL code.

[cerrejon]

Hello, what I really want is to register MEGA tables or diagrams to databases. Thank you,

[lmazurie]

Hi, To complete Jerome's info : RDBMS HOPEX/MEGA tables are not to be documented because proprietary but are "the mirror" of the metamodel ... so yes you can document metamodel by descriptors which are extracting infos on MetaClass, MetaAttrtribute etc ... SQL queries are object like the others so you can use a descriptor even to "display" the Query code and do not forget that a query is "attached" to the queried MetaClass. It's already powerfull and complete for documentation. At a former customer IT department site I can remember a question of this customer who was answering to document the ORACLE tables of PeopleSoft ... ... it is a non-sens obiously :-) Regards,

[lmazurie]

... but everything is stored in the database ...

[cerrejon]

Hello, I understand that part, but what I want is to register the database schema of applications registered in MEGA. Cheers,

[lmazurie]

Please see with Jerome because he is respresenting the editor. Accessing data is perilous and can broke the support ... Sorry.

[ki6i]

What I would do if I was you is to use the MEGA API to export the needed data of the Application and the diagrams and store them to different database. 

[jhorber]

Hello cerrejon

What do you mean by "register the database schema of applications registered in MEGA"?

Can you provide more details on what you intend to get?

[cerrejon]

Hello, I have an application called DOAG with your database, what I want is to registar tables database of that application. Cheers,