TrustRadius Insights
ER/Studio is highly regarded for its ability to simplify the process of designing logical and physical ER data models compared to other …
Starting at $1,470.40 one-time fee per user
View PricingOverview
What is ER/Studio Data Architect?
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
Recent Reviews
Pricing
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://store.idera.com/buynow/onlinest…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $1,470.40 one-time fee per user
Product Demos
Governing data with ER/Studio Data Architect
YouTube
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is ER/Studio Data Architect?
ER/Studio Data Architect is a data architecture and database design software. It is compatible with multiple database platforms. The tool is used to create and manage database designs, as well as to document and reuse data assets. It aims to enable companies to create and maintain entity relationship diagrams with detailed metadata.
ER/Studio Data Architect offers several benefits, including:
Round-trip database support: Data architects can reverse-engineer, analyze, and optimize existing databases from diverse platforms. Such platforms include relational and NoSQL data sources.
Collaborate and share: Multiple users can collaborate and share data assets across modeling projects in the model repository.
Design a business-driven enterprise data architecture: ER/Studio Data Architect enables companies to design a data architecture that is aligned with their business needs.
Enforce organizational standards: The tool enforces organizational standards in data modeling throughout the organization.
Manage hierarchical models such as JSON, MongoDB, Google BigQuery in the same way and graphical user interface as relational models.
ER/Studio Data Architect is designed for a variety of professionals who are involved in data modeling, database design, and data management. These professionals include:
Data architects can use ER/Studio Data Architect to create and maintain entity relationship diagrams, as well as to document and reuse data assets.
Database administrators can use the tool to reverse-engineer, analyze, and optimize existing databases, ensuring optimal performance and compliance with organizational standards.
Data analysts can use ER/Studio Data Architect to understand and analyze data structures, relationships, and metadata across different data sources.
Data modelers can leverage the tool to design and maintain logical and physical data models for various database platforms.
Developers can use ER/Studio Data Architect to generate and change database schema scripts, ensuring consistency between the data model and the actual database.
Business analysts can use the tool to understand and document business requirements and data needs, facilitating better collaboration between business and information technology teams.
The top use cases of ER/Studio Data Architect are:
Analyze and design platform-independent logical data architecture.
Design and construct platform-specific physical databases.
Build and maintain large, complex database applications.
Consolidate, report, and re-use metadata across the enterprise.
Describe information requirements and technical design of data assets.
Understand and design data assets in a universal way without having to understand code.
Control how changes in requirements are implemented.
Allow data architects to support a data governance program.
The top strengths of ER/Studio Data Architect are:
Broad range of database platform support.
Enterprise-level capabilities.
Visual data lineage and flow modeling.
Full dimensional modeling for data warehousing and business intelligence.
Business data objects to bridge the gap between developers and data architects.
Agile change management, nested submodels, and universal mappings.
Superior compare and merge.
Built-in business glossary.
Rich macros supported by full programming language.
ER/Studio Data Architect Features
- Supported: Builds out an enterprise data model as entity relationship diagrams (ERD)
- Supported: Creates a data catalog to support data governance initiatives, and metadata management
- Supported: Discovers and documents existing data assets
- Supported: Lays the foundation for robust data governance and data management
ER/Studio Data Architect Screenshots
ER/Studio Data Architect Video
ER/Studio Data Architect Integrations
- Collibra Data Intelligence Cloud
- WhereScape 3D
- Bluemetrix Data Manager
- Silwood Safyr
ER/Studio Data Architect Competitors
ER/Studio Data Architect Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Languages | English |
ER/Studio Data Architect Downloadables
Frequently Asked Questions
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
ER/Studio Data Architect starts at $1470.4.
erwin Data Modeler, IBM InfoSphere Data Architect, and SqlDBM are common alternatives for ER/Studio Data Architect.
The most common users of ER/Studio Data Architect are from Mid-sized Companies (51-1,000 employees).
Comparisons
Compare with
Reviews and Ratings
(11)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Recommendations
ER/Studio is highly regarded for its ability to simplify the process of designing logical and physical ER data models compared to other tools on the market. Users have found that the integrated tool 'Team server' allows for easy access to the storage repository of models for a wider audience, including both technical and business teams. With ER/Studio, generating DDLs to create a physical layer has become much more efficient, minimizing data engineering work. Additionally, exporting models is a breeze, enabling users to effortlessly generate schema reports and database creation scripts.
Another notable use case of ER/Studio is in the design of supply chain ETL data models and mapping, which has proven instrumental in avoiding potential performance issues. Moreover, creating various diagrams like business process models, context diagrams, and data flow diagrams has been made easier with ER/Studio, aiding in the identification of flows that can be automated. The tool's interface also facilitates the design of logical models after discussions with the business, providing a pictorial view of different schemas that is easy to understand.
ER/Studio goes beyond data modeling and supports important aspects such as data lineage and data governance. It helps capture and record true business requirements while transforming them into a cohesive database design. For data modeling teams working on application databases and data warehouse designs, ER/Studio simplifies the process by providing consistent naming standards and an intuitive user experience. The tool's capabilities extend to managing physical model naming standards and all data models within an organization.
Importing ETL mappings and managing data lineage are powerful features that users find particularly valuable. Whether it's logical modeling or physical modeling for OLTP or data warehouses, ER/Studio enables users to make incremental changes seamlessly. Its ability to maintain consistent naming standards further solidifies its reputation as one of the best data modeling tools available.
In terms of usability, ER/Studio stands out as user-friendly, easy to learn, and efficient. It caters to both small departments and large organizations, providing a consistent methodology for database standards and needs. Furthermore, IT teams can generate data model images, facilitating communication and collaboration across different teams within an organization. With its robust features and user-friendly interface, ER/Studio has become the go-to solution for many businesses looking to manage their data models effectively.
Users have made several recommendations for the software based on their experiences and needs. The most common recommendations are as follows:
Consider the importance of metadata: Users advise considering the significance of metadata in data modeling tools. They suggest paying for a quality tool to ensure higher quality database designs.
Get proper training: Users highlight the importance of receiving proper training to effectively use the software. This recommendation emphasizes that training can enhance users' understanding of its features and functionalities, enabling them to maximize its potential.
Verify compatibility with specific databases: While users appreciate that the software supports a variety of databases and is platform independent, they suggest checking compatibility with specific databases before use. This recommendation encourages users to ensure that their preferred databases are compatible with the software to avoid any potential issues or limitations during their data modeling process.
These recommendations provide valuable insights into the software's strengths, such as its versatility and ease of use, while also highlighting areas where improvements could be made, such as the addition of an API and automated features like data lineage and database entity import.
Attribute Ratings
Reviews
(1-3 of 3)Companies can't remove reviews or game the system. Here's why
ER/Studio is used by my team and possibly by some other teams. I use it for logical and physical modeling of databases, both OLTP and data warehouses, as well as for applying incremental changes to the databases (deployments). I also use it to maintain consistent naming standards.
- ER/Studio is great for dividing logical and physical design. A logical model can be used with different physical platforms.
- Studio can a useful macro capability that allows me to apply the naming standards across the model with ease and consistency.
- ER/Studio does a very good job at comparing the model with the actual database and generating DDL scripts for production deployments.
- ER/Studio has an excellent reporting and model publishing capabilities allowing me to produce models in the HTML format and publish them for the team as needed.
- We recently moved to using AWS Redshift as our data warehousing platform. ER/Studio does not support Redshift.
- ER/Studio does not support conceptual data modeling.
- Increased quality of the data models.
- Increased productivity in data modeling and database development.
- Ability to share the models with the team.
- aqua, Toad Data Modeler and Visio
ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.
April 11, 2017
Visually manage your data models
We have a small department, so I am the sole user of ER/Studio Data Architect. I use it to do all database schema changes throughout the department for all databases we have created. ER/Studio is able to provide us a consistent methodology from a database standards and needs perspective. I'm also able to generate data model images for the IT team to use.
- ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
- ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
- My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.
- ER/Studio are missing some functionality for SQL Server databases. Indexes can have WHERE statements for filtered indexes. This is not supported.
- The Include statement of an index will start with a comma which breaks the index during deployment.
- New versions need to have better regression testing. I've had versions where features no longer were included, like owners, which are very important in SQL Server. (This feature is in the current version thank goodness.)
- Datatype datetime2 is not supported in domains, so custom macros need to be used to apply to fields using domains.
- A new feature that would be great, would be to have ER/Studio generate an HTML document that creates a searchable image of the data model for team members who don't use ER/Studio. This would be very helpful for large data models.
- New feature: Provide the ability to rollback the deployment script. If it fails, you are currently left in a half way state.
- New feature: Provide a clean way to delete the temporary tables in the database. Right now, I have to run a SQL Script to delete all the objects left in my database.
- The business doesn't know that we use it. I'm the only one that finds it a necessity. It's a necessity because I'm a visual person. It's easier to maintain proper foreign key and primary key indexes, especially when teammates inadvertently delete them.
ER/Studio was difficult to learn at the beginning, but that was 7 years ago. I have used it across many companies since then, and It is really easy to use. I found it much easier to learn than Erwin as well.
April 08, 2016
ER Studio is the best Data Modeling tool
ER/Studio is one of the best data modeling tools available in the market. We use it in most of our projects to develop logical and physical data models. ER/Studio comes with a bunch of inbuilt macros and also we can create our own. Macros aid in maintaining consistency with naming standards across the data models, creating indexes etc. Also, ER/Studio doesn't need a lot of prior training to use the tool. The tool is very user friendly, easy to use and very efficient.
- Creating macros.
- Being able to merge the new DDLs to the existing database tables and make selection of only those you want to overwrite/merge/add.
- Easy to convert from logical to physical.
- ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.
ER/Studio is effective and serves the purpose of data modeling that we need in our project, so we chose it.