Model Report in Excel

Toad Data Modeler
1

Hi,
I Wanted To Know, Can TOAD Data Modeller Generate A Report in Excel Format.
I Want All The Table Names And Their Attributes With Their Constraints.
Please Let me Know is There Any Way In TOAD To Get A Report in This Format in EXCEL Sheet.
Thank You
Raman

2

Hi,

you can generate CSV files from Toad Data Modeler.
Click Model | Reports/XSL Transformation…
New dialog opens. Choose item Entities (CSV) from the first combo box and click Transform.

This will generate a sample CSV file that can be opened in Excel.

The following file will allow you to generate more detailed report:
http://modeling.inside.quest.com/entry.jspa?externalID=2701&categoryID=407

Feel free to modify the XLS file to generate desired output.

Regards,

Vaclav

3

hi,
Thanks For Giving Me The Reply,But I Want Entities And Their Attributes And Constraints on Them in The Excel Sheet.
Raman

4

Hi,

you can customize the XSL template easily, or, if you send me more details, ideally sample model and sample report, I will help you.

Term “Constraints” is too general for me. Tables can have check constraints, columns can have check constraints, relationships…

Regards,

Vaclav

5

hi,
Herewith I Am Attaching My Sample Excel Sheet,How Actually The Report Should Look…
Hope You Could Help Me…
Raman
SAMPLE EXCEL SHEET.xls (17.5 KB)

6

Hi Raman,

there is a way how to get similar report, but it would require additional effort.
I published an article that shows how to generate word or excel reports via XSL transformation:

http://blogs.inside.quest.com/modeling/2010/12/22/ms-word-and-ms-excel-reports-via-xslt/

Another possibility you have is to use TDM freeware as a viewer for your models.

Regards,

Vaclav