ERwin comes with Crystal Reports, but will probably work with your existing reporting tools via an OBDC read-only driver. With large data models, the ERwin reporting tools let you produce summaries of key information. Integration with Visual Studio is lacking, though ERwin does integrate with Visual Studio Team System 2008 Database Edition. ERwin supports simple volumetric analysis so you can estimate database size and forecast hardware requirements.ĮRwin will import and export models from a huge number of formats and repositories, including UML, XML and the Common Warehouse MetaModel. You can convert operational models to warehouses, but the conversion only handles the differences between the modeling tools and doesn't add support for data warehousing - that's up to you. Unfortunately, ERwin uses two separate modeling tools for operational databases and warehouses. It includes tools that support linking several operational databases to create a single data warehouse, and for modeling the fact tables that support end-user reporting.
ERWIN DATA MODELER UPGRADE
As you make changes in development, ERwin can generate alter scripts that will upgrade your production database to match the changes you've made in your dev database.ĮRwin also understands the difference between operational databases and data warehouses. ERwin goes beyond data structures to include modeling triggers and stored procedures. You can also reverse engineer existing databases to create a data model. But only two notations are supported: IDEF1X and Information Engineering. The ERwin design interface makes it easy to lay out and refine your initial designs. ERwin likely supports your relational database engine - the latest version adds support for Teradata, for instance.
The tool may be expensive, but it's hard to think of anything ERwin doesn't do in the data-modeling field.ĮRwin lets you graphically develop a logical data model and generate a database schema from your design, which you can implement in your relational database management system.
It's easy to see why ERwin earned Merit Award distinction in the Databases and Data Development and Modeling category of this year's VSM Readers Choice Awards. This month we're looking at two related tools for data modeling: CA ERwin Data Modeler for designing your database schema and Red Gate SQL Source Control for keeping track of the changes that you make to your schema as you add and modify applications. This complete package takes care of modeling data and managing the resulting designs - provided you're using entity-relationship modeling to design your databases. Product Reviews Designing Databases with ERwin Data Modeler 7.3
0 kommentar(er)
