MDM Tool Comparison Report: Challenges and Business Cases
"Discover the challenges in designing and building basic data domains, the importance of pre-built models in MDG solutions, and the impact of MDM tools on various data domains. Explore the role of MDM in Pharma aspects and learn about the key elements for driving benefits in data management."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
TEMS GROUP EMS GROUP AN INFO SYS AN INFO SYS MDM Tools Comparision Report Presented by DV Singh CIO, An Info Systems GmbH M: +31-629014650 E: dvsingh@aninfosys.com
Winners in the MDG RACE !! Clients will prefer products with pre built Models for most common data domains; namely Material , Finance, Vendor, Customer, Reference Data MDG Solution Challenges Design and Build of a Basic single data domain can take easily between 5-8 months with many resources on board. The quality of it will depend on quality of resources, which is often ? Cost of single data domain can be easily between 1.5 - 3 million Rare to find MDM tool developer s with broad knowledge of professional ERP s like SAP, Oracle SAP resources, are highly focused within SAP Tool aspects and poor skills outside it, in terms of DB Modelling, Product Design & development etc
MDM Domain Cases- Generic Ones Vendors-> Suppliers Customer -> Buyer Customer-> Purchasing Stakeholders (IDN) Customer-> Order Purchasing Influencers (IDN) Business Partner Business Partner Hierarchy ( Critical ) Finance Finance Accounts - Hierarchy Material / Product (Sales) Material / Product (R&D) Employees / HR Reference Data Locations (Warehouse/ Operations / Trail region ) (with or without Graph ) Trials Regulatory Data Management eg. IDMP, FDA, PQ/CMC ..
MDM Domain Cases Pharma Aspects Location services for operations Location data is unique in this regard, as it isn t particularly useful on its own; you need to combine it with some other type of information to gain improved analytics, forecasting and business intelligence to informing larger strategic initiatives like Physical Asset Data + Location Data, Product Data + Location Data, Customer Data + Location Data & Supplier Data + Location Data Global to local company structures MDM acts as a central HUB for master data irrespective of any other system's data. It is always good to store global data in MDM and from there Global data can manage, maintain and distributed smoothly to various systems with linkages to local data as per the business needs Globalization, M&A are forcing the need to have consistent data synchronized across the enterprise. Regulatory compliance is highlighting the need to have the data tagged with all its peripheral enablers (policies, definitions, domain, business rules, metadata, quality, governance, ownership, security, etc.). Performance Management & Business Analytics won t thrive without accurate, consistent, and reliable data. Incorporation partners for R & D data Following are the key elements in this space to drive the benefits. Investigator & Site Selection for Clinical Trials , Speedy Patient Onboarding, Clinical Data Integration, Molecule to Market & New Drug Commercialization Regulatory Approval Forms Submissions Data Exploit centralised product information (MDM) to overhaul the way they create routine documents. Process automation rates of 90%+ could enable regulatory submissions and patient content to be generated 10 times faster than they are today For standard application forms, where no customised tweaking is required, 100% of the document compilation could be automated, accurately matched to the given market and target language. The expectation is that the time savings will be at least tenfold: so where new content preparation has previously taken 50 man days, it will now take just five. These are phenomenal efficiency gains, offering to significantly accelerate companies speed to market while freeing up experts to focus their time on higher purposes.
Functional Use Cases Overview Use Case Categories and their weightage 0 2 Use Case Category weightage is a percentage. In other words the weightages add up to 100. Each use case has a weightage from 1 (low impact) to 3 (high impact). Score for each use case varies between 1 (lowest) and 7 (highest) Weightage 4 6 8 10 12 14 16 Modeling Integration Data Cleansing & Validation Matching & Survivorship Hierarchy Management Workflow Ingestion Data Stewardship Auditing Reporting & Analytics Data Access Patterns Steward UI Developer UI Data Governance
SAP MDG Vs Informatica MDM Vs EMDG Differentiator for Application Features Feature EMDG on Tibco EBX SAP MDG Informatica MDM Y Y Y Data Governance Data Masking Data Source Integrations Hierarchy Management Match & Merge Metadata Management Multi-Domain Process Management Relationship Mapping Visualization N Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Above report is collected from a MDM Expert s Consultancy
SAP MDG Vs Informatica MDM Vs EMDG Detail/Supported Tibco EBX Informatica MDM SAP MDG Comments Databases Supported Oracle 11g , Microsoft SQL Server 2008R2/higher, PostgreSQL 9.1 (ORDBMS),H2, SAP HANA and Microsoft Azure SQL Database v12 Oracle, SQLSERVER and IBM DB2 SAP HANA, MS SQL Server, Oracle, IBM DB2 EBX: Default: H2 In memory Database No installation is required, it comes with the package App Servers Tomcat, JBOSS, Oracle WebLogic, IBM WebSphere and RedHat JBoss JBOSS, Oracle WebLogic, IBM WebSphere Tomcat, JBOSS Encoding & Locales UTF-8 & Supported UTF-8/16 & Supported UTF-8 & Supported Webservices SOAP & REST SOAP & REST SOAP & REST Cloud/On-Prem Both supported, AWS RDS, Azure SQL, GCP CloudSQL,Oracle Cloud Dbaas On-prem. Only AWS RDS - If DB is Oracle On-Prem, AWS S3, Azure, GCP Informatica, there will be separate cloud editions Master/Slave Arch Supported D3 Architecture, through broadcast with region distribution Supported Supported Semantic/Relational In memory engine/ can be replicated Relational with DB access Semantics but supports DB replication Pricing Approx $500, with self learning docs Approx $1000/month Approz $1500/month To be contacted for real Core Technology Java, XML, AJAX and JAVA API JSF (rich faces), Spring, Hibernate, EJB and AJAX J2EE, C, C++, XML, JAVA API Workflow is much easy to setup then other competitors Above report is collected from a MDM Expert s Consultancy
SAP MDG Vs Informatica MDM Vs EMDG SAP MDG Detail/Supported Tibco EBX Informatica MDM Comments SAP Lori EBXGO - (Android & IOS) + KPI s Dashboards Mobile APP NA Role based security Role Based security, Data services security Through SAM, attribute & data level security Security LDAP, SSO Integration with enterprise security systems Collaborative Workflow Custom authentication like enterprise directory (LDAP, Active Directory) supported, SSO Supports third party security services through SAM (MDM HUB) Supported Supported Supported Not specific in number but with it s in built In-memory engine delivers high performance with millions of data processing Not specific but definitely supported millions of data with high performance Used by large enterprises with huge data volumes User/Data Volume Has Modules for:: Business Partner, Vendor, Customer, Material, Finance. Reference Data MDM is not there. None out of box. The standard Modules and Reference Data MDM are made available by Partners MDM Data Domains, out of box None Extension for new data domains Easy to add, but challenges on Workflow and UI Very tough to add new data domain, lengthy and very costly Very easy and quick Above report is collected from a MDM Expert s Consultancy
SAP MDG Vs Informatica MDM Vs EMDG SAP MDG Detail/Supported Tibco EBX Informatica MDM Comments Offers tool for Workflow define and integration , but is highly technical and complex Basic workflows are available inbuilt and small enhancements possible Very easy to make. Can be done on fly even after go live Process Workflows Highly flexible. Each user can even make his own screen layouts You can make horizontal and vertical views and even mix them up. Very easy to add shortcut menu items and non technical approach to it. Difficult to build nice UI and is highly technical process too. Not easy to add shortcut menu items Offer horizontal and vertical views like EBX but less flexible to mix them up. Not easy to add shortcut menu items UI Layout and Menu Items Out of box not there. But it is available as a free Add On for FREE from a partner. Allows to build custom contents for Help on the fly any time with text, images, links etc No option for Help pages, out of box. It has to be custom development. Defined for existing modules. But no out of box solution for new data models Help Pages for Each UI screen Data Exchange modules is available to provide large no of options to import data and also export data in various forms like excel, xml etc. It allows complex data filtering etc too No out of box good solution, with some limited functionality over data manager It has functionaity to import and export using templates for standard modules. Mass Data Imports and Exports Above report is collected from a MDM Expert s Consultancy
