I always work in big corporations, and what I do is relatively small, it's enhancements. The company that I work for has many products and this is just one of them. 

The main benefit is that you can do things fast with it and that's very important. It helps reduce the overall time and meet the deadlines.

Also, IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool.

View full review »

When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders.

View full review »

When I need a new model, first I determine the sources that should be used, the source database. With a little effort, I create a target table from the source import. The tool then creates the DDL creating the table, the actual physical database.

View full review »

Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface. Essentially, it has helped a lot because we have everything in one place

View full review »

We were using ERwin before we used ER/Studio. I've been doing data modeling for well over 20 years. Converting from one to the other at the time, ER/Studio was more sophisticated, gave us better functionality, and was more reliable. 

View full review »

We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution.

View full review »

Before this tool, just managing the changes and publishing the models to the users became very cumbersome. This tool has simplified our day-to-day tasks a lot.

View full review »

We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases. We have been able to then modify those models, breaking them down to make them more understandable. Loading these models into the ER/Studio Team Server repository, it allows us to disseminate this information to the entire enterprise. 

Team Server allows us to further define those models through the use of glossaries and gives us the ability to collaborate as a data governance team to ensure that terms defined provide us a common understanding of our data. We are also able to document the data lineage and data flows of our data from one system to another.

View full review »

Our company designs and builds databases in ER/Studio before other database builds or other development. This provides for identifying potential issues long before any code has been written. Data models are often the basis for functionality discussions between the business, analysts, and developers. View full review »

It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time.

View full review »

The work of the database architect is complex. ER/Studio DA supports in a single application everything from taxonomy and data dictionary definitions to conceptual, logical, and physical data models, relational and dimensional models, reverse engineering from legacy database structures, merging and comparison between database versions, exporting of ERD images and data dictionaries and DDL from physical data models, and it does so at a reasonable price point for such a polished and feature-rich offering.

View full review »

I am able to create (and publish) logical data models, apply naming standards using macro, generate the physical models and DDL. This makes the development process consistent and clean, improves communication and quality.

View full review »

It allows for maintaining a data dictionary, to enforce naming standards, and has a built-in macro facility to make it easier to do complicated, repetitive tasks quickly and easily.

View full review »

One example is the use of the product to make extracts and split databases, and we were selling parts of the company to other regions of other companies. It made the process more efficient and faster and less costly.

View full review »

We have gone from having no diagrams to 50 submodels that we have been able to share with team members and even with our clients.

View full review »

The organisation is a huge enterprise spread across various countries, and use ER Studio as a centralised documentation of systems/application architecture repository. This has helped the new application development team in cross-verifying, and understanding, the current setup, proposing and architecting new solutions for the organisation. Since the models are stored in a centralised repository, the process of review/refinement are handled by teams all over the world, who can now collaborate and build a common solution.

View full review »

We have offshore developers/DBA who actively request/implement DDL changes vs. a development database. The changes are reversed-engineered into both logical and physical schemas with generated DDL for source control check-in/check-out and other environment synchronization. With both onshore and offshore development teams working 18x5 days, it is an easy way to control check-in's while also maintaining schema views.

View full review »

I used the tool for data modeling, so I cannot say much.

View full review »

It has been our primary means of publishing data models for years. It also houses our product data dictionary, and generates all the DDLs for database modifications.

View full review »

The developers can see the relationships now.

View full review »

There are a lot of different ways we use the tool. One of the ways is that we do auditing of what's been billed to production to make sure it matches what we have designed. And it has also improved things in that we have design requirements for the DBA.

Because of all the various things we use it for, it has a high value within the organization.

View full review »

Organization, security, centralization.

View full review »