ER/Studio Data Architect vs. SAP Master Data Governance

ER/Studio is great for providing data model images for teammates to use when they are not data modelers.

Incentivized

When configuring and testing new plant and warehouse for our client in automotive industry we had to test warehouse business processes, for that we needed Mater data and transactional data. And We levied SAP Master Data Governance to import all the master data including Materials, Customer, vendor, work center, Bill of Material among other datas. Our inhouse SAP Master Data Governance team, tested the data accuracy, ran simulation before finally loading the data into SAP. There were many failed master data which could not be loaded because of missing prequisites like Plants, storage locations. We corrected them in SAP Master Data Governance system by configuring plants, slocs and adding them to the material.

Incentivized

• ER/Studio is great for dividing logical and physical design. A logical model can be used with different physical platforms.
• Studio can a useful macro capability that allows me to apply the naming standards across the model with ease and consistency.
• ER/Studio does a very good job at comparing the model with the actual database and generating DDL scripts for production deployments.
• ER/Studio has an excellent reporting and model publishing capabilities allowing me to produce models in the HTML format and publish them for the team as needed.

Incentivized

• SAP MDG is a powerful platform that enables implementation of advance master data automation such as field auto derivation.
• Like SAP ECC, MDG performs very well throughout all sites around the world.
• SAP MDG comes equipped with the standard ECC or S/4Hana data models. This greatly simplifies rollout of the governance platform.

Incentivized

• Relationships are a bit on the weaker side. Many times I found orphaned relationships that I could not get rid of, or additional columns that were automatically created during the push to the physical model that appear to be due to key constraint bugs
• There are a lot of bugs introduced when merging keys. I tend to model 2 tables for example logically, establish the relationship, and then merge the additional key column that is automatically created when establishing the relationship. This sometimes causes downstream issues with the physical model (creating duplicate columns with _1 appended)
• Meta-data could be improved. I find it hard to keep descriptions and other meta information clean when copying and pasting from other sources due to formatting tags being introduced on each object (font, size, color, etc.). The attachment feature comes in handy, however I am looking for the ability to cleanly document and map multiple sources to a single target while providing searchability and traceability

Incentivized

• The learning curve is steep, and I think the build procedures might be challenging at first because we are transitioning from a non-systematic data management perspective.
• My team and I believe that its integration into learning new capabilities is complicated and limiting in terms of customizing reports.

Incentivized

MDG has proven to work and to bring results once implemented with the right approach, right engagement and sponsorship. Given that it is a very good tool to govern and control master data. Mainly if your company runs SAP systems which there will be a very straight forward integration, not needing any additional middleware or technologies.

Incentivized

Upto 8 1. Powerful Features: It offers a wide range of powerful features. 2. Complex Data Management: It helps companies to comply with large and complex regulation and audit processes. Missing 2: 1. Less interactive user interface or less modern look. 2. Limited integration with other tools

Incentivized

I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.

Incentivized

SAP provides great support for Master Data Governance (MDG). They work with us when we are faced with issues in standard solutions. SAP has a great set of Fiori tools that can be used for a better user experience. The issue with SAP is their web dynpro UI screens and they need to provide better support for performance issues that customers face.

Incentivized

critical to get management on board earlier and prioritize the resources

Incentivized

ER Studio Data Architect is a global leader in the data modelling space and most other solutions that have support for third party data models include support for ER Studio Data Architect file formats. Many of the features are a bit more intuitive than the competitors and several of our vendors were already using Data Architect themselves which helped solidify the choice.

Incentivized

Although Power BI has a cleaner interface, the functionality in terms of making sense of complex data has to go to SAP Master Data Governance. Any tool can be learned, so although there is a learning curve to SAP Master Data Governance, their online resources are a great guide.

Incentivized

• Using ER\Studio to create models and eventually the actual database schema allows for a picture that is understandable to the customer and saves significant time writing DDL to create the database objects (tables, indexes, relationships, constraints...)
• A nice customer interface tool so you can create a web based interface to the metadata for a particular design.
• The tool also supports sub-models so you can break a large project into smaller parts, I find this feature very helpful.

Incentivized

• We can make smarter decisions, enabling advanced scenarios like as AI/ML for predictive maintenance of instances, and data standardization decreases application build time, reporting, and connectors.
• The quality of the data has been increased, and the consistency of custom functionality has been assured.

Incentivized