enterprise information management · business users can see information as if it came from a single...

Enterprise Information Management

© CITIA BTC, 2010

© CITIA BTC, 2010

2

Введение в EIM от SAP

SAP Data Services – Архитектура

SAP Data Services – Параллельная обработка данных

SAP Data Services – Контроль качества данных

SAP Data Services – Очистка данных

ERP DW RDBMS OLAP EmailDocs NotesWebXML

Structured Data Unstructured Data

Deliver to any target system

ERP, SRM, CRM

Applications PerformanceManagement

BusinessIntelligence

Access and profile data from any source

Manage Master Data

Quality

Consolidate

Report

© CITIA BTC, 2010

3

Operational EIM

© CITIA BTC, 2010

4

Analytical EIM

© CITIA BTC, 2010

5

Data migration – Designed to help you transfer source data into adesired application or system more quickly and easily

Data quality management – Cleanse, profile, and standardize datafrom SAP and other packaged or custom applications

Data integration – Combine disparate data sources to support anenterprise data warehouse strategy, or use data federation forquick integration without physically moving the data

Data lineage – Enable users to drill down and track data back to itsoriginal source

Consolidated metadata – Integrate data sources and systems intoan open, relational repository

Поддерживаемые бизнес-процессы и функции EIM

© CITIA BTC, 2010

6

Data Services – Use this unified data integration and data quality management solution to consolidate, improve, and deliver data anywhere

Data Integrator – Extract, transform, and load data from data applications, databases, or other data stores to create a complete view of enterprise information that can be delivered to any application tool in your enterprise

Data Federator – Create a real-time view of multiple data sources with virtual data integration so that business users can see information as if it came from a single source

Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft and Siebel applications to accelerate the delivery of analytic or BI data

Text Analysis – Extract information from unstructured text sources and analyze text to learn about customer sentiments, market trends, service issues, and so on

Metadata Management – Consolidate and edit metadata from various data sources into a single repository to provide a semantic view of data to analyze usage, change, and data lineage

Data Insight – Enable data stewards to profile data to identify errors and fix data quality issues

Data Quality Management – Define a best record strategy, set match criteria, reduce duplicates, cleanse, validate addresses, and enrich data with geographic attributes to improve data quality

Postalsoft – Improve mailing operations with address correction and encoding, data and list management, mail preparation, and shipping discounts

SAP BusinessObjects EIM solutions

© CITIA BTC, 2010

7

© CITIA BTC, 2010

8

Введение в EIM от SAP

SAP Data Services – Архитектура

SAP Data Services – Параллельная обработка данных

SAP Data Services – Контроль качества данных

SAP Data Services – Очистка данных

Data Services единая платформа

интеграции и анализа данных

Data Integration

Data Quality

© CITIA BTC, 2010

9

Масштабируемость и доступность

© CITIA BTC, 2010

10

Поддерживаемые источники данных

© CITIA BTC, 2010

11

Распределенная архитектураData Services

© CITIA BTC, 2010

12

© CITIA BTC, 2010

13

Консоль управления

© CITIA BTC, 2010

14

Окно дизайнера

© CITIA BTC, 2010

15

Пакетные задачи (Batch Jobs),планирование

© CITIA BTC, 2010

16

Задачи реального времени, события(Real-time Jobs)

© CITIA BTC, 2010

17

Рабочие потоки (Work Flows) и потоки данных (Data Flows)

© CITIA BTC, 2010

18

Управление ходом выполнения задач

Условие Цикл

Исключение

© CITIA BTC, 2010

19

Скрипты, функции и переменные

© CITIA BTC, 2010

20

Конфигурация источников данных

© CITIA BTC, 2010

21

Слежение за выполнением задачи(в режиме реального времени)

© CITIA BTC, 2010

22

© CITIA BTC, 2010

23

Введение в EIM от SAP

SAP Data Services – Архитектура

SAP Data Services – Параллельная обработка данных

SAP Data Services – Контроль качества данных

SAP Data Services – Очистка данных

Уровень распределения задачи

• Job level• Data flow level• Sub data flow level

© CITIA BTC, 2010

24

Степень параллельности

© CITIA BTC, 2010

25

Количество загрузчиков

© CITIA BTC, 2010

26

Поддержка партиций

© CITIA BTC, 2010

27

© CITIA BTC, 2010

28

Введение в EIM от SAP

SAP Data Services – Архитектура

SAP Data Services – Параллельная обработка данных

SAP Data Services – Контроль качества данных

SAP Data Services – Очистка данных

Анализ происхождения и влияния данных(Linage and Impact)

© CITIA BTC, 2010

29

Интеграция с BusinessObjects

© CITIA BTC, 2010

30

Профилирование данных(Profiling)

© CITIA BTC, 2010

31

Аудит данных(Audit)

© CITIA BTC, 2010

32

Проверка значений(Validation)

© CITIA BTC, 2010

33

Контроль ошибок и обновления данныхво время загрузки

© CITIA BTC, 2010

34

Восстановление с точки сбоя

© CITIA BTC, 2010

35

Отладка данных, точки прерывания

© CITIA BTC, 2010

36

© CITIA BTC, 2010

37

Введение в EIM от SAP

SAP Data Services – Архитектура

SAP Data Services – Параллельная обработка данных

SAP Data Services – Контроль качества данных

SAP Data Services – Очистка данных

Очистка данных

© CITIA BTC, 2010

38

Пример очистки данных

© CITIA BTC, 2010

39

Пример сопоставления данных

© CITIA BTC, 2010

40

Удаление дубликатов

© CITIA BTC, 2010

41

Заполнение пустых полей

© CITIA BTC, 2010

42

© CITIA BTC, 2010