We use it for data modeling.
IDERA ER/Studio provides advanced data modeling and reverse engineering capabilities, supporting collaboration via a centralized repository. Its intuitive interface and extensive automation options enhance teamwork and data governance for complex database structures.
| Author info | Rating | Review Summary |
|---|---|---|
| Database Developer at a financial services firm with 1,001-5,000 employees | 4.5 | I highly recommend IDERA ER/Studio. Its fast, reliable, and up-to-date data modeling helps me meet deadlines and it supports new SQL Server features. Customer service is good. I’ve used it for years with no complaints. |
We use it for data modeling.
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.
The data modeling module is important to me because I am a database developer and designer. I also take part in designing applications and that always starts with data modeling. It's very fast, reliable, up-to-date, so easy to use, smooth.
The solution is also easy to explain to others and the graphics are good. Finally, the menu choices are also important. There are a lot of them and they are good.
I've not encountered any issues with its stability.
I haven't tested the scalability. I have hundreds of tables, but if you have thousands of tables I don't know how it would work.
The only thing I had an issue with was licensing, and the support was very good. They replied very quickly and it was very smooth.
A long time ago I use erwin. I switched at that time because it became too complicated to use. But that was a long time ago.
No issues with the initial setup.
It is priced fairly. It's around the same as erwin and other competitors' costs.
I evaluated Microsoft Visio.
I would recommend IDERA ER/Studio, but people in my profession are divided by their loyalties. I am loyal to this product, but if you talk to another developer who has been using erwin all his life, that person might say, "Hey, erwin is better." I say ER/Studio is good but in the world of developers, people still have to evaluate things for themselves.
I have no complaints. That's why I've been using it for so long. I rate it a nine out of ten. It's easy and fast to use.
| Product | Mindshare (%) |
|---|---|
| IDERA ER/Studio | 3.0% |
| SAP PowerDesigner | 9.1% |
| Sparx Systems Enterprise Architect | 8.7% |
| Other | 79.2% |
| Company Size | Count |
|---|---|
| Small Business | 2 |
| Midsize Enterprise | 11 |
| Large Enterprise | 23 |
| Company Size | Count |
|---|---|
| Small Business | 163 |
| Midsize Enterprise | 68 |
| Large Enterprise | 194 |
IDERA ER/Studio is a comprehensive platform for data modeling, database design, and reverse engineering. It plays a key role in building data governance programs and managing enterprise models. The tool integrates well with cloud environments, supporting data warehouses and facilitating access through web portals. Despite strengths, improvements in deployment, licensing, and documentation, as well as repository performance and interface updates, are needed. Enhanced debugging features, network performance, and better handling of large databases, along with Active Directory integration, are also areas for development.
What are the critical features of IDERA ER/Studio?IDERA ER/Studio is widely used across industries for its capability to design and maintain complex databases. In sectors like finance and healthcare, it plays a critical role in creating central repositories, supporting data warehouses, and ensuring effective communication of requirements. Its web portals enhance access and improve metadata management, making it a preferred choice for managing numerous tables and dependencies in large datasets.
IDERA ER/Studio was previously known as IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition.
Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo