ER/Studio vs. SAP Information Steward

Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms

Incentivized

SAP Information Steward is well suited for companies looking for profiling data, monitoring data quality and managing policies. It provides dashboards and features to create the awareness on Data Quality dimensions. SAP IS is not suited to manage huge amount of data due to performance issues. It is not designed to correct data by its own. However, It can remediate data through integration with SAP Master Data Governance or SAP Data Services.

Incentivized

• ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
• ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
• My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.

Incentivized

• Audit trail management of Metadata to ensure due diligence with respect to the quality of data
• Control features and identification of risk wrt data
• Ready recknor in form of advance bi reports for procurement and costing kpi
• Flexible comparison and filter functio ality across cross organisation data

Incentivized

• ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
• The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
• A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.

Incentivized

• More real-time integration scenarios needed.
• Needs more generic standard content for metadata management.
• The user interface can be more intuitive based on AI.

Incentivized

Out of the box solution

Incentivized

It provides out of box solution for information management at organisation level

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

I believe many features from SAP Information Steward are available in other SAP products as well hence it is more confusing for business or customers to do the right selection. Moreover SAP strategy is not very clear for this particular product hence often we are confused while exploring more related scenarios

Incentivized

Ready recknoer tools that act as reference are missing that can help to formulate ;Decision Driven Framework' for various strategic decesions

Incentivized

ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.

Incentivized

Both are great products and I highly recommend both

Incentivized

• ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.

Incentivized

• Improvement on Organization Data Quality
• Real time Data Quality Issues discovery
• Data Policies effective management

Incentivized