1. sap hana overview & history
TRANSCRIPT
-
7/25/2019 1. SAP HANA Overview & History
1/21
SAP HANA
-
7/25/2019 1. SAP HANA Overview & History
2/21
Agenda
ERP
SAP ERP Introduction.
Datawarehouse. SAP HANA.
-
7/25/2019 1. SAP HANA Overview & History
3/21
ERP
ERP is the abbrevation for Enterprise Resource Planningand eans the techi!ues and concepts for integratedanageent of businesses as a whole fro a viewpointof effective use of anageent resources to iproveefficinec" of enterprise anageent.
ERP integrates all business functions into a single #integrated software progra that runs on a singledatabase so that various departents can ore easil"share inforation and coinicate with each other.
$he integarted approach of ERP has treendous powerand potential in iproving the efficienc" # productivit" andcopetitiveness of the organi%ation.
-
7/25/2019 1. SAP HANA Overview & History
4/21
ERP
Different ERP Software solutions vendors in the ar&et are
SAP
'racle
(icrosoft D"naics RA()'
*AAN++
SAP is the ar&et leader in ERP software solutions.
-
7/25/2019 1. SAP HANA Overview & History
5/21
Agenda
ERP
SAP ERP Introduction. Datawarehouse.
SAP HANA.
-
7/25/2019 1. SAP HANA Overview & History
6/21
SAP Introduction
SAP Enterprise Resource Planning is a product of SAPA,# which is a ,eran based copan" head!uartered
at -alldorf. $he priar" obective is to develop standard
application software for real/tie business processing.
SAP eans S"stes Applications and Products in DataProcessing.
0ounded in 1234 b" -ellenreuther # Hopp # Hector #
Plattner and $shira
SAP is the nae of the copan" as well as ERP Product SAP s"ste coprises of a nuber of full" integrated
odules# which covers virtuall" ever" aspect of the
business.
-
7/25/2019 1. SAP HANA Overview & History
7/21
SAP ERP *enefits
Increases Return on Investent 5R'I6 Decreases $otal )ost of 'wnership 5$)'6
Eliinates the discontinuit" and duplication of data.
Satisf"ing Partners and )ustoers.
Reducing re!uired (anpower. Iprove productivit" and insight.
Support changing industr" re!uireents.
'ptii%e I$ spending.
SAP ERP delivers a coprehensive set of integrated#cross/functional business processes.
-
7/25/2019 1. SAP HANA Overview & History
8/21
Agenda
ERP
SAP ERP Introduction.
Datawarehouse. SAP HANA.
-
7/25/2019 1. SAP HANA Overview & History
9/21
Data -arehouse / Definition
A Data Warehouse is a subject-oriented,
integrated, time-variant, non-volatile collection of
data in support of Managers decision making
process.////*ill Inon 50ather of Data -arehousing6
-
7/25/2019 1. SAP HANA Overview & History
10/21
Data -arehousing
Subject Oriented / Data that gives inforation about a particular subect
instead of about a copan"7s ongoing operations.
Integrated
/ Data that is gathered into the data warehouse fro a variet" ofsources and erged into a coherent whole.
Non Volatile
/ Data is stable in a data warehouse. (ore data is added but datais never reoved. $his enables anageent to gain a consistentpicture of the business.
Time Variant8All data in the data warehouse is identified with a particular tie
period.
-
7/25/2019 1. SAP HANA Overview & History
11/21
Purpose
Data warehousing fors the basis of an e9tensive businessintelligence solution that allows "ou to convert data into valuable
inforation.
Integrated and copan"/specific data warehousing provides
decision a&ers in "our copan" with inforation and &nowledge
about goal/oriented easures that will lead to the success of thecopan".
0or data fro an" source 5SAP or non/SAP sources6 and of an"
age 5historic or current6# Data warehousing in *I allows:
/ Integration 5data ac!uisition fro source s"stes6
/ $ransforations
/ )onsolidation
/ )lean up
/ Storage
/ Retrieval for anal"sis and interpretation
-
7/25/2019 1. SAP HANA Overview & History
12/21
$ransfor Data into ;nowledge
$he ore data a copan" has# the harder it is to a&e decisions )opanies are focusing on the collection of data# but not on the
use of it.
Where is the wisdom?
-
7/25/2019 1. SAP HANA Overview & History
13/21
-h" do )opanies do *usiness
Intelligence
=> 1=> 4=> ?=> @=> A=>
!etter data or decisions
"aster decisions
#om$etiti%e ad%antages
#ost reduction
&nter$rise'wide data access
Increased re%enue
New business o$$ortunities
Source: 0orrester
-
7/25/2019 1. SAP HANA Overview & History
14/21
*asic )oncepts 8 Datawarehousing
A s"ste with its own database.
Designed to support !uer" and anal"sis
Database design techni!ue 8 Star schea
E$$< 8 E9tracting# $ransferring# $ransforing and
-
7/25/2019 1. SAP HANA Overview & History
15/21
Distinction between the 'perative B
Inforative Environent
-
7/25/2019 1. SAP HANA Overview & History
16/21
#haracteristics O(TP O(AP
Priar" 'peration $o control and runfundaental business tas&s
$o help with planning#proble solving# anddecision support
Source of data 'perational dataC '
-
7/25/2019 1. SAP HANA Overview & History
17/21
Agenda
ERP
SAP ERP Introduction. Datawarehouse.
SAP HANA
-
7/25/2019 1. SAP HANA Overview & History
18/21
SAP HANA
SAP HANAis SAP A)*s ipleentation of in/eor" database technolog".
$here are five coponents within the software group:
SAP HANA +!5or HANA D*6 refers to the database technolog" itself#
SAP HANA Studiorefers to the suite of tools provided b" SAP for
odeling#
SAP HANA A$$liancerefers to HANA D* as delivered on partner certified
hardware 5see below6 as an appliance. It also includes the odeling tools
fro HANA Studio as well as replication and data transforation tools to
ove data into HANA D*.
SAP HANA Onerefers to a deplo"ent of SAP HANA certified for
production use on the Aa%on -eb Services 5A-S6 cloud.
SAP HANA A$$lication #loudrefers to the cloud based infrastructure fordeliver" of applications 5t"picall" e9isting SAP applications rewritten to run
on HANA6.
-
7/25/2019 1. SAP HANA Overview & History
19/21
SAP HANA Histor,
$he support pac&ages to date have been: SP-8 released 4= Noveber 4=1=C HANA first public release.
SP.8 released 4= Gune 4=11C HANA general availabilit" 5,A6C focus
is as an operation data art.
SP/8 released 43 Gune 4=11C ore data art functions.
SP0a.&.a HANA 1. 8 released 3 Noveber 4=116C focus is on
HANA as the underl"ing database under *usiness -arehouse
5*-6C also naed Project range.
SP18 4# 4=14C resolved a variet" of stabilit" issues and add new
features for *-# according to SAP.
SP28 0eb# 4=1?C introduces E9tended Application
-
7/25/2019 1. SAP HANA Overview & History
20/21
$"pes of Data
$he following are t"pes of Data with respect to SAP *-.
(aster Data: (aster data is data that reains unchanged over a
long period of tie. It contains inforation that is alwa"s needed in
the sae wa". )haracteristics can bear aster data in *-. -ith
aster data "ou are dealing with attributes# te9ts and hierarchies.
$ransaction data: Data relating to the da"/to/da" transactions is the
$ransaction data.
(eta Data: Data that describes the structure of data or (eta'bects
is called (etadata. In other words data about data is &nown as (eta
Data.
-
7/25/2019 1. SAP HANA Overview & History
21/21
uestions