SAP Adaptive Server Enterprise (ASE), legacy vs. SAP NetWeaver MDM

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

Incentivized

Fairly easy to set up and get started even in large enterprises with the help of the configuration tools that come with the product. Also, the workflow engine can be defined with relative ease and monitored. Perhaps this product works very well in an SAP environment as it can be integrated with other SAP products

Incentivized

• Easy to setup and maintain
• Reliable, rarely has major hiccups requiring reboots or crashes
• Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows

Incentivized

• SAP MDM comes with a workflow engine that can be used by the business to define workflows, run workflows and monitor workflows
• SAP MDM also enables to create, read, update, and delete master data well across the organization
• With proper setup, it has helped prevent bad master data in the production environment

Incentivized

• Full database encryption - need to utilize external keys vs internal - for better separation of duties.
• History Tables.

Incentivized

• HANA is used for consolidation and there is adequate room for improvement in the consolidation function
• Business users can also contribute to improving the business workflows if there were a simple wizard set up for this purpose - at present, contributions are made through IT ticketing system

Incentivized

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Incentivized

It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.

Incentivized

Incredibly responsive, saving us countless hours in troubleshooting.

Incentivized

Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.

Incentivized

IBM Infosphere was considered but was much more expensive and also perhaps would have taken more time for initial setup. SAP MDM was selected because we found it easier to work with other SAP products and its ability to integrate well within the overall larger SAP environment and was also easier to configure.

Incentivized

• Negative - Costs a lot ... but so do they all.
• Positive - It does what we need it to do.

Incentivized

• A positive impact from an ability to leverage a single master data across the entire organization
• A positive impact from an ability to prevent bad master data in production
• Not a negative but could have been easier with a wizard set up for users to contribute to modify rules

Incentivized