Data Governance mit Informatica Teil 3/3

© 2015 Mieschke Hofmann und Partner Gesellschaft für Management- und IT-Beratung mbH

Anforderungen und Chancen für den Einsatz moderner Datenwerkzeuge

Data Governance mit Informatica Teil 3/3

Hugo Colceag & Dr. Martin Hebach | MHPBoxenstopp: 07.03.2017

© 2017 MHP – A Porsche Company

© 2017 MHP – A Porsche Company 2

21.03.2017 Mobilität im urbanen Raum von Morgen Herausforderungen an die Smart City

04.04.2017 Sourcing von externen Dienstleistungen Ausschreibungen als wesentliche Grundlage von

Verträgen und Lieferleistungen

25.04.2017 Digitale Transformation im Yard SAP Yard Logistics - Integration Ihrer Transport-, Lager-

und Abrechnungsprozess

Weitere MHPBoxenstopps www.mhp.com/events

Fahrplan Zu Beginn sind alle Teilnehmer auf stumm geschalten.

1. MHPBoxenstopp Vortrag Hugo Colceag & Dr. Martin Hebach

2. Pressekonferenz (Fragen & Antworten) Sie können bereits während der Web Session über die

Chatfunktion im rechten Fenster Fragen einreichen.

www.youtube.de/MHPProzesslieferant www.slideshare.net/MHPInsights

MHPBoxenstopp verpasst? Alle vergangenen MHPBoxenstopps finden Sie hier:

MHPBoxenstopp: Data Governance mit Informatica Teil 3/3

http://www.mhp.com/de/events/aktuell/ ?utm_source=mhpboxenstopp&utm_medium=e-mail&utm_campaign=Unterlagen_September

http://www.youtube.com/MHPProzesslieferant

http://de.slideshare.net/MHPInsights


Hugo Colceag

Senior Manager

Data & Technology

Master Data Management

IT Management an der Schnittstelle zu den

Fachbereichen

Technologische Analyse, Architektur &

Implementierung

Produktmanagement, Projektmanagement

Branchen Hintergrund: Automotive

Fahrerprofil


Dr. Martin Hebach (Informatica GmbH)

Senior Solution Architect

IT Management an der Schnittstelle zu den

Fachbereichen

Fachliche Analyse, Architektur &

Implementierung

Programm- und Projekt Management

Branchen Hintergrund: Financial Services


1. Datenmanagement heute

2. Treiber für Data Governance Initiativen

3. Data Governance: Definition und Informatica Framework

4. Informatica Technologie: Metadaten Tools und Master Data Management

5. Fazit/Wrap-up







5. Fazit/Wrap-up



Data powers Business Transformation – the Intelligent Data Platform

Traditional Data

(Enterprise Apps,

DW, Mainframe, DB)

Big Data

Cloud Data

(SaaS, PaaS,

& Social)

Business User

IT Integration

Expert

Metadata Intelligence

Live Data Map

Ingest Transform Secure Validate Cleanse Master Mask Archive

Devices and Sensors

Bulk / Batch Real-time Streaming

Cloud / iPaaS On-premise

API Driven Events / Messaging

Hybrid

DevOps

(Structured/ Unstructured

Data)

Files

LOB IT

Developer

Co

mm

on

Co

nn

ect

ivit

y In

terf

ace

In

-Me

mo

ry C

ach

ing

PD

O

Pa

ralle

lism

M

eta

da

ta-a

ware

Compute Engines

Map Reduce, Spark/Streaming, Blaze

DATA SOLUTIONS

Customer 360 Product 360 Supplier 360 Secure@Source Intelligent Data Lake

OPERATIONAL MANAGEMENT







5. Fazit/Wrap-up




Banking

- Basel II (Basel III)

- BCBS 239

- CCAR

- Solvency

- FATCA

- Dodd Frank

- KYC (Know Your Customer)

- EMIR (EMEA)

- MiFID (EMEA)

Insurance

- Solvency II (Europe)

- KYC and

- NAIC solvency rules

Healthcare

- HIPAA

- Meaningful Use

- PPACA

All Industries

- Payment Card Industry (PCI)

- EU Data Protection Directive 95/46/EC

- Capital Requirements Directives (CRD) IV

- Data Retention Directive 2006/24/EC

- Bundesdatenschutzgesetz (BDSG)

- Children’s Internet Protection act

- Environmental Protection Agency

- OSHA

- EEOC

- FCPA

Food

- HAACP

- GFSI

- SQF

- Food Safety Modernization Act (FSMA)

Life Sciences/Medical Devices

- UDI

- IDMP (EMEA)

- Track & Trace

- Sunshine Act

Common Requirements

• Know where the data is

• Understand what processing is applied (manual and automated)

• Ensure quality is known (measured) and protected through the lifecycle

• Make the processing logic transparent

• Control access to and distribution of data


Compliance & Risk, Growth, Efficiency & Cost, Strategic Differentiation

Compliance risk Information

Security/Privacy

• Secure or mask

sensitive, classified and

confidential information

• Ensure privacy

compliance for

marketing

communication

preferences

• Enable PCI compliance

• Enable transparency

for financial reporting

and auditability (SEC,

SOX, Basel II)

• Improve readiness for

an e-discovery event

• Adhere to corporate

data security policies

and standards

Revenue growth

• Increase cross-sell,

up-sell

opportunities

• Increase marketing

campaign response

rates

• Improve account

management

Improved efficiencies

• Improve decision support

process by reducing time

needed to collect and

cleanse data

• Reduce call center

response times with

access to timely, trusted

customer and product

information

Business transformation

• Move from single

channel to multichannel

business model

• Change from physical to

digital products

• Support mergers or

divestitures of core

businesses







5. Fazit/Wrap-up



Data Governance ist…

Die Ausübung von Autorität, Kontrolle und

verteilten Entscheidungsprozessen (Planung,

Überwachung und Durchsetzung) über das

Management von Daten Assets.


People

Technology Processes

Data Governance



• Conceptual Models

• Onthologies

• Logical Models

• Physical Models

• Integration & Processing

Rules

• Discovery and Profiling

• Validation

• Enrichment

• KPIs, Reporting

• Master Entity Definition

• Matching and Merging

• Entity Relationship

• Entity Lifecycle

• Domain Specific Rules

• Security Policies

• Masking and

Tokenisation

• Encryption

• Role Based Access

• Test Data Generation

and Management

• Operational and

Analytical Data Flows

• Data Archiving

• Data Purging

• Horizontal Scalability

• Zero Data Loss

• Fault Tolerance

• High Availability

Governance

Metadata

Data Security

Master Data

Management

Quality

Data

Infrastructure

Lifecycle






5. Fazit/Wrap-up




User

Use-Case

Stakeholder

Product

Data Architect /

Steward

Unified view into

enterprise

information assets

How can I

manage

metadata for key

enterprise data

assets?

CIO / CDO

Enterprise

Information

Catalog

InfoSec Analyst

Enterprise visibility

of sensitive data

proliferation, usage

& risk

Where is all of

the PII/PHI data

and the risk of

exposure?

CIO / CISO

Secure@Source

Data Scientist /

Analyst

Self-service data

preparation with

collaborative data

governance

How do I find and

prepare the data

sets I need for

my analysis?

CIO / CDO / CAO

Intelligent

Data Lake

End-to-end

management of

data governance

policies

Business Steward

How do I comply

with governance

policies across

the company?

CIO / CDO

Data

Governance

App


Pharma Beispiel: Master Data Management for IDMP


MDM is about listening and linking and coordinating the unique identifying elements of things

(including compounds, products, authorization holders, suppliers and customers) in various

systems

• MDM is more than de-duping – its

continuous consolidation

• Think…

1. Listening

2. Linking

3. Governing

4. Sharing






5. Fazit/Wrap-up



MDM as a core IDMP Enabler

5. Fazit/Wrap-up - Informatica Technologie für Governance Anforderungen

MDM Capability IDMP Challenge

Configurable

Workflow

• Organisational: Involve representatives from multiple departments

• Co-ordination: Synchronise across systems & submissions

Flexible Data Model • Phases: Start with XEVMPD, or other project (e.g. substance)

• Phases: Expand to later phases without software upgrade

• Technical: Configurable entities/attributes, hierarchies, relationships

Automation of Data

Quality Rules • Technical: Configurable rules for data cleansing, conforming to

controlled vocabularies, matching, attribute survivorship

• Technical & Co-ordination: Cross-reference view for data lineage

Visible Data History • Co-ordination: Auditable interactions, whether from source data or

manually entered

• Co-ordination: Data Stewardship Consoles

Proven Technology

• Phases: Remove technology from risk factors for each phase

18 © 2017 MHP – A Porsche Company


Gesellschaft für Management- und IT-Beratung mbH

MHP – A PORSCHE COMPANY

Hugo Colceag

Senior Manager

Technology & Integration Solutions

Mobil: +49 151 2030 1414

E-Mail: [email protected]

Dr. Martin Hebach

(Informatica GmbH)

Senior Solution Architect


MHPBoxenstopp

Mobilität im

urbanen Raum von

Morgen

21.03.17 – 11:00Uhr

MHPBoxenstopp

Sourcing von

externen

Dienstleistungen

04.04.17 – 11:00Uhr

MHPBoxenstopp

Digitale

Transformation im

Yard

25.04.17 – 11:00Uhr

MHPBoxenstopp

MHPBoxenstopp verpasst? Kein Problem!

Mitschnitte und Videos:


Präsentationsunterlagen:


MHPBoxenstopp: Timetable 2017







