Toad World® Forums

Some general question about Toad data modeler


#1

Hi

  1. I am wondering when MYSQL will be supported by TOAD Data Modeler 3 beta.
    I always heard about you can write your own custom script, could you give me some idea about what it is about? Javascript? vbscript? SQL script? or what programming language it is?

Many thanks

Chi


#2

Hello Chi,

I am wondering when MYSQL will be supported by TOAD Data Modeler 3 beta.

Yes, we’re working on support for MySQL, however at the moment are not able to estimate when the support is finished.
Thank you for understanding it.

I always heard about you can write your own custom script, could you give me some idea about what it is about? Javascript? vbscript? SQL script? or what programming language it is?

Yes, I can give you some very brief information on this issue.

In Toad Data Modeler 3, there’s a wide range of things of which you can change functionality via your own scripts. Examples: script generation, reports generation, verification etc. The customization functions (work with scripts and packages, metamodels etc.) in TDM3 have been in development, and at the moment the process is at a final stage. - So now we can start preparing documentation for you. - And yes, we’re working on this, however it will take some time until we are able to present complete documentation. It’s not a question of few days. I’m afraid, I need to ask you for patience.

Nevertheless, some quick information on this issue for you:
TDM3 is an object model that you can further extend via the following two basic tools - metamodel and scripts.
To look over some system metamodel (= a metamodel that has been designed by our TDM team), open the Package Explorer, right-click any package and select Open Metamodel. (Not all packages have metamodel. For those that have not it, an empty metamodel will be created after you select this option.)

Every class in TDM3 can be extended by creating a new class in Metamodel. The class will have the same name and object type. To such class, you can:

  • add new properties (You can have access methods Get and Set defined by script.),
  • add new methods (always defined by script),
  • define relations between the new class and other classes (existing or new ones),
  • overwrite some existing methods and properties.
    For users, the User Package is determined.

Scripts can be written in any of mentioned languages - JScript, VBScript or Internal script. Scripts are accessible via Script Explorer or Package Explorer. In scripts, functionality of some properties and methods is defined. And particularly these scripts differ by the database you use.

A little bit of metamodels is shown in the Customization of Forms movie at:
http://modeling.inside.quest.com/entry.jspa?externalID=707&categoryID=30

Well, this has been just a quick first insight into this topic. Again, I need to ask you for patience until we finish the appropriate documentation. Thank you very much.

Regards,

Vladka


#3

Hi vladka

Thanks for the tutorial, I understood it more now = ). I found an spelling mistake one of the tutorial slide. it spells “standard” to “standart”
http://modeling.inside.quest.com/shares/modeling/sbin/movies/customization_of_forms.htm

please find the attachment.

Thanks

Chi
spelling error.doc (182 KB)


#4

Thanks.

Have a nice day.

Vladka