DATA ARCHITECT
InfoSphere Data Architect is an enterprise data modeling and integration design tool. InfoSphere Data Architect is a collaborative data design solution that you can use to discover, model, visualize, relate, and standardize diverse and distributed data assets.
• Increase efficiency and reduce time-to-market through increased understanding of current data assets.
• Simplify and accelerate data and integration design for Business Intelligence, Master Data Management and Service Oriented Architecture (SOA) initiatives.
• Leverage data model value across the data lifecycle to promote cross-lifecycle, cross-role and cross-organization collaboration and to align process service, application, and data architecture.
• New! InfoSphere Data Architect support for dimensional modeling! Design dimensional models to reduce development time for InfoSphere Data Warehouse and Cognos BI reporting.
Features and benefits
Businesses today own vast amount of data and decisions are made based on data. The challenge for IT is clear: provide understanding of the data, improve data quality and consistency, and keep data design aligned with business intent and requirements. IBM InfoSphere Data Architect is a collaborative data design solution that helps you discover, model, relate, and standardize diverse and distributed data assets. Building on the comprehensive data modeling capabilities of previous versions, InfoSphere Data Architect further addresses those requirements.
Support for dimensional modeling
• Design logical, physical and dimensional models
• Integrate with Cognos and InfoSphere Warehouse
• Reduce development time of warehouse and business intelligence systems
• Enable fast querying to accelerate business centric reporting
Unlock the mystery of your existing data sources InfoSphere Data Architect discovers the structure of heterogeneous data sources by examining and analyzing the underlying metadata. Using an established Java Database Connectivity (JDBC) connection to the data sources, InfoSphere Data Architect explores their structures using native queries. With the user interface, users can easily browse through the hierarchy of data elements, facilitating an understanding of detailed properties for every element.
Easily develop data models in a heterogeneous data environmentInfoSphere Data Architect can create logical, physical, and domain models for DB2, Informix, Oracle, Sybase, Microsoft SQL Server, MySQL, and Teradata. Elements from logical and physical data models can be visually represented in diagrams using Information Engineering (IE) notation. Alternatively, physical data model diagrams can use the Unified Modeling Language (UML) notation. InfoSphere Data Architect enables data professionals to create physical data models from scratch, from logical models using transformation or from the database using reverse engineering.
Jumpstart integration design projectsUse InfoSphere Data Architect to design business intelligence, master data management, or SOA projects and use with InfoSphere offerings. Use with IBM Industry Models to leverage years of IBM industry experience
Manage iterative changesMost development projects are iterative in nature, so it is important to be able to design incrementally and manage changes and their impact seamlessly. InfoSphere Data Architect allows users to do just that. Impact analysis lists all of the dependencies on the selected data elements. Advanced synchronization technology compares two models, model to database or two databases. Changes can then be promoted within and across data models and data sources. Use with Optim Database Administrator to manage complex DB2 changes and data migrations without disruption.
Implement corporate standardsInfoSphere Data Architect enables architects to define and implement standards that increase data quality and enterprise consistency for naming, meaning, values, relationships, privileges, privacy, and traceability. Define standards once and associate them with diverse models and databases. Built-in, extensible, rules-driven analysis verifies compliance to naming, syntax, normalization, and best practices standards for both models and databases.
Facilitate cross-team alignmentWhether you are working on a small team where each member plays multiple roles or in a large distributed team with clearer delineation of responsibilities, you can use InfoSphere Data Architect as plug-in function to a shared Eclipse instance or share artifacts through standard configuration management repositories like Rational Clear Case or Concurrent Versions System (CVS).
InfoSphere Data Architect supports model-driven design by built-in integration with:
• InfoSphere Business Glossary for sharing enterprise glossaries across business and IT
• Rational RequisitePro for traceability of model artifacts to business requirements
• Telelogic System Architect for linking enterprise and data architecture
• Rational Software Architect for synching up application and information design
• WebSphere Business Modeler for transforming data models to XSDs for business processes
Support data lifecycle managementArchitects, developers, and DBAs can co-install InfoSphere Data Architect with Optim Development Studio and Optim Database Administrator for a seamless design, development, and deployment experience. Define privacy policies once and feed downstream processes to accelerate enterprise consistency in governing data privacy across test environments. InfoSphere Data Architect and Optim Development Studio now both can generate test data specifications for InfoSphere Optim Test Data Management and Data Privacy Solutions that leverage privacy models defined in InfoSphere Data Architect.
Support data lifecycle managementArchitects, developers, and DBAs can co-install InfoSphere Data Architect with Optim Development Studio and Optim Database Administrator for a seamless design, development, and deployment experience. Define privacy policies once and feed downstream processes to accelerate enterprise consistency in governing data privacy across test environments. InfoSphere Data Architect and Optim Development Studio now both can generate test data specifications for InfoSphere Optim Test Data Management and Data Privacy Solutions that leverage privacy models defined in InfoSphere Data Architect.
Import/export for easy transitionInfoSphere Data Architect can import and export models from CA AllFusion ERwin, Sybase PowerDesigner, IBM Rational Rose®, and a wide range of additional metadata sources and targets. Logical and physical data models are supported during this interchange. Or just reverse engineer current models from live database connections.InfoSphere Data Architect provides comprehensive filtering support for model comparison and synchronization. This significant productivity enhancement offers users the ability to efficiently identify and filter detailed differences between elements such as models and database objects.