Migrating from CA ERwin to InfoSphere Data Architect

If you've had experience with CA ERwin Data Modeler and now are starting to learn InfoSphere Data Architect, this paper will speed up your model migration process and ease your learning process of the new environment. You will learn the differences between the two design environments, and you'll also learn a set of best practices for using features of InfoSphere Data Architect that will put you on the fast track of working productively in InfoSphere Data Architect.

Norma Mullin (norma.mullin@us.ibm.com), Consulting IT Specialist, IBM

Norma Mullin photoNorma Mullin is a consulting IT specialist in the Sales and Distribution Division supporting IBM Information Management products. Prior to this role, she worked for over 20 years as a lead data architect and application architect for the IBM Global Services organization, designing, developing, and implementing enterprise and application-specific architectures and data models for multiple IBM customers. She has over 26 years of experience in the IT industry with the last 20 years focused on enterprise systems integration with emphasis on data and application architectures. Norma also has extensive experience with database performance measurements, conversion, and migration projects.



Seeling Cheung (cheungs@us.ibm.com), Enablement Architect, IBM

Seeling Cheung photoSeeling Cheung is an enablement architect from the IBM Integrated Data Management team at IBM Silicon Valley Lab in San Jose, CA. She spends much of her time with customers and business partners helping them build solutions around the numerous integrated data management products. Previously, Seeling held other advanced technical positions, including development responsibilities for the federation technology and the pureXML capabilities on the Distributed DB2 database team. She joined IBM after finishing her Masters degree in Computer Sciences and working a couple years at Oracle.



07 October 2010 (First published 02 April 2009)

If you've had experience with CA ERwin Data Modeler and now are starting to learn IBM® InfoSphere™ Data Architect, this paper will speed up your model migration process and ease your learning process of the new environment. You will learn the differences between the two design environments, and you'll also learn a set of best practices for using features of InfoSphere Data Architect that will put you on the fast track of working productively in InfoSphere Data Architect.

[07 Oct 2010: This article has been updated to include information about the 7.5.3 release of IDA, including the comprehensive comparison filter options and the enhanced import with DDL script for IBM DB2 data servers. In addition, the article has been extended to include more post-migration best practices such as domain object reuse.--Ed.]

IBM InfoSphere Data Architect is a collaborative data design solution to discover, model, relate, and standardize diverse and distributed data assets. This product used to be known as Rational Data Architect, and many of the existing materials on the Web still refer to this name.

Some of the best practices recommended for the migration process include:

  • Models that contain entities related to different subject areas in ERwin should be organized into smaller packages (subpackages) in InfoSphere Data Architect.
  • Models that are large or would be shared and changed by multiple people in a team environment in ERwin should be partitioned into submodels in InfoSphere Data Architect. This offers the benefits of team collaboration, less consumption of system resources, and improvement of model performance.
  • Models that have more than one package (such as more than one subject area) in ERwin should use the unique InfoSphere Data Architect navigation diagrams to quickly traverse from one diagram to another.

Acknowledgment

The authors would like to thank Joe Cullen, Principal Consultant from Dimension Software Consulting Inc. for providing valuable information in converting ERwin domains to IDA Domain Models.

Download

DescriptionNameSize
Article in PDF formatERwin_to_InfoSphere_migration_guide2.pdf1.4MB

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=379736
SummaryTitle=Migrating from CA ERwin to InfoSphere Data Architect
publish-date=10072010