What do each of the major MDM suppliers (Informatica, IBM, Oracle, SAP) provide as MDM Capabilities within their core MDM licensing (i.e. Matching, Deduplication, Searching, Modeling, Analytics, Integration / ETL, Database technology)?
For instance, I understand that IBM InfoSphere provides some basic ETL capabilities as well as licensing to use DB2 for the database.
Does their user interface include Data Quality capabilities? or like Informatica, do you have to buy their IDQ tool as well?
I think for Informatica, I'd have to buy their MDM, IDQ, Integration (or another ETL solution) and BPM components; Oracle would be UCM, EDQM, ?, etc.
What are all the capabilities needed for an overall MDM solution (i.e. Matching, Deduplication, Searching, Workflow, Modeling, Analytics, Integration, Domain / cross-domain, Governance tools to change / commit / rollback, what else?)?
Riversand technology is leader in the MDM space and makes a product called MDMcenter. Gartner and Forrester put these guys in a leader and visionary quadrant topping Informatica, oracle, and sap.
They have a product used by many fortune 1000s and multinational companies. I have rolled out MDM solutions for a bunch of customers using different platforms and Riversand's is the best. They have cloud based and on premise solutions. It can scale from small projects to biggest implementations of the planet, different geographies/locations, langauges and near infinite entities. Their licensing can vary based on required modules; but they offer Matching, Deduplication, Searching, Workflow, Modeling, Analytics, Integration, Domain / cross-domain, Governance tools to change / commit / rollback. The applications modeling and framework is flexible so it can handle any domain, product, retail, manufacturing, customer, vendor, finance, investment vehicles, jewelry, oil and gas, person, auto, high tech, oil gas, fast food, grocery, etc.
Hands down this is best product in its class. It's top shelf. Given the choice and having used other products, I'd choice Riversand over the other competing products.
If you didn't check them out yet, you definitely should.
I cannot offer insight into the licensing policy of each vendor as they are very varied and indeed can change deal to deal. Oracle for instance might give you limited database license if you use it specifically for MDM - but will audit you and bill you for full use even if you add one custom table! What it also means is that if are going with the big ones - you can negotiate!!
I can, however, help you with key MDM requirements as defined by Gartner.
-Workflow/BPM,
-Loading/synchronization/business services/integration (which is basically ETL) - but it gives you the ability to implement in different styles - centralized, registry, co-existence, consolidation
-Information quality, semantic consistency : this is for DQ capability and survivorship
-data modeling - strength based on metadata management, policy enforcement, dating and versioning
-Stewardship support (such as 360 degree view, where used, decay analysis, ownership)
-Governance (a combination of a lot of the above really)
-multiple use cases (Operational and analytical) - here you can use ERP/PLM/CRM as operational examples and APS and DWH as analytical use cases.
- multi domain (product, customer, supplier, account, HR, location, person) - Tricky, as many vendors including Oracle claim to be multi domain - but they do not use a single framework to manage multiple domains - that is really not multi domain because the CDO's office still needs to manage multiple frameworks and the cost of ownership is very high.
- data quality dashboards
- Task management (Advanced)
- multi device support
If you are interested, you can also check us out at :
www.triniti.com for cheaper alternatives if you are an Oracle eBusiness Suite user. You can also peruse our following whitepapaers:
www.triniti.com (gives you an insight on why we have eliminated ETL and modeling from MDM)
www.triniti.com (Talks about an emerging part of MDM called ADM - application data management. We argue why MDM is worthless, if it is not built to make applications that consume master data such as ERP, CRM etc cannot use it instantaneously)
If you buy InfoSphere MDM Domain Hub Standard Edition you can use following products:
IBM Process Server Standard v8.5.6
IBM Process Server Standard for Non-production Environment v8.5.6
IBM Process Center Standard v8.5.6
IBM Process Designer v8.5.6
IBM Content Integrator v8.6
IBM DB2 Enterprise Server Edition v10.5
IBM Cognos Business Intelligence V10.2.2.0
IBM InfoSphere Information Server Enterprise v11.5
IBM Integration Bus Healthcare Pack v3.0.0.0
IBM Integration Bus Express Edition v9.0.0.3
IBM Watson Explorer v10.0
IBM Rational Application Developer for WebSphere Software v9.5
IBM WebSphere Application Server Network Deployment v8.5.5
IBM WebSphere Application Server Base v8.5.5
IBM WebSphere MQ v8.0
IBM WebSphere Portal Server v8.5
IBM Installation Manager & IBM Packaging Utility for Rational Software Development Platform v1.8
IBM Security Directory Server v6.4.0.0
For IBM InfoSphere Master Data Management Enterprise Edition you can use also:
IBM InfoSphere Big Match for Hadoop v11.5
InfoSphere Information Server contains both DataStage (ETL engine) and QualityStage (DQ components which are fully integrated with ETL).
You could always check which products are provided in license on Software License Portal (www-03.ibm.com)