We use it for data modeling. It is the way we communicate requirements, both for gathering and presenting them. We also use it for putting together our metadata and publishing it.
Enables us to audit production, to make sure it matches what we have designed
Pros and Cons
- "The most valuable features are... those that enable me to represent the database to the development community and the business users."
- "It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
What is our primary use case?
How has it helped my organization?
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.
What is most valuable?
The most valuable features are the various features for different databases, but mainly those that enable me to represent the database to the development community and the business users.
What needs improvement?
It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo.
Also, Business Objects doesn't seem to be very stable at the moment, so we've stopped using that.
Buyer's Guide
IDERA ER/Studio
October 2024
Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
For how long have I used the solution?
More than five years.
What do I think about the stability of the solution?
We did not encounter stability issues in the past but lately, since they're undergoing the rewrite of their internal system, there is some stuff creeping in. We've had some stability issues in the last six months.
What do I think about the scalability of the solution?
We haven't had any scalability issues.
How are customer service and support?
Tech support hasn't been as good lately as it was in the past. It is down to "average."
Which solution did I use previously and why did I switch?
Prior to using ER/Studio, there was ERwin in-house, but their tech support was horrible, their product was not very good. This was back in the early 2000s, so we switched over because ER/Studio was more flexible. It was able to reverse-engineer a database in under a minute, versus ERwin, which was taking over an hour. That performance was a big issue. Also, early on, and other than in the last six months, Idera's tech support was excellent.
What's my experience with pricing, setup cost, and licensing?
I don't know enough about what the pricing is for other choices out there. I've only really worked on this one tool.
Which other solutions did I evaluate?
We looked at PowerDesigner, Oracle's native designer, and ERwin. We only did those three, four including ER/Studio. And this tool was, by far, at the time, the better one. Since that time, and now that we have more people in-house, ERwin, evidently, now has more features. I can't confirm or deny that, I don't know because I have never used ERwin. But, at the time, back in 2004, there was a big difference.
What other advice do I have?
I really like ER/Studio personally, so for me, it's a nine out of 10. I like it because it doesn't let you make stupid mistakes - and it's easy to make a stupid mistake. The tool can save you a lot of trouble. The only other tool I used before this was Oracle Designer, back in the 90s. This is way better than that. I haven't used anything else, so I'm a loyal customer.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Data Management Specialist at a government with 1,001-5,000 employees
Data Dictionary Bindings is not very intuitive, but there are no stability issues.
What is most valuable?
- Repository > Diagrams
- Security > Security Center
- Tools > Generate Reports
- Entity > Notes
- Attribute > Notes
What needs improvement?
- Diagram Versioning is not very intuitive
- Data Dictionary Bindings is not very intuitive
For how long have I used the solution?
I've used it for three years.
What was my experience with deployment of the solution?
No issues encountered.
What do I think about the stability of the solution?
Not with the current release.
How are customer service and technical support?
Customer Service:
It's good.
Technical Support:It's good.
Which solution did I use previously and why did I switch?
I have personally used many modelling tools. My current company standardized on this one.
What about the implementation team?
We used a vendor team who were good.
What was our ROI?
None the enterprise does not utilize all its capabilities thus, much of the work done is ported to other tools.
What other advice do I have?
If using this tool to support a large team effort, get training for versioning
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
IDERA ER/Studio
October 2024
Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
Administrador de Dados at a non-tech company with 5,001-10,000 employees
Enables creation of multiple automations, improving security and centralization
Pros and Cons
- "This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
- "Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
What is most valuable?
This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process.
How has it helped my organization?
Organization, security, centralization.
What needs improvement?
The product is pricey.
For how long have I used the solution?
About four years.
What do I think about the stability of the solution?
Sometimes our version is a little unstable. But I think this problem occurs because our version is old. We are in the migration process to the current version.
What do I think about the scalability of the solution?
No.
How are customer service and technical support?
Very good. When we need, they respond to us quickly.
Which solution did I use previously and why did I switch?
I didn’t use other solutions in my work, only in tests.
How was the initial setup?
A support member in my company helped with the initial installation.
What's my experience with pricing, setup cost, and licensing?
The product can have a high price.
Which other solutions did I evaluate?
Yes. erwin and ePower.
What other advice do I have?
Talk with other people before purchasing to learn about their experience with the product.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free IDERA ER/Studio Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Popular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Sparx Systems Enterprise Architect
erwin Data Modeler by Quest
SAP PowerDesigner
iServer
BiZZdesign HoriZZon
Avolution ABACUS
Quest Foglight for Databases
Redgate SQL Toolbelt
erwin Evolve by Quest
IBM Rational System Architect
Toad Data Modeler
Oracle Coherence
Aqua Data Studio
Buyer's Guide
Download our free IDERA ER/Studio Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Can you recommend a graphic illustration tool to model the architecture of IT systems?
- When evaluating Architecture Management, what aspect do you think is the most important to look for?
- Tools to Develop and Manage IT Infrastructure Road-maps
- Sparx system comparing with ARIS and IBM blueworks.
- What EA tool would you advise us to use?
- What are some business benefits associated with enterprise architecture?
- Any experience on newer/low-cost cloud based EA Modelling Tools?
- How to model an enterprise architecture? What tools and templates can I use?
- How to export IBM Rational System Architect data into Alfabet Enterprise Architecture Management (by Software AG)?
- Reading meta-data off local ERwin model.