Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Jun 26, 2007

CA Releases CA Erwin Data Modeler r7.2

By Steven Warren

Computer Associates (CA) announced late last week the release of its latest effort, called CA Erwin Data Modeler (DM). According to CA, they have the first data modeling tool that integrates tightly with Microsoft Visual Studio 2005 Team Edition for Database Professionals. The newest release DM r7.2 is a smaller component of Erwin Modeling Suite that integrates technologies for relations database design and modeling.

As the years have passed SQL Server has become a shining star as a leader in the enterprise class database platform. I can remember a time when it was just Oracle out there on a shiny, golden throne. Those days are long gone. If you are a DBA, Architect, and or developer, you can use the CA Erwin Data Modeler to visualize all of your arduous daily tasks. With CA ERwin Data Modeler r7.2, you can design, generate, and manage data warehouses, enterprise databases, and or data marts.

All of this is presented to you with an easy-to-use user interface (UI) environment that simplifies database design and automates many arduous tasks such as creating high performance transactional and data warehouse databases. Moreover, if you are a SQL Server DBA, you can visually design and generate managed objects in a Microsoft Visual Studio development environment.

"Microsoft Visual Studio 2005 Team Edition for Database Professionals enables database professionals who use SQL Server to deliver business solutions that fulfill the constantly evolving requirements of enterprise customers," said Matt Nunn, group product manager for Visual Studio Team System at Microsoft Corp. By integrating its popular ERwin Data Modeler with Visual Studio 2005 Team Edition for Database Professionals, CA is helping customers further streamline their development processes, reduce design defects and assure the proper business alignment of their critical applications."

Additionally, with Erwin DM r7.2, you can migrate existing SQL Server schemas to help quickly deploy Visual Studio projects. Managed objects in DM r7.2 can be reverse engineered from Visual Studio into Erwin DM r7.2 to create the following:

  • Meta data visualizations
  • Integration
  • Reporting

This release also delivers full native support for SQL Server 2005 relational syntax and supports the following databases:

  • MySQL
  • DB2
  • UDB
  • V9
  • Sybase IQ

Let’s go over some of the new features included in ERwin DM r7.2. They are as follows:

  • User Interface (UI) enhancements
  • Alter script enhancements to support SQL Server 2005 features and functions
  • Schema generation to support SQL Server 2005
  • Model Manager Improvements to allow more control and better growth over data marts
  • Complete Compare Improvements that make it easier to discover, model changes
  • Name Hardening for organizations to properly manage naming standards
  • Global Find and Replace
  • Action Log Filtering enables you to capture all changes made to a model during a modeling session
  • PDF Indexing allows you to navigate large reports that the Erwin DM Report Template Builder can generate in Enterprise environments for sharing model metadata for various stakeholders
  • Manage Logical Volumetric Information
  • Subtype Discriminator UI Change is the compliance and support of IDEF1x modeling specification
  • Improved Drawing Objects that let you graphically represent business rules

According to Danny Sandwell, Product Manager Data Modeling Suite “Enterprise IT organizations are under increased pressure to deliver more sophisticated, high-performance business solutions within their existing resource constraints and to fully minimize the risk of error in their development process.” He goes on to say that “By enabling best practices for model-driven development, the latest release of CA’s ERwin Data Modeler empowers today’s database professionals to meet these technically challenging objectives.”

CA ERwin Data Modeling suite can be licensed individually for small to mid-size companies or through authorized CA resellers such as Programmer's Paradise, Inc. “CA has the technology solutions our customers want and provides support for channel programs that make us both successful,” said Simon Nynens, Chairman and CEO, Wayside Technology Group, Inc. “The CA team is first rate and their products are first class. With CA’s ERwin Data Modeler r7.2 they have again set the bar high for value delivered. We are pleased to work with them closely to provide quality software solutions to the developer community.”

You can also download a copy by browsing to CA Erwin Modeling Suite Support web page at http://ca.com/trials.

About CA

“CA (NYSE: CA), one of the world’s largest information technology (IT) management software companies, unifies and simplifies the management of enterprise-wide IT. Founded in 1976, CA is headquartered in Islandia, N.Y., and serves customers in more than 140 countries. For more information, please visit http://ca.com.”

» See All Articles by Columnist Steven S. Warren



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date