IDERA helps business intelligence (BI) and data warehouse (DW) architects to better design, document, and reuse data elements to create a more structured and standardized BI environment. Our tools improve productivity, reduce data redundancy, improve collaboration, and enhance designs across BI and DW projects.
The ER/Studio suite of modeling tools helps information technology (IT) organizations better manage, define, and reuse standardized data elements when designing data marts and data warehouses. Architects leverage the data dictionary of ER/Studio to enforce global standards with domain inheritance, reusable objects, and automatic updates.
Combined with a server-based model management system, BI/DW teams improve team collaboration, version management, security management, and reduce data redundancy by reusing common components across models.
Designs can also be connected to business glossaries and published to popular data governance tools to support the governance program.
In addition to the built-in reverse-engineering tools, the metadata wizard of ER/Studio allows users to import metadata from over 70 database products, different modeling tools, business intelligence platforms, extract-transform-load (ETL) platforms, and industry-standard exchange formats.
ER/Studio helps users trace data origins by better documenting ETL mappings and how data moves between target and source systems, along with the reasons and timing for data movement.
Models of these data assets and ETL processes can be stored in the model repository, enabling users to share, browse, and report on them effectively.
Create high-quality dimensional star and snowflake schemas for data warehouses, data marts, and online analytical processing (OLAP) to ensure high-performance data access.
With streamlined navigational aids, diagram layout capabilities, and powerful reporting/publishing functions, users can simplify cross-functional collaboration across business units.
Design your data warehouse by building logical data models that focus on information rather than implementation, and let ER/Studio assist in translating requirements into code and managing code changes.
Metadata serves as the critical bond between architectural constructs and BI/DW designers, enabling improved metadata management within the overall infrastructure of data warehouse designs. Business and IT users can leverage ER/Studio Team Server to access and search metadata repositories, object whereabouts, and data usage through web-based queries and reporting.
With ER/Studio Team Server accessible via any web browser, users can perform cross-model and repository-wide searches for data definitions and objects. Business users can find data by browsing glossaries of business terms or consulting a technical data dictionary of assets.
A rich graphical interface enhances the user experience, enabling architects to better integrate metadata into their data warehouse environments.
By sharing metadata effectively, ER/Studio Team Server bridges the gap between business and IT users, fostering collaboration and a unified understanding of data assets. This shared understanding helps drive better decision-making and improves the overall efficiency of data management practices.
ER/Studio Team Server facilitates automation by exporting metadata from data models to WhereScape 3D, which creates warehouse structures and pipelines automatically. This includes integration with schemas like data vaults. When combined with data governance tools, security can be enforced automatically within the warehouse, based on policies defined by data stewards.
Built in intelligence ensures you can focus on requirements whilst the tool handles implementation rules.
The visual data lineage feature documents source and target mapping and sourcing rules.
The enterprise data dictionary feature defines and enforces standard data elements, naming standards, reference values, and other objects across the enterprise.
The dimensional modeling feature models dimensional structures such as star and snowflake schemas for data warehouses, data marts, and online analytical processing (OLAP).
The attachments feature is a structured method for associating external pieces of information with data models.
The capacity planning feature manages row count and growth rates for tables while calculating the future storage requirements of the data warehouse.
The repository feature provides a scalable, server-side model management system that includes model and object version management, security management, and the ability to branch and merge models.
Documented models of source data assets and an overarching logical data model can be passed to WhereScape to drive automated and governed warehouse design and operation.
ER/Studio Team Server reports and shares metadata and data lineage information to key stakeholders.
The metadata wizard imports and exports metadata from a variety of sources, including BI platforms, unified modeling language (UML) and data modeling solutions, extensible markup language (XML) schemas, and common warehouse metamodel (CWM) to create a metadata hub.
The WhereScape suite will take metadata from ER/Studio to drive automation policies that create the warehouse static structures and pipelines..
To experience for yourself how ER/Studio can help you with data modeling for data warehousing and business intelligence, download a free, functional, 14-day trial now.
