We performed a comparison between erwin Data Modeler by Quest and OrbusInfinity based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The data lineage feature is very valuable."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"The most valuable features are mainly the reporting side of things and the dashboard."
"I like the integration with the Office tools such as Visio and Excel. The integration with Excel helped us to be able to upload data very easily. Integration with Visio helps us to be able to make changes once and have a centralized diagram. We don't have versions of the diagram. This integration with the Office tools is very useful."
"We can only get licenses through partners."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"I would like the solution to be less rigid in terms of its theory."
"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"We found a few issues with importing data and all the manipulation of data, especially when it came to the BI side of things because it utilized a particular template to be able to get certain reports. The user administrators could not manipulate it to get the right reports."
"The refresh cycles for our dashboards could be better. I keep complaining about that. The refresh is supposed to be once a day, but I would love it if it was real-time so that if I make a change to the data in iServer, I should see those changes immediately reflected in the dashboards. They use Power BI, and it seems they've scheduled their refresh to be once a day, which is not that good for us."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while OrbusInfinity is ranked 16th in Enterprise Architecture Management with 2 reviews. erwin Data Modeler by Quest is rated 8.6, while OrbusInfinity is rated 8.0. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of OrbusInfinity writes "Cost-effective, integrates with the Office tools, and allows us to articulate all entities across the enterprise on one platform". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and Sparx Systems Enterprise Architect, whereas OrbusInfinity is most compared with Ardoq, iServer, LeanIX and ServiceNow. See our OrbusInfinity vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors.
We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.