A data design solution that enables you to discover, model, relate, standardize and integrate diverse and distributed data assets throughout the enterprise
Overview
Improve productivity, data governance and business alignment
IBM InfoSphere® Data Architect is a collaborative data modeling and design solution that accelerates integration projects for business intelligence, master data management and SOA initiatives. It aligns processes, services, applications and data.
Features
Design, govern and align enterprise data assets
- Data querying
- Data modeling
- Constant mappings
- Source control management
- Product integration
Native data querying
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, it explores the 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.
Logical and physical data modeling
Create logical data models that describe how your organization wants to collect data and how data objects are related to each other. You can then transform to a new physical data model, or reverse engineer from an existing source. Use the physical data model to model how data should be stored.
Import and export of constant mappings
Import and export constant mappings within mapping models through the import/export Mapping Model Wizard. Save mappings to CSV files for easier management, sharing and reuse across projects. Streamline updates, maintain consistency and simplify the exchange of mapping definitions between teams and environments.
Source control management
Manage version-controlled data modeling projects with support for Git and Microsoft Team Foundation Server (TFS). Track changes, collaborate across teams, maintain model history and streamline development workflows. Integrated source control capabilities help improve governance, consistency and coordination throughout the data design lifecycle.
Integration with related products
InfoSphere Data Architect allows you to create models for IBM Db2®, IBM Informix®, Oracle, Sybase, Microsoft SQL Server, MySQL and Teradata source systems. Elements from logical and physical data models can be visually represented in diagrams using Information Engineering (IE) notation. It can also provide greater integration with Rational Team Concert and shell share with the latest IBM Rational® products, with IBM Data Studio and IBM InfoSphere Optim™ Query Workload Tuner.
Use cases
Turn data designs into business value
Accelerate data initiatives with capabilities that simplify development, improve collaboration and support faster delivery. Modeling, design and governance tools help teams create trusted data foundations while reducing complexity and speeding project outcomes.
Resources
Discover expert resources
Browse release notes and support documentation to deepen your understanding of IBM InfoSphere Data Architect and support informed decision-making.
Flexibly meet your unique requirements—from data integration to data quality and governance