cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MEGA documented in SQL tables and querys

MEGA

Re: MEGA documented in SQL tables and querys

Sorry but this is still not clear

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

Jerome
Contributor

Re: MEGA documented in SQL tables and querys

If you mean modelling data models? you can do that with Data Model, Entity objects and etc. if you want exactly SQL database modelling you can use the Database and Table objects in mega

Contributor

Re: MEGA documented in SQL tables and querys

What I want to do is register tables in databases MEGA, example link: http://www.google.com.co/imgres?imgurl=http://www.iesroqueamagro.org/pluginfile.php/7240/mod_resourc...
MEGA

Re: MEGA documented in SQL tables and querys

If I understand and are definitely using HOPEX with SQL Storage (SQL server, Oracle)

1) You want to ist of tables used

2) Maybe you also want to access (consultation, update) the tables from an external application

 

Let us go further

 

1) There is no document that list these tables.

As said before in this thread, we do not provide documentation regarding our implementation in SQL databases

If you want to have a good idea of the data model, it is wised to list and browse the Metaclasses using HOPEX common tools (query, explorer, metamodel diagrams..)

 

2) Consultation and update can be performed using the standard end user interface or the API script

Regarding consultation and update from an external application

  • Read access is not recommended (at customer's risk)
  • Update access is prohibited: we do not allow than an external application updates the persistence model in SQL.

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

 

Jerome
Contributor

Re: MEGA documented in SQL tables and querys

Hello, If it refers to data models modeling
MEGA Partner

Re: MEGA documented in SQL tables and querys

Excuse me for saying so, but you are not expressing yourself very clearly.

 

But from what I can understand from the thread, you would like to document tables of a database associated with an application that you have created in Hopex.

In order to do so, you would need the Database Builder module, which manages the conceptual, logical and physical level of a database.

Highlighted
Contributor

Re: MEGA documented in SQL tables and querys

right that's what I need Thank you