ER/Studio Data Architect Features

• Build a Business-driven Data Architecture - Data professionals need to ensure that everyone in the organization understands what the data is and can explain it in business terms. ER/Studio Data Architect provides an easy-to-use visual interface for data modeling professionals to document, understand, and publish information about data models and databases so they can support business objectives.
• Reduce Redundancy - Import and reverse-engineer content from multiple data sources into logical and physical data models, and integrate the elements into reusable constructs with an enterprise data dictionary. Easily compare and merge differences between data models and databases to reconcile changes. Leverage rich text editing along with relationship font and color inheritance to enhance model content and appearance.
• Improve Data Consistency and Quality - Assign a naming standards template to your model, submodel, entities, and attributes. Those naming standards will be applied automatically between the logical and physical models, simplifying the data modeling process and ensuring consistency between models. With Data Architect Professional, you can also integrate model elements into reusable constructs via a built-in enterprise data dictionary.
• Share and Manage Enterprise Data Models - The multi-level design layers in ER/Studio Data Architect allow for the accurate visualization of data. Manage data model version control and share data assets in the repository included with Data Architect Professional. Create and track tasks and view changes to data models aligned to agile development methodologies.
• Enhance Data Lineage - Universal mappings provide links between instances of the same concept across models and databases to enhance traceability, and data lineage diagrams show the source, target, and transformation details for connections between databases, models, metadata, and data sources. Organizations can obtain a clear understanding of where their data originated, where it is used, and what the data actually means.
• Extract and Integrate Complex Metadata - If you are working with ERP or CRM software such as SAP and Salesforce and wish to integrate the source metadata into your data models, IDERA offers Safyr solutions to handle this quickly. Safyr analyzes the complex structures of these applications, extracts important metadata from ERP, CRM and other enterprise applications, and exports it into a model file that can be brought into ER/Studio Data Architect.
• Merits of the Model Repository - The Model Repository for ER/Studio Data Architect Professional provides modelers with real-time collaboration features for sharing and re-using assets across data modeling projects. ER/Studio Data Architect users can connect to the same repository to work on models simultaneously and leverage features including an enterprise data dictionary (EDD), version control, and change management.