Is anyone using, or have any suggestions for, a free/cheap data modelling or database design tool? We are about to start planning and building a new data warehouse. It is fairly small, and we can't justify paying for Erwin licences, so I wondered if anyone was using anything else.
I've tried using Visio (as per another forum post), but you can't get the information out once you've typed it in. Our other oiption is to document it in excel, and I've actually downloaded a template which has VBA to write create table scripts, which with a bot of changing would be able to create versions for Teradata. However if anyone can recommend any other options I would be grateful to know about them.
It's shameless plug time! Take a look at Wherescape Red and 3D. Red is the only integrated development environment for datawarehousing that I've ever seen. It will solve your ETL, modeling, development, scheduling, and documentation needs in one tool.
Don't even try to build a data warehouse model without a real modeling tool. There are many productivity features in a "real" modeling tool that a drawing tool cannot provide. We use Erwin for logical and physical modeling. WhereScape Red provides excellent productivity for physical modeling and ETL. I've heard first hand praise of the productivity and capability of Red. It is works excellent with the Teradata database.