1 1 copyrights 2002: information frameworks. naeem hashmi enterprise portal, business information...

1Copyrights 2002: Information Frameworks. Naeem Hashmi 1

Enterprise Portal, Business Enterprise Portal, Business Information Warehouse and the Information Warehouse and the Extraprise Information FactoryExtraprise Information Factory

Naeem HashmiNaeem Hashmi

Chief Technology OfficerChief Technology Officer

Information FrameworksInformation Frameworks

e-mail: [email protected]: [email protected]

Web: http://infoframeworks.comWeb: http://infoframeworks.com

Webcast on TechTarget.com May 1, 2002


About the Speaker

• Founder and CTO of Information Frameworks, an author, speaker and world-renowned expert on emerging eBusiness Intelligence Technologies.

• Author of the best selling book titled, SAP Business Information Warehouse for SAP.

• Member of Intelligent ERP magazine's board of editors, is a frequent speaker at IT industry conferences including SAP TechEd, ASUG, Oracle Open World, DCI, The ERP World, and the Data Warehouse Institute.

• 24+ years of experience in emerging Information Technology research, development, and management, Information Architectures; Enterprise Application Integration e-business; ERP applications; Data Warehousing; Data Mining; CRM; Internet, Object and Client/Server Technologies and Strategic Consulting.

• Email- nhahsmi@infoframeworks Web Site: http://infoframeworks.com Tel: 603-432-4550

Naeem Hashmi


Agenda

• The Extraprise Information Factory – EIF - A Technical Information Architecture for the future Enterprise Applications – Technical Architecture - Layers

• Two Major Components of EIF– Business Intelligence– Enterprise Portal

• EIF Implementation Considerations – Performance and Infrastructure• Q&A


Agenda


• Two Major Components of EIF – Business Intelligence– Enterprise Portal



The Extraprise Information Factory-EIF““The Extraprise Information Factory is a Technical The Extraprise Information Factory is a Technical

Architecture to Architecture to constructconstruct and and deploydeploy scalable, scalable, extendable, distributable and integrated solutions extendable, distributable and integrated solutions

needed to support business critical applications.” needed to support business critical applications.”

““The Extraprise Information Factory is a Technical The Extraprise Information Factory is a Technical Architecture to Architecture to constructconstruct and and deploydeploy scalable, scalable,

extendable, distributable and integrated solutions extendable, distributable and integrated solutions needed to support business critical applications.” needed to support business critical applications.”

Loose

ly C

ouple

d Inte

gra

tion

Tig

htl

y C

ouple

d Inte

gra

tion

File Based data/transaction IntegrationO

n-d

em

and

Inte

gra

tion

The Extraprise Information Factory, Webcast, searchSAP.com Jan 8, 2002


Agenda


• Two Major Components of EIF – Business Intelligence– Enterprise Portal



Business Intelligence Building Blocks Business Intelligence is an umbrella term, introduced by Business Intelligence is an umbrella term, introduced by

Howard Dresner of the GartnerGroup in 1989 to describe Howard Dresner of the GartnerGroup in 1989 to describe a set of concepts and methodologies to improve decision a set of concepts and methodologies to improve decision making in business through the use of facts and fact-based making in business through the use of facts and fact-based systems.systems.

Business Intelligence is an umbrella term, introduced by Business Intelligence is an umbrella term, introduced by Howard Dresner of the GartnerGroup in 1989 to describe Howard Dresner of the GartnerGroup in 1989 to describe a set of concepts and methodologies to improve decision a set of concepts and methodologies to improve decision making in business through the use of facts and fact-based making in business through the use of facts and fact-based systems.systems.

What is Business Intelligence ?

Business Intelligence ApplicationsBusiness Intelligence Applications

• • Executive Information SystemsExecutive Information Systems• • Decision Support SystemsDecision Support Systems• • Enterprise Information SystemsEnterprise Information Systems• • Management Support Systems Management Support Systems • • OLAP (On-Line Analytical Processing)OLAP (On-Line Analytical Processing)

as well as technologies such as:as well as technologies such as:• • Data MiningData Mining• • Data VisualizationData Visualization• • Geographic Information SystemsGeographic Information Systems

Today, Business Intelligence Today, Business Intelligence goes beyond traditional goes beyond traditional definition that includes: definition that includes:

• • Balanced Score CardsBalanced Score Cards

• • Click-Stream AnalysisClick-Stream Analysis

• • CRM AnalyticsCRM Analytics

• • SCM AnalyticsSCM Analytics

• • Closed-Loop AnalyticClosed-Loop Analytic

• • Full-Circle AnalyticsFull-Circle Analytics


What is SAP Business Intelligence?

• SAP Business Intelligence consists of the following Solutions:– SAP Business Information Warehouse

• Data Warehousing Solution

– Business Analytics • Business Content

– Knowledge Warehouse• Knowledge Management

– Enterprise Portal• Information Integration and Delivery

+420 InfoCubes

+90 ODS Objects

+1700 Queries


SAP Business Information Warehouse - BW

• What is SAP BW ?– A complete Data Warehouse

Solution.– SAP BW also comes with rich set of

pre-defined analytical applications (known as business content) common to all business analytical and reporting needs

– Integrated with SAP Business Applications

– Analytical Applications platform for other SAP applications

DataExtraction

Transformation

Data WarehouseData Warehouse

Reports

Data Sources

Reporting and Analysis

Data Access


SAP BW – InfrastructureD

ata

Sou

rces

Data

Man

ag

em

en

tIn

form

ati

on

Con

sum

ers

Meta Data Manager

Meta Data Manager

OLTP Reporting

OLTP Reporting

Business InformationWarehouse Server

Meta DataRepositoryMeta DataRepository

Administrator

Workbench

Administrator

WorkbenchAdministrationAdministration

SchedulingScheduling

MonitorMonitor

Data Manager

Data Manager

OLAP ProcessorOLAP Processor

InfoCubesInfoCubes

OperationalData Store


BusinessDocumentServices


Other Data

Providers

BAPIBAPI

Staging EngineStaging Engine

R/3 OLTP ApplicationsR/3 OLTP Applications

Production DataExtractor


Non R/3 Production Data Extractor


Non R/3 OLTP ApplicationsNon R/3 OLTP Applications

HUB AND

SPOKESERVICES

HUB AND

SPOKESERVICES

CustomersSuppliers

MobileWorkforce

InternalWorkforce

WEB

BAPIODBO


SAP BW – Data Sourcing

DATABASE SERVER

APPLICATION SERVER

DB Connect


SAP BW - Information Access

InfoCube

OLAP ENGINE

ODS Object

MOLAP Cube

3rd Party Client Application

ODBO

Source: “Business Information Warehouse for SAP” by Naeem Hashmi, Prima, 2000

MDXDataset

Query Cubes

SAP Enterprise Portal

SAP R/3SAP R/3 Non-SAP R/3

Non-SAP R/3

BExBEx

DATABASE SERVER

ETL/STAGINGETL/STAGING

APPLICATION SERVER


Enterprise Data Warehouse Performance Assurance Metrics

Data Extraction Time

Data Scrubbing TimeData Transformation Time

Data Load TimeQuery Response Time

Backup/Recovery Time

Data Delivery Time

Number of Users

Query ComplexityNetwork Topology

Data Storage

Security


Agenda





SAP Enterprise Portal

• What is a portal anyway?– Portal is much more than an Interactive flashy Web Site to publish

reports or marketing material– Enterprise Portal is a web based business-critical system

• Integrated information view and business applications • Seamless integration between BI, OLTP and Knowledge Management

Systems• A collaborative environment

• Classes of Portals– Information Portals– Functional Portals– Industry Specific Portals– Enterprise Portals


SAP Enterprise Portal - Characteristics

1. Information Centric2. Personalization3. Customization4. Content Aggregation5. Collaboration6. Integration7. Publishing and Distribution8. Searching, Indexing9. Taxonomy and Categorization10.Security

Groupware

Groupware

CRMCRM ........Business ApplicationBusiness ApplicationSAPSAP WebWeb

Portal client

Information sources

Po

rtal C

on

ten

t Dir

BI Unifica-tion KM Y!

iViewServer

Portal Builder Use

r/Ro

le M

gm

t

Enterprise Portal Solution

Source: SAP


SAP Enterprise Portal - Building Blocks

AD

MIN

ISTR

AT

ION

AD

MIN

ISTR

AT

ION

CLIENT (Internet Browsers, Mobile Devices, etc.)CLIENT (Internet Browsers, Mobile Devices, etc.)

INFORMATION SOURCES (Data Warehouses, Analytics, Documents, Web Content, etc.)INFORMATION SOURCES (Data Warehouses, Analytics, Documents, Web Content, etc.)

DEVELOPMENTDEVELOPMENTKNOWLEDGE MANAGEMENTKNOWLEDGE

MANAGEMENT INTEGRATIONINTEGRATION SECURITYSECURITY

Content ManagementContent Management

Retrieval&ClassificationRetrieval&Classification

CollaborationCollaboration

Unification EngineUnification Engine

Unifiers for

OLTP, ERP

BI Analytics

Etc.

Unifiers for

OLTP, ERP

BI Analytics

Etc.

Content DirectoriesContent Directories

Personalization

Customization

Roles

Services Metadata

Personalization

Customization

Roles

Services Metadata

LDAP

Basic Authentification

Corporate LDAP

Single Signon

Basic Authentification

Corporate LDAP

Single Signon


SAP Enterprise Portal InfrastructureIn

form

ati

on

Sou

rces

Info

rmati

on

Man

ag

em

en

tIn

form

ati

on

Con

sum

ers

External.External.ContentContent

PortalPortalRepositoryRepository

DirectoryDirectory& Security& Security

PortalPortalServerServer

PortalPortalComponentComponentServersServers

• Search engines• Index crawlers• Content servers• Categorization

servers• Application /Content

integration servers• Application servers

• Search engines• Index crawlers• Content servers• Categorization

servers• Application /Content

integration servers• Application servers

DataKnowledgeWarehouse

Web Server

CustomersSuppliers

MobileWorkforce

InternalWorkforce

InternalContent

BusinessApplications


Enterprise Portal Performance Assurance Metrics

Information Acquisition

Taxonomy/GroupingIndexing

Content Load TimeContent Retrieval


InformationAggregation and Integration

Number of Users

Query ComplexityNetwork Topology

Information Storage

Roles/Security


Agenda





Enterprise Information Management Performance Assurance Metrics

Information Acquisition

Taxonomy/GroupingIndexing

Content Load TimeContent Retrieval


InformationAggregation and Integration

Number of Users

Query Complexity

Network Topology

Information Storage

Roles/Security

Data Extraction Time

Data Scrubbing TimeData Transformation Time

Data Load TimeQuery Response Time


Data Delivery Time

Number of Users

Query Complexity

Network Topology

Data Storage

Security

Business IntelligenceBusiness IntelligenceBusiness IntelligenceBusiness Intelligence Enterprise PortalEnterprise PortalEnterprise PortalEnterprise Portal


SAP BW and SAP Enterprise Portal Infrastructure

Info

rmati

on

Sou

rces

Info

rmati

on

Man

ag

em

en

tIn

form

ati

on

Con

sum

ers

ExternalExternal..

ContentContent

PortalPortalRepositoryRepository

DirectoryDirectory& Security& Security

PortalPortalServerServer

PortalPortalComponentComponentServersServers

DataKnowledgeWarehouse

Web Server

CustomersSuppliers

MobileWorkforc

e

InternalWorkforce

InternalContent

BusinessApplications

Meta Data Manager

Meta Data Manager

OLTP Reporting

OLTP Reporting

Business InformationWarehouse Server

Meta DataRepositoryMeta DataRepository

Administrator

Workbench

Administration

Administration

SchedulingScheduling

MonitorMonitor

Data Manager

Data Manager

OLAP ProcessorOLAP Processor

InfoCubesInfoCubes





Other Data

Providers

BAPIBAPI

Staging EngineStaging Engine

R/3 OLTP ApplicationsR/3 OLTP Applications


Production DataExtractorNon R/3 Production Data

Extractor


Non R/3 OLTP ApplicationsNon R/3 OLTP Applications

HUB AND

SPOKESERVICES

CustomersSuppliers

MobileWorkforce

WEB

BAPIODBO


Loose

ly C

ou

ple

d In

teg

rati

on

Tig

htl

y C

ou

ple

d In

teg

rati

on

File Based data/transaction Integration

On

-dem

an

d In

teg

rati

on

• So Many Components– Servers: Database, Application, Web, Network, Security– Software: Applications, Integration, Analytics, Portals

• Data Center Readiness – Much easier to prototype solution but how to keep all servers,

software components up an running without going through the hoops is a challenge?

• Availability – Round the Clock– Low Latency

• Scalability– Large data volumes/users

• Loads/Analysis/Access

• Performance– Loads/Analysis/Access

EIF Implementation Issues


Business Intelligence and Enterprise Portal• Reduced Components

– ERP Centric– Mainframe Centric– Hardware Architecture

• Data Center Readiness – Data Center Management – Disaster Recovery– Availability

• Scalability– Large Volumes– Processing– Reduced Network Traffic

Loose

ly C

ou

ple

d In

teg

rati

on

Tig

htl

y C

ou

ple

d In

teg

rati

on

File Based data/transaction Integration

On

-dem

an

d In

teg

rati

on

EIF Implementation Requires Platform

MS Provider(AFD) SMB

Server SMB Redir

NamedPipes

SAP APP SERVER

Nt OLE

OSFDCERPC

WINSOCK

DLLNETBIOS

TCP

NBTNet

BEUI

NWNB

LinkNW Link

IP

NullXport

NDISDriver

NETWORKADAPTER DRIVER

NETWORK INTERFACECARD

MS Provider(AFD)SMB

Server SMB Redir

NamedPipes

SAP DATA BASE SERVER

Nt OLE

OSFDCERPC

WINSOCK

DLLNETBIOS ES7000 CROSS BAR

TCP

NBTNet

BEUI

NWNB

LinkNW Link

IP

NullXport

NDISDriver

NETWORKADAPTER DRIVER

NETWORK INTERFACECARD

ES7000 CROSS BAR

SAPMNT SAP SOCKET SAPMNTSAP SOCKET

One Mainframe - Multiple Personalities

A True Windows Based Mainframe

ES7000


Agenda





Q&A

Naeem HashmiChief Technology Officer

Information Frameworks

e-mail: [email protected]

Web: http://infoframeworks.com

Tel: 603-432-4550

SAP Enterprise Portal, SAP Business SAP Enterprise Portal, SAP Business Information Warehouse and the Extraprise Information Warehouse and the Extraprise Information FactoryInformation Factory

This presentation is also available at This presentation is also available at http://infoframeworks.comhttp://infoframeworks.com

1 1 copyrights 2002: information frameworks. naeem hashmi enterprise portal, business information...

Documents

cto of information frameworks

naeem hashmi slide

naeem hashmi enterprise

naeem hashmi agenda

business critical applications

infrastructure qa slide

demand integration

datatransaction integration