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 , . , , .. 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.

2 (MDM) MDM Legacy system , , MDM . , . MDM , , (Single Source of truth) . (MDM) SiebelEBSSAPC ustom AppsOtherSiebelEBSSAPC ustom AppsBITrusted master data , , , , , , , . (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) (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)

3 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 . OLTP data model Hierarchy, Relationship data attributes / ConsolidateImport WorkbenchIdentification & Cross-ReferenceSource system ManagementSurvivorshipSiebelEBSSAPC ustom AppsOtherTrusted master data , Integration Code, (Interface).

4 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 . 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 master data .

5 , , . , , , (CRUD) , data Governance AccountabilityRight DecisionWhoWhatHowWhen , , , , GovernanceMatrix Template Who ? 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.

6 Risk Mitigation Risk / ( ) Global risk Risk I. EIS / BI (GIGO)II. , , MRO Financial Report Standard II. COA(Chartof Account) , Structure mapping , Risk II. Insight ( Global Sourcing)I. , , , Risk II. Risk 2. Revenue Maximize Loyalty Revenue I. Up-Sell / Cross-Sell II. (Bounced DM Target Segmentation)I. , II. (Sense-to-Response)I. II. , ( Telco Industry)I. Synergy II. 3. Cost Control IT IT Modernization ROI ROI , N2 Integration ( )II.

7 , Web-Service SOA Technology I. IT II. ROI I. ( Invoice billing )II. Wrap up Messag