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

43
Enterprise Information Management © CITIA BTC, 2010

Upload: others

Post on 27-Jun-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

Enterprise Information Management

© CITIA BTC, 2010

Page 2: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

2

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

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

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

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

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

Page 3: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

Page 4: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

Operational EIM

© CITIA BTC, 2010

4

Page 5: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

Analytical EIM

© CITIA BTC, 2010

5

Page 6: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

Page 7: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

Page 8: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

8

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

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

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

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

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

Page 9: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

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

Data Integration

Data Quality

© CITIA BTC, 2010

9

Page 10: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

10

Page 11: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

11

Page 12: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

12

Page 13: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

13

Page 14: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

14

Page 15: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

15

Page 16: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

16

Page 17: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

17

Page 18: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

18

Page 19: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

Условие Цикл

Исключение

© CITIA BTC, 2010

19

Page 20: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

20

Page 21: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

21

Page 22: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

22

Page 23: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

23

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

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

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

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

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

Page 24: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

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

© CITIA BTC, 2010

24

Page 25: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

25

Page 26: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

26

Page 27: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

27

Page 28: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

28

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

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

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

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

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

Page 29: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

29

Page 30: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

30

Page 31: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

31

Page 32: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

32

Page 33: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

33

Page 34: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

34

Page 35: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

35

Page 36: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

36

Page 37: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010

37

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

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

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

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

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

Page 38: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

38

Page 39: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

39

Page 40: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

40

Page 41: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

41

Page 42: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

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

© CITIA BTC, 2010

42

Page 43: Enterprise Information Management · business users can see information as if it came from a single source. Rapid Marts – Use pre-packaged data marts for SAP, Oracle, Peoplesoft

© CITIA BTC, 2010