Thursday, August 24, 2006

Quest launches Toad Data modeler

Quest have added Toad Data Modeler to their product set. They've given it the rather boring acronym TDM (try saying it aloud). As far as I can tell it is a separate product to TOAD rather than a module with the existing IDE. The licensing costs strike me as a little steep but I guess it's still only half the price of bog standard TOAD for Oracle itself. Under the hood it is CASE Studio, which Quest bought a while back.

Anyway, it supports both Entity Relationship Diagrams and Data Flow Diagrams. Which is actually jolly exciting: I can't remember the last time I drew a DFD but it was probably in 1999, the last time I worked under SSADM. As a possible replacement for Oracle Designer I think the biggest drawback is that it doesn't separate the logical and physical models: they're just two views we can toggle between. I don't know how many people actually maintain two separate models these days, but I would guess that the sort of people who care about data modeling are likely to be the sort of people who would want to keep the logical and physical models separate. And the rest of us will continue using Schemester or some other freeware. (There is going to be a freeware verson of TDM but it won't have all the features enabled; most notably it will lack reverse engineering).

Interpretation: TOAD stays one hop ahead of SQL Developer. Or two if you're one of those people hung up on the performance of your tools.

Update


I suppose I ought to make it clear that I haven't actually used TDM. I have had bad experiences when using a crippleware version of TOAD IDE. But maybe I will download the evaluation copy and see whether it cuts the mustard or cuts the cheese.

5 comments:

Anonymous said...

I'd say that Quest is about 10 years worth of hops ahead of SQL Developer...

Anonymous said...

Oracle had such a good case tool and they left it. What a pitty.

Anonymous said...

The hardcore response is, of course, that all IDEs are crutches and all you need is a command line, SQL*Plus and a decent editor.

I've recently come round to the usefulness of tools like Toad though. The launch of SQL Developer can only be a good thing as it should only spur Quest on to improve Toad and hopefully bring the price down a bit.

Having said that, if schemester is any good (and thanks for the pointer) I shan't be going anywhere near TDM.

Anonymous said...

As with Schemester, there also is T-Ora an alternative (freeware) to Toad. I also fancy using SQLTools.Net sometimes to SQLPlus when I have a table with something like 200 columns and I just dont have the patience of formatting them!!

John Pocknell said...

The good news is that we are currently developing the next version of TDM v3.0. This will have separate Physical and Logical modeling and will be able to do Compare and Merge between Physical/Physical, Physical/Database and Physical/Logical as well as a host of other new stuff (and all for the same price as the current 2.0). So - upgrade now while you have a chance because 3.0 will be out soon ! If you want to try the Beta, click this link : http://modeling.inside.quest.com/index.jspa. The really, really good news, if you have Oracle Designer, is we're planning to have Reverse Engineering in a future release of TDM.