InformationWeek

September 14, 1998

Data Warehouse Modeling Tools

Data Warehouse Modeling Tools
Products	ER/Dimensional Diagrams	Forward/Reverse Engineer	Databases/MDD Supported	Special Features
Anubis Constructa 510-749-8800	no, yes, and treeview	yes, yes, and synch	DB2, Informix, SQL Server, Oracle, Sybase, RedBrick, Tandem, Teradata	two-way link diagram and schema optimize physical schema
Cayenne Terrain 800-528-2388	yes, no	yes, yes	More than 20 database systems	used by a number of data mart tools Expert Advisor online help tool
Microsoft Visual Data Modeler 800-426-9400	yes, no	yes, yes	SQL Server, MS/DSS, Oracle	free links to MS Repository
Platinum/Logic Works Erwin 609-514-1177	yes, yes, and treeview	yes, yes, and synch	DB2, Informix, SQL Server, MS/DSS, Oracle, Sybase, RedBrick, Teradata	estimate Data Warehouse size from design Data Warehouse validity checks
Popkin System Architect 609-514-1177	yes, no but treeview	yes, yes	CA Ingres,DB2, Informix, MS Access, FoxPro and SQL Server, Oracle, Sybase, RedBrick, Tandem, Teradata	highly customizable interface macro language for operations
Relational Matters 44(0) -1483 295 870 (UK)	no, yes, and treeview	yes, no	Arbor Essbase, Business Objects, Cognos PowerPlay & Impromptu, Ingres, IA DSS, IQ, MS SQL Server, Microstrategy DSS Agent, Oracle8 and Express RedBrick, Speedware, Sybase	map fields to multi sources gen scripts to transform tool links to transform tool
Sybase Warehouse Architect 800-395-3525	yes, yes, and treeview	yes, yes, and synch	Arbor Essbase, Cognos PowerPlay and Impromptu, SQL Server, Microstrategy DSS Agent, Oracle8 and Express, DB2, RedBrick, Sybase ASIQ and AS, and ODBC	gen OLTP extract scripts gen test data for Data Warehouse/MDD reverse engineer MDD designs