Reviews (1-5 of 5)
December 10, 2018
An intuitive design interface and capabilities supporting everyone from business users to technical architects make this data modelling tool stand out in the crowd
Score 8 out of 10
ER Studio Data Architect is a premiere choice tool for managing data models, data domains, and business glossaries across the organization. It's ease of use both to learn and to master make enforcing data modelling standards across the enterprise a simple task. We use ER Studio Data Architect to manage physical model naming standards (especially in sensitive and sometimes ambiguous shorthand naming conventions within hospital settings) as well as all data models within the organization. Its ability to import ETL mappings and manage data lineage is a powerful, overlooked feature that shined through where the ETL offering did not (we opted to use Data Architect over Informatica's Meta Data Management offering due to overhead and performance).
- It is a great tool for developing, managing, and maintaining data models at both the logical and physical level (I still do whiteboard drawings for conceptual although conceptual modelling is a capability of the team edition and above I believe)
- The naming conventions template greatly reduces physical modelling time as you can concentrate on logical naming conventions, and then publish your physical model by pushing it through the naming standards
- The ability to interpret ETL mappings goes a great way in providing data lineage to the business. This is often overlooked in organizations in favor of immediate gratification through reporting, then having to eventually rework due to auditing or other issues that may expose where corners were cut
- Relationships are a bit on the weaker side. Many times I found orphaned relationships that I could not get rid of, or additional columns that were automatically created during the push to the physical model that appear to be due to key constraint bugs
- There are a lot of bugs introduced when merging keys. I tend to model 2 tables for example logically, establish the relationship, and then merge the additional key column that is automatically created when establishing the relationship. This sometimes causes downstream issues with the physical model (creating duplicate columns with _1 appended)
- Meta-data could be improved. I find it hard to keep descriptions and other meta information clean when copying and pasting from other sources due to formatting tags being introduced on each object (font, size, color, etc.). The attachment feature comes in handy, however I am looking for the ability to cleanly document and map multiple sources to a single target while providing searchability and traceability
Read Jody Gitchel's full review
Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms
June 21, 2017
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.
Read Michael Romm's full review
ER/Studio is great for both logical and physical layers of database modeling. It does not support conceptual data modeling though. It should be used in both transactional and warehouse modeling. It is useful for enforcing database naming conventions, good design practices and comprehensive reporting on database models, including publishing the models for the wider team.
April 08, 2016
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.
Read Praveena Amancha's full review
ER/Studio can be used for any type of scenarios, either to develop an ER model or a dimension model.
October 07, 2015
Score 9 out of 10
We use ER/Studio within our data modeling team here at UConn Health. I'm the lead data modeler and I'm responsible for the maintenance and administration of the ER\Studio application and repository. We use it for our application databases (3NF) and data warehouse database (Dimensional) designs. I've found it to be a very useful tool and makes creating the physical database as easy as a few clicks of a button. Of course there is effort in doing the analysis and creating the conceptual and logical models but writing DDL is a thing of the past with ER\Studio.
- ER\Studio supports the concept of a domain. You can create a custom domain (data type) and give it a name and use it as the data type for attributes. I use this to define my surrogate PK and several other "standard" attributes we populate into every relation (table).
- ER\Studio supports the coding of Macros. This is VB code that leverages their API to automate manual process. Very helpful as you could imagine. They supply a large set of pre-canned macros and are very good about helping you write your own if you need help. I have several macros that help me implement naming conventions on attributes and FK names.
- The repository is a handy feature that allows you to save off your models to a database to be safe and also to allow for collaboration between other modelers on you team.
- Several different licensing models allow for flexibility, usage. They support a single user workstation as well as concurrent licensing, for multiple part time users.
- ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
- The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
- A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.
Read Jay Coppola's full review
It's a data modeling tool that will generate the DDL for your database, so you need to know your target database system (SQL Server Oracle, DB2).
They have single target versions and multiple target versions. The multiple target includes just about every conceivable DBMS including XML.
April 11, 2017
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.
Read this authenticated review
ER/Studio is great for providing data model images for teammates to use when they are not data modelers.
ER/Studio Data Architect Scorecard Summary
About ER/Studio Data Architect
ER/Studio Enterprise Team Edition is a powerful business-driven data architecture solution that combines multi-platform data modeling, design, and reporting with cross-organizational team collaboration for enterprises of all sizes. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between business and IT. Business stakeholders can participate in the metadata definition workflow and access information on models and metadata at the right level for their needs. Data professionals and business stakeholders who want to establish a solid foundation for data governance across the enterprise choose ER/Studio.
ER/Studio Data Architect Competitors
ER/Studio Data Architect Technical Details