Bernard HOARAU

1
Extract7

• Bernard HOARAU
• bernard.hoarau_at_bull.net
• DSS Project Manager ODE

2
Agenda

• Introduction
• Système daide à la décision
• Extract7
• DataStage
• ODE
• Conclusion

3
Introduction
GCOS7
4
Système daide à la décision

• Transformer vos données en information
• Un système complémentaire au système opérationnel

Query Reporting
Data Mining
Analysis
OLTP
OLAP
BI
5
Architecture
IDS2 UFAS
UNIX NT servers SMP and MPP
IMSDB2ADABASVSAM...
DATA MART
OracleInformixSybaseMicrosoft...
ETL tools
DataStage
SAP R/3PeopleSoft...
Oracle 8i Teradata MS SQL7 RedBrick Informix
Express EssBase
ComplexFlat filesFTP...
6
BI in e-infrastructure
Front Office
Back Office
INTERNETPORTALS
Collaboration
INTRANETPORTALS
Infrastructure
C R M
ERP DWH LegacyOpen GCOS OS/390
Business Intelligence
Business - to - ConsumerAdministration -to -
Citizen

• Application Server(AS)
• Enterprise Application Integration (EAI)

EXTRANET PORTALS
SRM
COMMERCE
Business - to - Business
DECISION
DATA
INFORMATION
UNDERSTANDING
7
Extract7
PC Windows
UNIX, NT
Bull DPS 7000/GCOS 7
TCP/IP
Transform
Extract
Load
UFAS IDS/II
Flat File
DataWarehouse
8
Extract7
D A 7 N G E N
O D B C
2
O P E N 7 v 5
Serveur UNIX/NT
UFAS
DataStage CLIENT
TDS SQL7
3
1
IDS2
DataStage SERVEUR
4
Flat File
ORA8
5

• Extraction en batch utilisant SQL7 (Lecture
  seulement)
• Contrôle des jobs dextraction à partir de
  DataStage.
• Sources de données UFAS et IDSII
• Données cibles INFORMIX, ORACLE, SYBASE,
  ,SQLSERVER, TERADATA,.

9
Extract7
Client DataStage

• Gestion des Requêtes
• GCOS7 Request Manager
• GCOS7 Metadata Manager
• GCOS7 Listener

DA7
PC
GCOS7
Server DataStage
Gestion des Jobs
UN IX
10
Extract7
SQL7 Le TDS pour accéder aux données
non-relationelles GCOS7
FileTransfert
UFAS File
SQL7 Data Server (TDS)
SQL request
File Description Language
Relational Model Generator
Mapping Directive Language
IDSII Data Base
Relational Model File
11
Extract7
UFAS
CUSTOMERS CU_CODE CU_NAME CU_STREET CU_CITY
FDL
MODEL NAME IS MCUSTOMERS AREA NAME IS ACUST
ORGANIZATION IS INDEXED USING KEY-CUST. RECORD
NAME IS CUSTOMERS KEY KEY-CUST IS ASCENDING
CU_CODE DUPLICATES NOT KEY KEY-CUST IS ASCENDING
CU_CITY DUPLICATES WITHIN ACUST 02 CU_CODE
TYPE IS CHARACTERE 6 02 CU_NAME TYPE IS
CHARACTERE 15 02 CU_STREET TYPE IS CHARACTERE
20 02 CU-CITY TYPE IS CHARACTERE
15 END-MODEL
12
Extract7

• GCOS7 Request Manager

13
Extract7

• GCOS7 Metadata Manager

14
DataStage

• La solution ETL (Engine) choisie par Bull.

Extract
Load
Transform
The Foundation for Business Intelligence
15
DataStage
Extract Cleanse Transform Integrate
Any Data Target
Any Data Source
16
ODE
Products
Services
srv.ode_at_bull.net
17
CONCLUSION
STANDARD
EVOLUTIVE
INTEGREE
ECONOMIQUE
EASY TO RUN
LA MEILLEURE SOLUTION!
18
Merci pour votre attention

• Bernard HOARAU
• bernard.hoarau_at_bull.net