IDERA ER/Studio Valuable Features
AndersonMoura
Data Management Product Owner at ExxonMobil
The data modeling and reverse engineering features are most important to us.
View full review »DK
Reviewer967458
Database Developer at a financial services firm with 1,001-5,000 employees
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.
View full review »MG
Mike Grove
DBA at a consumer goods company with 201-500 employees
One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded.
View full review »Buyer's Guide
Enterprise Architecture Management
April 2024
Find out what your peers are saying about IDERA, erwin by Quest , SAP and others in Enterprise Architecture Management. Updated: April 2024.
767,847 professionals have used our research since 2012.
RK
DataArchd5df
Asst. Director, Data Management & Analytics at a healthcare company with 10,001+ employees
The engineering portion, developing new models, dimensional models, not relational models. For the data we're hosting, dimensional modeling is more useful.
View full review »SV
reviewer1429329
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
The feature that we like best is the model publishing.
The web interface allows everybody to view models that are stored on the team server.
View full review »CL
VpDataInd01c
Database Designer at a manufacturing company with 1,001-5,000 employees
The ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used.
The Repository, as well. We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the Repository enables us to share the models, and keep track of what everybody is working on.
View full review »JV
Jamie Vasser
IT Specialist at a government with 10,001+ employees
The most valuable feature is data modeling, primarily, because it's something that has been lacking in our systems development for 20 years. There was no accountability for data structure.
View full review »PS
DataArchadd7
Data Architect at a computer software company with 1,001-5,000 employees
- Easy to model.
- Has a user-friendly interface.
- I like the team portal because, once we upload, the entire team can see the model.
LW
Larry Wilson
Data Architect at a insurance company with 1,001-5,000 employees
- Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch.
- Data lineage tracking: It allows us to identify upstream and downstream systems using data. This allows us to identify downstream impacts of making changes to data in a particular system, before the downstream systems break.
- Collaboration features in Team Server: With discussion threads, email notifications, and streams, we can collaborate with team members to make sure that models and glossaries are sufficiently defined to accurately and concisely reflect the meaning, purpose, etc. of our enterprise data.
- Change management: We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify.
it_user92238
Director at a tech services company with 51-200 employees
Strong graphic and formatting capabilities which can be used to stylize/classify tables of different uses/purposes. Reverse engineering function is useful in examining undocumented legacy databases. Object creation scripting tool has plenty of useful option with the ability to save configuration sets for consistent database builds. Intuitive user interface provides for quick learning curve.
View full review »
FD
reviewer1318779
Data Architect at a pharma/biotech company with 1,001-5,000 employees
The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer.
View full review »MS
Mariya Salamatova
Senior Business Intelligence Developer at a construction company with 501-1,000 employees
The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes.
View full review »it_user324030
Sr. Data Engineer at a computer software company with 501-1,000 employees
There are only a handful of ERD features that I’ve needed over the years that ER/Studio DA didn’t support. It’s flexible, intuitive for the newbie and yet supports the complexity required of a seasoned database designer, and offers a clean sophisticated presentation.
View full review »it_user282783
Database Architect at a healthcare company with 1,001-5,000 employees
The ability to define a set of domain definitions and group them in folders is a valuable feature. There is also a Macro (VB script) feature that allows you to automate many features that can save a lot of time.
View full review »DF
reviewer1477701
Data Architect at a financial services firm with 501-1,000 employees
It does the job. However, it doesn't work as well as other solutions.
View full review »it_user297114
Principal Data Architect at a tech company with 201-500 employees
- Running macros on logical and physical models
- Compare and Merge
it_user277026
Senior Consultant with 501-1,000 employees
Reverse and Forward Engineering are very important. The former provides a facility to generate the overall design from an existing database. The latter allows the user to 'round-trip' changes from the model to a database so as you make changes these result in actual physical changes to the database structure.
View full review »it_user323850
ProQuest Development and Quality Assurance Support at a tech services company with 10,001+ employees
Reverse engineering existing databases. I use the reverse engineering features to map existing databases to understand their structure and make improvements.
View full review »JM
Reviewer951561
Database Administrator at a government with 10,001+ employees
The modeling part of the tool. We use the solution to create data models which describe our company's data architecture. It is a mix of design upfront when we get changes. We also use the data models after we've implemented changes.
It does help in regards to redundancy with standardization across models.
View full review »it_user323538
Associate Director, Enterprise Data Management, Practice Lead for Life Sciences UK&I at a tech services company with 1,001-5,000 employees
- Centralised Repository where all the models are stored
- TeamServer (Portal) which gives access to the models (read only) through a web browser
- Entity Llinking Ability across data models
- Reuse of objects within workspace on multiple diagrams
it_user277956
Senior SQL Server Developer at a tech vendor with 201-500 employees
- Reverse engineering physical database
- Compare and Merge utility
it_user341061
Business Intelligence Analyst DBA at a government with 1,001-5,000 employees
Being able to to perform reverse engineering is valuable to us.
View full review »it_user91548
Infrastructure Expert at a tech services company with 1,001-5,000 employees
- Flexible and complete compare/merge facility
- Exposure of its automation object model which allows custom programming outside of the product
it_user275646
Senior Consultant with 51-200 employees
- Ease of use
- It looks good enough
- Ability to create HTML reports
- Ability to compare the model against the database
JC
Database9ac8
Database Administrator at a healthcare company with 1,001-5,000 employees
The reverse engineering is the most important feature. The relationships are also important.
View full review »MP
DBA8d65
DBA at a consultancy with 501-1,000 employees
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.
View full review »it_user285069
Data Management Specialist at a government with 1,001-5,000 employees
- Repository > Diagrams
- Security > Security Center
- Tools > Generate Reports
- Entity > Notes
- Attribute > Notes
it_user738693
Administrador de Dados at a non-tech company with 5,001-10,000 employees
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.
View full review »Buyer's Guide
Enterprise Architecture Management
April 2024
Find out what your peers are saying about IDERA, erwin by Quest , SAP and others in Enterprise Architecture Management. Updated: April 2024.
767,847 professionals have used our research since 2012.
Buyer's Guide
Download our free Enterprise Architecture Management Report and find out what your peers are saying about IDERA, erwin by Quest , SAP, and more!
Updated: April 2024
Popular Comparisons
Sparx Systems Enterprise Architect
erwin Data Modeler by Quest
MEGA HOPEX
SAP PowerDesigner
iServer
BiZZdesign HoriZZon
Avolution ABACUS
Quest Foglight for Databases
Redgate SQL Toolbelt
erwin Evolve by Quest
Toad Data Modeler
IBM Rational System Architect
Informatica Persistent Data Masking
Aqua Data Studio
Buyer's Guide
Download our free Enterprise Architecture Management Report and find out what your peers are saying about IDERA, erwin by Quest , SAP, and more!
Quick Links
Learn More:
- Primary Use Case
- Valuable Features
- Room for Improvement
- Customer Service and Support
- Initial Setup
- ROI
- Pricing
- Other Advice
- 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.
