We performed a comparison between Informatica Enterprise Data Catalog and SAP PowerDesigner based on real PeerSpot user reviews.
Find out in this report how the two Metadata Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar."
"It can automatically connect or associate business terms with various options, providing flexibility beyond general capabilities."
"We can scan anything."
"The product seems stable enough."
"The capability of the tool to scan and capture the metadata from a variety of sources is one of the capabilities that I find most useful. The central repository into which it is going to put that captured metadata is the best."
"Multifeatured and easily scalable data catalog, with good data domain discovery and data profiling features."
"I rate the technical support a ten out of ten."
"The most valuable feature of Informatica Enterprise Data Catalog is it provides clients with a full view of the enterprise data assets. For example, how many data assets they have and who owns them."
"This solution has good tools for big data, where you can manage large and complex databases."
"I mostly work on the conceptual and logical side of things, and I enjoy how easy it is to use."
"The solution is a very pragmatic tool. It's quite easy to use."
"It can automate many routine tasks and save human resources to focus on real problems."
"The most valuable feature of SAP PowerDesigner is the testing of the models, it has the best function. Reverse engineering is very helpful too."
"Has a specific template that's very helpful for importing metadata."
"Provides the flexibility to create logical and conceptual data models."
"I've used the reverse engineering feature a lot. I can take a look at the structure of the database and what relationships it has."
"The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility."
"IEDC can improve the comparison of lineages."
"They have to improve their relationship discovery tool. They say that they have AI inside, but this AI did not automatically find relationships or suggested relationships between entities."
"Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"This solution is hard to set up and its interface is not user-friendly. It's also not as stable, and the technical support takes a lot of time to solve simple problems."
"Currently, there are limitations in processing and the interface."
"The scalability is tough."
"Checking-in models to the repository, especially when working remotely, is a slow process than can sometimes have problems with models being corrupted."
"There should be a better usage of current hardware including multicore CPUs, higher resolutions, and multiple displays."
"One disadvantage of SAP PowerDesigner is that you cannot reverse engineer the ALTER statements, so that's an enhancement or area for improvement I'm looking forward to seeing from the SAP team in the future. That should directly reflect on the physical data models my company builds."
"UI could be improved by enabling simpler navigation."
"Regarding improvements, I suggest enhancing the connection between objects in process and data models. It's crucial to define the structure of objects, especially when dealing with standard frameworks like VMM. There should be better visualization of arrows between BPM and data modeling objects, specifying their structure and impact. For future versions, a feature similar to Bizagi, allowing users to see forms or SQL representations of objects, would be valuable for demonstrating and presenting project details to stakeholders."
"In the future, I would like to see data manipulation capability where you can actually write SQL queries and manipulate data from directly within the tool."
"The focus is more on mainstream development environments, and I see a lack of focus on the open source world. I think SAP PowerDesigner probably interfaces better with SQL Server and Db2 but not with open source databases like PostgreSQL and MySQL."
"It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product."
More Informatica Enterprise Data Catalog Pricing and Cost Advice →
Informatica Enterprise Data Catalog is ranked 1st in Metadata Management with 13 reviews while SAP PowerDesigner is ranked 3rd in Metadata Management with 32 reviews. Informatica Enterprise Data Catalog is rated 7.6, while SAP PowerDesigner is rated 8.0. The top reviewer of Informatica Enterprise Data Catalog writes "Great metadata management with more visibility and great technical support". On the other hand, the top reviewer of SAP PowerDesigner writes "Difficult to operate, long process to publish, but scalable". Informatica Enterprise Data Catalog is most compared with Alation Data Catalog, Collibra Catalog, AWS Glue, Informatica PowerCenter and Pentaho Data Catalog, whereas SAP PowerDesigner is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Visio, IDERA ER/Studio and SAP Information Steward. See our Informatica Enterprise Data Catalog vs. SAP PowerDesigner report.
See our list of best Metadata Management vendors.
We monitor all Metadata 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.