Oracle MDM Introduction - dbguide.net

1 Master Data Management Team, Oracle Korea Oracle MDM Introduction SessionAgenda Model : Import : Cleanse : Governance : Integration : References Wrap up<Insert Picture Here> Introduction 2000 29 . , 1234, 7788, vanilla, vnl .Vanilla BeansVanilla Beans.

2 , , .. vanilla .. 7788 .. VNL VS Fortune 1000 Master Data Management: Consensus-Driven Data Definitions for Cross-Application Consistency, Philip Russom, Sr. Manager of Research And Services, TDWI What Works, Volume 220100200300400500 Governance hierarchy (MDM) 9.

3 (MDM) MDM Legacy system , , MDM . , . MDM , , (Single Source of truth) . (MDM) SiebelEBSSAPC ustom AppsOtherSiebelEBSSAPC ustom AppsBITrusted Master Data.

4 (Single source of truth) . Oracle MDM Portfolio Data GovernanceOracle Fusion MiddlewareApplication Integration ArchitectureOperation MDMA nalytic MDMO perational SystemsAnalytical SystemsEBSS iebelSAPC ustom AppsExternalAppsPeopleSoftJDEB udgetingDWBI &DatamartsPlanningFinancial ConsolidationDashboardsCustomer HubProduct HubSite HubData Relationship ManagementCustomerSupplierFinancialProdu ctAnalyticalSite<Insert Picture Here> Features Features Workbench(Bulk Import)

5 (SSM / Cross-Reference)World-class (Customer, Supplier)Relationship Hierarchy Web ServiceIntegrationRepositoryPublic PL SQL & JAVAAPIsBusiness EventSystem(BES)SOA(BPEL)Connectors (Access Control)DQ (Match rule, Auto merge rule, Validation rule) (Approval rule engine) Naming (Word replacement/ Transformation) / (Smart search) (Merge & Purge) (Survivorship) Trusted Master DataTrusted Master DataPartyAccountHierarchyCatalog & CategoryRoles & RelationshipsClassificationAttributesRel ated Data Entities Attributes & specifications Product configurations / BOM Documents, images Change requests & orders Hierarchies, households Interaction history Sales, service & marketing informationMasterData Repository.

6 OLTP data model Hierarchy, Relationship data attributes / ConsolidateImport WorkbenchIdentification & Cross-ReferenceSource system ManagementSurvivorshipSiebelEBSSAPC ustom AppsOtherTrusted Master Data , Integration Code, (Interface).

7 Batch, Real-time Batch Batch , , DB Link Batch Import Workbench Automatic(Rules-Based)Manual(Review & Match)-or -From Stagingto MDM Bulk import, SAM file . Bulk Batch MasterData RepositoryCleanse / Cleanse & StandardizeEnrichMatch & MergeTrusted Master Data Match Rule Match RuleEnginePossible Duplicates , Match Rule.

8 Rule , Human error Match Threshold (Tight Match / Loose Match) (Auto-Merge), (Validation) Match Rule CM-277ID186-17 interaction051-276-3179 700327-10xxxxx 1 MainDBDB7DB6DB5DB4DB3DB2DB1128 010-3809-2177 700327-10xxxxx 3 MainDB DB7DB6DB5DB4DB3DB2DB1 MDM2008 3 27 CID-001051-276-31793 128 700327-10xxxxx Interactions 2ID GovernProfile & CorrectHistory& AuditData SecurityMerge RequestTrusted

9 Master Data , . , , . , , , (CRUD) , Data Governance AccountabilityRight DecisionWhoWhatHowWhen , , , , GovernanceMatrix Template Who ?

10 What ? How ? When ? Create Read Update DeleteO = Data Owner, A = Data Admin, CU = Create/Update SiebelEBSSAPC ustom AppsBIShareBusiness Object APIP ublish &SubscribeAuthorizationRegistryBusiness EventsTrusted Master DataWeb Services Biz Event Public APIs Connectors SuppliersLegacyThird-PartySingle source of Truth , API Business Event , <Insert Picture Here> Oracle MDM ReferencesOracle MDM 800 Life Sciences and HealthcarePublic SectorCommunications, Media & UtilitiesFinancial ServicesHigh TechnologyManufacturing &DistributionRetail & CPG Summary / Global risk Risk Loyalty IT Modernization / ROI ROI 1.