PUBLIC
SAP HANA Data Warehousing Foundation 1.0 SPS 05
Document Version: 1.0 – 2016-10-14
SAP HANA Data Warehousing Foundation
Installation Guide
Content
1 Introduction.................................................................. 3
1.1 About SAP HANA Data Warehousing Foundation.........................................3
Overview of Data Distribution Optimizer Architecture................................... 4
Overview of Data Lifecycle Manager Architecture......................................5
1.2 Supported Browsers.............................................................6
1.3 Software Download..............................................................6
2 Planning and Preparation........................................................ 7
3 Installing or Updating SAP HANA Data Warehousing Foundation..........................9
3.1 Install or Update SAP HANA Data Warehousing Foundation.................................10
4 Configuring SAP HANA Data Warehousing Foundation................................. 11
4.1 Check the Configuration of the HTTP or HTTPS Port......................................11
4.2 Configure SAP HANA System Properties.............................................. 11
4.3 Activate SQL Connection Configurations..............................................12
4.4 User Authorization..............................................................13
Privileges for Working with Data Distribution Optimizer................................. 14
Privileges for Working with Data Lifecycle Manager.................................... 15
Create and Authorize Users.....................................................18
4.5 Configuring Data Distribution Optimizer.............................................. 20
Configure Database Traces.....................................................20
Check for Data Distribution Optimizer Readiness......................................21
4.6 Configuring Data Lifecycle Manager..................................................21
Preparing Storage Destinations..................................................22
Check for Data Lifecycle Manager Readiness........................................ 26
Generate Default Schema for Generated Objects and Roles Needed for Data Lifecycle Manager
.........................................................................26
5 Uninstalling SAP HANA Data Warehousing Foundation.................................28
2
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Content
1 Introduction
This installation guide describes how to install SAP HANA Data Warehousing Foundation tools, such as Data
Distribution Optimizer or Data Lifecycle Manager.
SAP HANA Data Warehousing Foundation is provided with delivery units. The delivery units are contained in
software component archive files that can be installed with SAP HANA application lifecycle management.
Related Information
Section SAP HANA Content in the SAP HANA Master Guide on http://help.sap.com/hana_platform
1.1 About SAP HANA Data Warehousing Foundation
The SAP HANA Data Warehousing Foundation option is a series of packaged tools for large-scale SAP HANA
installations which support data management and distribution within a SAP HANA landscape.
With SAP HANA Data Warehousing Foundation, you can achieve smart data distribution across complex
landscapes, optimize the memory footprint of data in SAP HANA and streamline administration and development.
This helps to reduce TCO and support SAP HANA administrators and data warehouse designers.
SAP HANA Data Warehousing comprises specialized SAP HANA XS-based applications:
● Data Distribution Optimizer to plan, adjust and analyze landscape reorganizations for SAP HANA scale-out
systems.
The main purpose of the Data Distribution Optimizer is to help the SAP HANA administrator to manage the
distribution of tables and to optimize the allocation of SAP HANA memory in a SAP HANA scale-out landscape
(multiple-host system). The redistribution algorithm has to reflect the relationship between single tables as
well as constraints imposed by the landscape itself, such as allocation limits and server roles (master or slave
for example).
● Data Lifecycle Manager to deliver the means of displacing data from SAP HANA persistency.
With Data Lifecycle Manager, you can leverage storages such as SAP HANA Dynamic Tiering, Hadoop (Spark
SQL) or SAP IQ in SAP HANA native use cases to define aging rules on SAP HANA tables. This tool-based
approach is used in order to optimize the memory footprint of data in SAP HANA.
SAP HANA Data Warehousing Foundation Installation Guide
Introduction
P U B L I C 3
1.1.1 Overview of Data Distribution Optimizer Architecture
Data Distribution Optimizer is composed of the components shown in the graphic below.
The Data Distribution Optimizer user interfaces are based on SAPUI5 technology and run in a Web browser.
The SAP HANA Data Warehousing Foundation Reuse Core component (delivery unit HCO_HDM) provides base
services, such as scheduling or locking, that can be used by any of the SAP HANA Data Warehousing Foundation
tools.
The SAP HANA Data Warehousing Foundation Data Distribution Optimizer Core component (delivery unit
HCO_HDM_DDO) contains Data Distribution Optimizer specific logic, such as the logic for generating
redistribution plans.
The SAP HANA Core Distribution Services contain modules that SAP HANA Data Warehousing Foundation calls in
the SAP HANA core, such as database procedures REORG_GENERATE and REORG_EXECUTE.
4
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Introduction
1.1.2 Overview of Data Lifecycle Manager Architecture
Data Lifecycle Manager is composed of the components shown in the graphic below.
The Data Lifecycle Manager user interfaces are based on SAPUI5 technology and run in a Web browser.
The SAP HANA Data Warehousing Foundation Reuse Core component (delivery unit HCO_HDM) contains a suite
of reuse functionalities, such as scheduling or locking, that can be used by any of the SAP HANA Data
Warehousing Foundation tools.
The SAP HANA Data Warehousing Foundation Data Lifecycle Manager Core component (delivery unit
HCO_HDM_DLM) contains Data Lifecycle Manager-specific functionality and services:
● Data Lifecycle Manager engine
The Data Lifecycle Manager engine contains services for creating lifecycle profiles, creating storage
destination instances and executing relocation jobs, for example.
● Relocation agents
Relocation agents provide the interface to the corresponding storage destinations, for example the relocation
agent for SAP HANA Dynamic Tiering, Hadoop (Spark SQL) or SAP IQ.
● Persistence object services
Persistence services provide a common set of DDL/DML functionalities specific to a particular persistence
object. Relocation agents are the main consumers of the persistence services. Relocation Agents pass among
other context, also the connection object to the Persistence Services. Persistence Services are specific to
Storage Destinations (table service for Dynamic Tiering, for example).
SAP HANA Data Warehousing Foundation Installation Guide
Introduction
P U B L I C 5
The storage destinations specify instances of the storage stack to which the data can be moved to. These
instances must be created before they can be assigned for relocation purposes.
1.2 Supported Browsers
For an overview of the supported browsers, see the Product Availability Matrix for SAP HANA Data Warehousing
Foundation 1.0.
Related Information
SAP HANA Data Warehousing Foundation 1.0 Planning Product Availability Matrix (Planning PAM)
1.3 Software Download
In the SAP Software Download Center, you have access to the installation media for SAP HANA Data Warehousing
Foundation.
You can find the installation media under SAP Software Download Center Support Packages and Patches
Software Downloads SUPPORT PACKAGES & PATCHES By Alphabetical Indes (A-Z) H SAP HANA DW
FOUNDATION SAP HANA DW FOUNDATION 1.0 COMPRISES SOFTWARE COMPONENT VERSIONS
● DATA LIFECYCLE MANAGER 1
● DATADISTRIBUTIONOPTIMIZER 1
● HANA DATA MANAGEMENT 1
● HANA DWF DOCU 1
Note
We strongly recommend keeping the various SAP HANA Data Warehousing Foundation software components
and delivery units on the same Support Package Stack (SPS) and patch level.
Note that the SAP HANA Data Warehousing Foundation software is complete. You can install the most recent
and appropriate SAP HANA Data Warehousing Foundation SPS and patches. There is no need to install earlier
patches or to perform an additional upgrade.
Related Information
SAP Software Download Center
6
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Introduction
2 Planning and Preparation
You need to perform a number of planning and preparation steps.
1. Before installing or updating SAP HANA Data Warehousing Foundation, see SAP Note 2092669 - Release
Note SAP HANA Data Warehousing Foundation.
2. Before installing SAP HANA Data Warehousing Foundation SPS 05, install or upgrade SAP HANA to SAP
HANA revision 120 (SPS 12) or a higher SPS 12 revision.
Note
○ The SAP HANA Data Warehouse Foundation delivery units have dependencies to the SAP HANA SPS
versions as described in the Product Availability Matrix for SAP HANA Data Warehousing Foundation
1.0. These are as follows:
SAP HANA Data Warehousing Foundation (SAP
HANA DWF) Version
SAP HANA Version
SAP HANA DWF 1.0 SPS 00 SAP HANA SPS08
SAP HANA DWF 1.0 SPS 01 SAP HANA SPS09
SAP HANA DWF 1.0 SPS 02 SAP HANA SPS10
SAP HANA DWF 1.0 SPS 03 SAP HANA SPS11
SAP HANA DWF 1.0 SPS 05 SAP HANA SPS12
For more information about supporting SAP HANA versions, see SAP Note 2092669 - Release Note
SAP HANA Data Warehousing Foundation.
○ In a multiple-container system, you cannot use Data Distribution Optimizer in the system database,
although you can use it in any of the tenant database containers.
3. When you want to use SAP HANA Dynamic Tiering as storage destination in Data Lifecycle Manager, install or
upgrade SAP HANA Dynamic Tiering to SAP HANA revision 120 (SPS 12) or a higher SPS 12 revision.
4. Provide a user for the installation and configuration tasks, and grant this user the relevant roles and privileges.
We recommend using the SYSTEM database user for this purpose. For more information, see section
SYSTEM User in the SAP HANA Administration Guide.
5. SAP HANA Data Warehousing Foundation depends on SAP HANA automated content. You should therefore
make sure that SAP HANA automated content is installed properly. For more information on automated
content, see section SAP HANA Content in the SAP HANA Administration Guide.
6. Note that we strongly recommend keeping all SAP HANA Data Warehousing Foundation software
components and delivery units on the same Support Package Stack (SPS) and Patch level, 1.0 SPS 05 Patch
0 for all delivery units for example. For more information, see SAP Note 2092669 - Release Note SAP HANA
Data Warehousing Foundation.
7. For Data Distribution Optimizer, the statistics service has to be active. For more information, see section The
Statistics Service in the SAP HANA Administration Guide.
SAP HANA Data Warehousing Foundation Installation Guide
Planning and Preparation
P U B L I C 7
Related Information
● Section Installing SAP HANA in the SAP HANA Master Guide at http://help.sap.com/hana_platform
● https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/HDW10PAM.pdf
● 2092669 - Release Note SAP HANA Data Warehousing Foundation
● Sections SYSTEM User and SAP HANA Content in the SAP HANA Administration Guide at http://
help.sap.com/hana_platform
● Section The Statistics Service in the SAP HANA Administration Guide on http://help.sap.com/hana_platform
8 P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Planning and Preparation
3 Installing or Updating SAP HANA Data
Warehousing Foundation
SAP HANA Data Warehousing Foundation content is delivered in software components. Each software
component contains a functional delivery unit (independent delivery units) and a language delivery unit.
Functional delivery units provide core services, SAP HANA Data Warehousing Foundation applications, and
documentation for the applications. Language delivery units provide translated and quality-assured texts for SAP
HANA Data Warehousing Foundation.
The following table provides an overview of the SAP HANA Data Warehousing Foundation software components
and the delivery units they contain:
Software Component Archive File Delivery Units Description
HCOHDM<Support Package
Stack_<Patch>-<material number of
software component>.ZIP
Functional: HCO_HDM Core delivery unit containing reuse serv
ices, such as a scheduler or lock man
ager
Language: LANG_HCO_HDM Delivery unit containing revised texts for
HCO_HDM
HCOHDMDDO<Support Package
Stack_<Patch>-<material number of
software component>.ZIP
Functional: HCO_HDM_DDO Delivery unit containing the Data Distri
bution Optimizer application
Language: LANG_HCO_HDM_
DDO
Delivery unit containing revised texts for
HCO_HDM_DDO
HCOHDMDLM<Support Package
Stack_<Patch>-<material number of
software component>.ZIP
Functional: HCO_HDM_DLM Delivery unit containing the Data Lifecy
cle Manager application
Language: LANG_HCO_HDM_
DLM
Delivery unit containing revised texts for
HCO_HDM_DLM
HDCHDM<Support Package
Stack_<Patch>-<material number of
software component>.ZIP
Functional: HDC_HDM Documentation delivery unit containing
help that can be accessed directly from
the application (embedded help)
Note
SAP HANA Data Warehousing Foundation is delivered in English only.
Related Information
Section SAP HANA Archive Types in the SAP HANA Administration Guide on http://help.sap.com/hana_platform
SAP HANA Data Warehousing Foundation Installation Guide
Installing or Updating SAP HANA Data Warehousing Foundation
P U B L I C 9
3.1 Install or Update SAP HANA Data Warehousing
Foundation
You install or update SAP HANA Data Warehousing Foundation with SAP HANA application lifecycle management.
Context
Note
We strongly recommend keeping all SAP HANA Data Warehousing Foundation software components and
delivery units on the same Support Package Stack (SPS) and Patch level, 1.0 SPS 05 Patch 0 for all delivery
units for example.
See SAP Note 2092669 - Release Note SAP HANA Data Warehousing Foundation before installing or
updating SAP HANA Data Warehousing Foundation.
Procedure
1. Download the software component archive files (.zip) from the SAP Support Portal to a file directory on your
local machine. Do not extract the archive files.
2. Proceed as described in section Installing and Updating SAP HANA Software Components in the SAP HANA
Administration Guide.
Caution
To make sure that installation is performed correctly, the files have to be installed in the following order of
delivery units:
1. HCO_HDM
2. HCO_HDM_DDO / HCO_HDM_DLM
3. HDC_HDM
Related Information
Section Installing and Updating SAP HANA Software Components in the SAP HANA Administration Guide on
http://help.sap.com/hana_platform
10
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Installing or Updating SAP HANA Data Warehousing Foundation
4 Configuring SAP HANA Data Warehousing
Foundation
Once you have completed the installation, you need to perform configuration tasks to set up the system for using
SAP HANA Data Warehousing Foundation.
4.1 Check the Configuration of the HTTP or HTTPS Port
In the instance profile of your SAP Web Dispatcher, you can check whether the HTTP or HTTPS port has been
configured for the SAP HANA XS web server.
Procedure
1. Open the instance profile of your SAP Web Dispatcher.
The SAP Web Dispatcher profile can be found at the following location in the SAP HANA studio:
SAP HANA Administration Console Configuration webdispatcher.ini [profile]
2. Check the HTTP/S port settings in the SAP Web Dispatcher profile.
Alternatively, access both SAP HANA XS Administration Tool URL options:
● http://<WebServerHost>:80<SAPHANAinstance>/sap/hana/xs/admin/
● https://<WebServerHost>:80<SAPHANAinstance>/sap/hana/xs/admin/
4.2 Configure SAP HANA System Properties
You change specific system properties in the configuration file of the SAP HANA XS engine in order to configure
SAP HANA Data Warehousing Foundation.
Prerequisites
You have the system privilege INIFILE ADMIN.
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 11
Procedure
1. In the Administrator editor of the SAP HANA Administration Console, choose the Configuration tab.
A list of all configuration files appears.
2. Expand the xsengine.ini file and set the following parameters:
Relevant for ...
Section Parame
ter Key
Parameter Value Reset the Value (when uninstal
ling the software)
Data Distribution Opti
mizer
jsvm max_runti
me_bytes
at least 268435456
Note
This is the minimum volume
that is needed to run the Data
Distribution Optimizer applica
tion.
If
jsvm.max_runtime_bytes was
changed for SAP HANA Data
Warehousing Foundation only, you
can reset it to the previous value
from the context menu.
○ Data Distribution
Optimizer
○ Data Lifecycle
Manager
scheduler
enabled
true
If scheduler.enabled was enabled
for SAP HANA Data Warehousing
Foundation only, you can delete
the parameter value from the con
text menu.
○ Data Distribution
Optimizer
○ Data Lifecycle
Manager
Trace
xsa:sap.h
dm
error
To reset trace.xs:sap.hdm, you can
delete the parameter value from
the context menu.
If a section and/or parameter is not available, you can add it to the xsengine.ini file. Sections can be added
from the context menu of the xsengine.ini file. Parameters can be added from the context menu of the
section.
Related Information
Sections Configuring SAP HANA System Properties (INI Files), and SAP HANA XS Configuration Parameters in the
SAP HANA Administration Guide on http://help.sap.com/hana_platform
4.3 Activate SQL Connection Configurations
In SAP HANA Extended Application Services (SAP HANA XS), you use the SQL connection configuration to enable
the execution of SQL statements from your server-side JavaScript application, using credentials that are different
to the credentials of the requesting user. Data Distribution Optimizer and Data Lifecycle Manager use this
mechanism, for example when generating and executing redistribution plans in Data Distribution Optimizer.
12
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
Prerequisites
You have been granted the SAP HANA user role sap.hana.xs.admin.roles::SQLCCAdministrator.
Procedure
1. Start the SAP HANA XS Administration Tool.
Depending on whether the HTTP or HTTPS port has been configured, the SAP HANA XS Administration Tool is
available on the SAP HANA XS Web server at one of the following URLs:
○ http://<WebServerHost>:80<SAPHANAinstance>/sap/hana/xs/admin
○ https://<WebServerHost>:43<SAPHANAinstance>/sap/hana/xs/admin
2. Start the SAP HANA XS Artifact Administration tool.
3. In the Application Objects list, locate the following packages:
○ For Data Distribution Optimizer and Data Lifecycle Manager: sap.hdm.core.sudo
○ For Data Distribution Optimizer: sap.hdm.ddo.sudo
4. For the relevant packages, select the SQL connection configuration object sudo.xssqlcc.
5. Click Activate to set the run-time status of the XS SQL connection configuration to Active.
Results
Data Distribution Optimizer redistribution plans will be generated or executed in the context of the user who is
currently logged on. In order to generate or execute a plan, the user will be prompted to confirm with his/her
password.
Related Information
Section Edit an SQL Connection Configuration in the SAP HANA Administration Guide at http://help.sap.com/
hana_platform
4.4 User Authorization
Every user who is required to work with SAP HANA Data Warehousing Foundation tools must have a database
user. To perform tasks in the tools, the database user must have the required privileges.
SAP HANA Data Warehousing Foundation tools are delivered with a set of roles containing the required privileges
for specific tasks. Appropriate roles have to be granted to the database users working with Data Warehousing
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 13
Foundation. In addition, database users working with SAP HANA Data Warehousing Foundation require further
custom object privileges on entity level (on schema level, for example).
Related Information
Section Roles in the SAP HANA Security Guide on http://help.sap.com/hana_platform
4.4.1 Privileges for Working with Data Distribution Optimizer
4.4.1.1 Roles for Data Distribution Optimizer
The following table describes the roles that provide predelivered application privileges for working with Data
Distribution Optimizer:
Role
Type Task
sap.hdm.ddo.roles::Viewer application This role provides read-only access to view redistribution
plans. It also allows you to view configurations.
sap.hdm.ddo.roles::Administrator application This role has to be granted to the database user who cre
ates Data Distribution Optimizer configurations, generates
redistribution plans, executes the plans, exports plans or
uploads them.
Note
● This role uses the RESOURCE ADMIN system privi
lege, which allows the user to manage data vol
umes for example, and restart the SAP HANA sys
tem. Caution should be exercised when granting
this role. For more information, see the SAP HANA
Security Guide.
● This role also uses the INIFILE ADMIN system privi
lege, which authorizes changing of system settings.
This is neccesary in order to access the M_VOL
UMES system view.
In addition to the privileges provided with this role, this
user needs to have ALTER, EXECUTE and UPDATE priv
ileges for all schemas contained in a redistribution plan.
For more information, see Custom Privileges at Entity
Level for Data Distribution Optimizer [page 15].
14
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
Role Type Task
sap.hdm.ddo.roles::Support SAP internal This role is used for support purposes. It grants read ac
cess to the Data Distribution Optimizer repository pack
ages and code, and allows debugging.
Related Information
Sections Roles and User Types in the SAP HANA Security Guide on http://help.sap.com/hana_platform
4.4.1.2 Custom Privileges at Entity Level for Data
Distribution Optimizer
A number of custom privileges at entity level have to be granted to Database Distribution Optimizer users.
Grant the following object privileges to the user with the sap.hdm.ddo.roles::Administrator role on all database
schemas that redistribution plans should be generated for. If you only want to generate redistribution plans for
SAP BW on SAP HANA for example, grant the following privileges on <BW DB Schema Name> :
object privilege
SQL-ALTER-Statement
ALTER GRANT ALTER ON SCHEMA <DB-SCHEMA NAME> TO <user with the role
sap.hdm.ddo.roles::Administrator>;
UPDATE GRANT UPDATE ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.ddo.roles::Administrator>;
EXECUTE GRANT EXECUTE ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.ddo.roles::Administrator>;
4.4.2 Privileges for Working with Data Lifecycle Manager
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 15
4.4.2.1 Roles for Data Lifecycle Manager
Data Lifecycle Manager is delivered with a set of roles containing privileges required for specific tasks.
Additionally, there is a set of roles that have to be generated during Data Lifecycle Manager configuration. The
generated roles contain the respective predelivered roles plus additional privileges needed to work with the tool.
The following table describes the roles that provide application privileges for working with Data Lifecycle Manager:
Predelivered Role
Generated Role Type Task
sap.hdm.dlm.role::Admin
istrator
sap.hdm.dlm.role.GNR.Ad
ministrator
application The generated role has to be granted to the
database user who maintains storage desti
nations, modeled persistence objects and
lifecycle profiles, and who executes reloca
tion runs.
Note
In addition to the privileges provided with
this role, this user needs to have custom
privileges. For more information, see Cus
tom Privileges at Entity Level for Data Life
cycle Manager [page
16].
sap.hdm.dlm.role::Display sap.hdm.dlm.role.GNR.Dis
play
application This role provides read-only access to view
relocation activities.
sap.hdm.dlm.role::Sup
port
sap.hdm.dlm.role.GNR.Su
pport
SAP internal This role is used for support purposes.
Related Information
● Sections Roles and User Types in the SAP HANA Security Guide on http://help.sap.com/hana_platform
● Custom Privileges at Entity Level for Data Lifecycle Manager [page 16]
4.4.2.2 Custom Privileges at Entity Level for Data Lifecycle
Manager
A number of custom privileges at entity level have to be granted to Data Lifecycle Manager users.
Source Specific Privileges
Grant the following object privileges to the Data Lifecycle Manager logon user (database user) for all tables that
lifecycle profiles should be generated for:
16
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
Object Privilege For example with SQL-ALTER-Statement
SELECT with grant option GRANT SELECT ON <DB-SCHEMA-NAME.TABLE> TO <user with the role
sap.hdm.dlm.role::Administrator> WITH GRANT OPTION;
INSERT GRANT INSERT ON <DB-SCHEMA-NAME.TABLE> TO <user with the role
sap.hdm.dlm.role::Administrator>;
DELETE GRANT DELETE ON <DB-SCHEMA-NAME.TABLE> TO <user with the role
sap.hdm.dlm.role::Administrator>;
Target Specific Privileges
Storage Destination "Spark SQL (Destination)"
Grant the following object privileges to the Data Lifecycle Manager logon user (database user) to enable the use of
Spark SQL (Destination) as the storage destination:
Object Privilege
For example with SQL-ALTER-Statement
CREATE VIRTUAL TABLE GRANT CREATE VIRTUAL TABLE ON REMOTE SOURCE "<Remote Source name>" TO <user
with the role sap.hdm.dlm.role::Administrator>;
DROP GRANT DROP ON REMOTE SOURCE "<Remote Source name>" TO <user with the role
sap.hdm.dlm.role::Administrator>;
You can find the Remote Sources in the SAP HANA Studio in the Systems view under Provisioning Remote
Sources
. For more information about Remote Sources, see SAP HANA Smart Data Access in the SAP HANA
Administration Guide.
Storage Destination "SAP IQ over SDA"
Grant the following object privileges to the Data Lifecycle Manager logon user (database user) to enable the use of
SAP IQ as the storage destination:
Object Privilege
For example with SQL-ALTER-Statement
CREATE VIRTUAL TABLE GRANT CREATE VIRTUAL TABLE ON REMOTE SOURCE "<Remote Source name>" TO <user
with the role sap.hdm.dlm.role::Administrator>;
DROP GRANT DROP ON REMOTE SOURCE "<Remote Source name>" TO <user with the role
sap.hdm.dlm.role::Administrator>;
You can find the Remote Sources in the SAP HANA Studio in the Systems view under Provisioning Remote
Sources
. For more information about Remote Sources, see SAP HANA Smart Data Access in the SAP HANA
Administration Guide.
Also check for the following:
Code Syntax
select * from "PUBLIC"."EFFECTIVE_PRIVILEGES" where USER_NAME = '<user with the
role sap.hdm.dlm.role::Administrator>
' and OBJECT_NAME = '<Remote Source name>';
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 17
Generation Specific Privileges
For storage destination types SAP HANA Dynamic Tiering, SAP IQ over SDA, and Deletion Bin Destination Data
Lifecycle Manger provides default schema SAP_HDM_DLM_GNR as a target database schema for the generated
objects. When creating a storage destination, you can overwrite the default schema. Data Lifecycle Manager then
uses the schema specified in the Parameters section of the storage destination that is assigned to the lifecycle
profile. For storage destination type Spark SQL (DESTINATION), Data Lifecycle Manager uses the schema of the
source persistence object target database schema for the generated objects.
You therefore need to grant the following object privileges to the user with the Data Lifecycle Manger
administrator role on all target database schemas (of lifecycle profiles):
Object Privilege
For example with SQL-ALTER-Statement
EXECUTE GRANT EXECUTE ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.dlm.role::Administrator>;
CREATE ANY GRANT CREATE ANY ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.dlm.role::Administrator>;
INSERT GRANT INSERT ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.dlm.role::Administrator>;
SELECT GRANT SELECT ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.dlm.role::Administrator>;
DELETE GRANT DELETE ON SCHEMA <DB-SCHEMA NAME > TO <user with the role
sap.hdm.dlm.role::Administrator>;
Related Information
● Section SAP HANA Smart Data Access in the SAP HANA Administration Guideon http://help.sap.com/
hana_platform
● Roles for Data Lifecycle Manager [page 16]
4.4.3 Create and Authorize Users
Every user required to work with SAP HANA Data Warehousing Foundation tools must have a database user. To
perform the tasks in the tools, specific roles must be granted to the database user(s) by a user administrator.
Prerequisites
● You have the system privilege USER ADMIN.
● You have the privileges required to grant specific privileges and roles to the new user. For more information,
see Prerequisites for Granting and Revoking Privileges and Roles in the SAP HANA Administration Guide.
● If you are integrating SAP HANA database users into a single-sign on (SSO) environment using one or more of
the supported mechanisms, the required infrastructure must be in place and configured.
18
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
● For Data Lifecycle Manager: You have generated the roles needed for working with the tool. For more
information, see Generate Default Schema for Generated Objects and Roles Needed for Data Lifecycle
Manager [page 26].
Context
The following section describes the procedure for creating and authorizing SAP HANA database users, focusing
on SAP HANA Data Warehousing specific information. For a detailed description of the general procedure, see
Create and Authorize a User in the SAP HANA Administration Guide.
Procedure
1. If the database user that you want to authorize does not exist yet, create the user:
a. In the Systems view, choose Security Users .
b. From the context menu, choose New User.
2. Specify the user name and properties.
3. Authorize the user by granting the required roles and privileges.
a. Grant the required roles for working with SAP HANA Data Warehousing Foundation tools.
Note
For Data Lifecycle Manager you need to grant the roles that have been generated during configuration
of the tool.
b. Grant the appropriate custom privileges at entity level.
4. Save the user by pressing (Deploy).
The user is created and appears in the Users folder. A new schema is also created for the user in the catalog.
This schema has the same name as the user.
Related Information
● Section Provisioning Users in SAP HANA Studio in the SAP HANA Administration Guide on http://
help.sap.com/hana_platform
● Section Generate Default Schema for Generated Objects and Roles Needed for Data Lifecycle Manager in the
SAP HANA Data Warehousing Foundation Installation Guide on http://help.sap.com/hana_options_dwf
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 19
4.5 Configuring Data Distribution Optimizer
For Data Distribution Optimizer, a number of additional configuration steps have to be performed.
4.5.1 Configure Database Traces
You can change the trace level of specific trace components in order to configure Data Distribution Optimizer.
Prerequisites
● In the Administrator editor of the SAP HANA Administration Console on the Configuration tab, the parameter
with key xsa:sap.hdm and value info must have been added to the Trace section of the xsengine.ini file.
● You have been assigned the system privilege TRACE ADMIN.
Procedure
1. In the Administrator editor of the SAP HANA Administration Console, choose the Trace Configuration tab.
2. Choose the Edit Configuration button for the database trace.
The Trace Configuration dialog box appears.
3. Select Show all Components.
4. In the INDEXSERVER service, for the trace component landscapereorg, select INFO from the dropdown menu
of the System Tracel Level column.
5. In the XSENGINE service, for the trace component xsa:sap.hdm, select ERROR from the dropdown menu of
the System Tracel Level column.
Related Information
Sections Database Trace, and Configure Traces in the SAP HANA Administration Guide on http://help.sap.com/
hana_platform
20
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
4.5.2 Check for Data Distribution Optimizer Readiness
Before you start working with the Data Distribution Optimizer, you can check whether the system has been
configured properly.
Procedure
1. Log on to the Data Distribution Optimizer with a Data Distribution Optimizer user that has an appropriate role
assigned.
Depending on whether the HTTP or HTTPS port has been configured, the Data Distribution Optimizer is
available on the SAP HANA XS Web server at one of the following URLs:
○ http://<WebServerHost>:80<SAPHANAinstance>/sap/hdm/ddo/index.html or
○ https://<WebServerHost>:43<SAPHANAinstance>/sap/hdm/ddo/index.html
2. In the header area of the screen, a button indicates whether the system has been configured correctly. Click
the button to view the configuration details.
The following dialog box lists the configuration parameters with their statuses in the RESULT column. If the
configuration is incorrect, the RESULT column displays the entry false.
4.6 Configuring Data Lifecycle Manager
For Data Lifecycle Manager, additional configuration steps have to be performed.
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 21
4.6.1 Preparing Storage Destinations
The storage destinations specify instances of the storage stack which Data Lifecycle Manager can move data to.
The destinations have to be created before they can be assigned in a lifecycle profile for relocation purposes.
4.6.1.1 Supported Storage Destination Types
The table below provides an overview of the supported storage destination types.
Storage Destination Type Restrictions
SAP HANA Dynamic Tiering
Local
The following factors prevent the lifecycle profile from being activated:
● Source tables with keys of type VARCHAR/CHAR/VARBINARY/BINARY and length
greater than 255
● Source tables with keys of type NVARCHAR/NCHAR and length greater than 85
● Source tables of type row
● Source tables with columns with data type BLOB
● Source tables without a primary key
Note
Defining a nominal key in the lifecycle profile allows you to overcome this restriction.
You can find further information on data type support for SAP HANA Dynamic Tiering in SAP
Note 2183717 .
Tables, table groups or table hierarchies with tables containing double quotation marks and
other special characters are not supported for data relocation to SAP HANA Dynamic Tiering
(extended tables). For more information, see SAP Note
2309420 .
SAP IQ over SDA The following factors prevent the lifecycle profile from being activated:
● Source tables with keys of type VARCHAR/CHAR/VARBINARY/BINARY and length
greater than 255
● Source tables with keys of type NVARCHAR/NCHAR and length greater than 85
● Source tables of type row
● Source tables with columns with data type BLOB
● Source tables without a primary key
Note
Defining a nominal key in the lifecycle profile allows you to overcome this restriction.
Spark SQL (DESTINATION)
For an overview of restrictions, see SAP Note 2290922 .
22 P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
Storage Destination Type Restrictions
Deletion Bin Destination The following factors prevent the lifecycle profile from being activated:
● Source tables without a primary key
Note
Defining a nominal key in the lifecycle profile allows you to overcome this restriction.
4.6.1.2 Prerequisites for Using Hadoop Cluster as Storage
Destination
1. For leveraging a Hadoop Cluster as storage Destination for Data Lifecycle Manager, you have chosen the right
combination of end to end product versions according to the information given in SAP Note 2290350 .
2. The SAP HANA Spark Controller has been installed and configured properly. For more information, see the
SAP Note for the appropriate SAP HANA Spark Controller version referenced from SAP Note 2290350 .
3. The Data Lifecycle Manager use case has been enabled by maintaining the following parameter in the
hanaes-site.xml Spark Controller configuration file located in /usr/sap/spark/controller/conf:
<property>
<name>sap.hana.es.warehouse.dir</name>
<value>/sap/hana/hanaes/warehouse</value>
<final>true</final>
</property>
The parameter indicates the location in the Hadoop Distributed File System (HDFS) where all SAP HANA data
files will be stored.
Note
You can change the location to any valid HDFS directory.
For more information, see section Spark Controller Configuration Parameters in the SAP HANA Administration
Guide on http://help.sap.com/hana_platform.
4. The SAP HANA Spark Controller has been added as Remote Source to SAP HANA:
1. In the Systems view in the SAP HANA Studio, choose Provisioning Remote Sources
2. Right-click Remote Sources and select New Remote Source.
3. Enter a Source Name, select SPARK SQL (DESTINATION) as Adapter Name and indexserver as
Source Location.
4. Enter the following information:
○ Under Connection Properties, enter the server and port
○ Under Credentials, enter the name and password for a technical user: This is the operating system
user of the Hadoop environment who is allowed to use the SAP HANA Spark Controller being used.
For more information, see the SAP Note for the appropriate SAP HANA Spark Controller version
referenced from SAP Note 2290350 .
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 23
5. Click the Save this editor icon in the upper right-hand corner of the screen.
5. The SAP HANA system has been configured for Spark connectivity:
1. In the SAP HANA Administration Console, right-click the SAP HANA system and choose Configuration
and Monitoring Open Administration to open the Administration editor. Now choose the Configuration
tab.
A list of all configuration files appears.
2. Expand the following configuration files and sections and change the system properties as described in
the following table:
Configuration File Section Parameter Key Parameter Value
indexserver.ini data_aging spark_remote_source <name of the Remote Source you
created for the SAP HANA Spark
Controller>
xsengine.ini data_aging spark_remote_source <name of the Remote Source you
created for the SAP HANA Spark
Controller>
If a section and/or parameter is not available, you can add it to the configuration file. Sections can be
added from the context menu of the configuration file. Parameters can be added from the context menu
of the section.
Note
Alternatively, you can use the following statement to configure the SAP HANA system:
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET
('data_aging', 'spark_remote_source') = '<remote_source_name>' WITH
RECONFIGURE;
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') SET
('data_aging', 'spark_remote_source') = '<remote_source_name>' WITH
RECONFIGURE;
4.6.1.3 Prerequisites for Using SAP HANA Dynamic Tiering
as Storage Destination
● The SAP HANA Dynamic Tiering option has to be installed and configured.
For more information, see the following guides at http://help.sap.com/hana_options_dt:
○ SAP HANA Dynamic Tiering: Master Guide
○ SAP HANA Dynamic Tiering: Installation Guide
○ SAP HANA Dynamic Tiering Administration Guide
● We recommend using array insert as the most optimal mechanism to load data into an extended table.
24
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
SAP HANA dynamic tiering converts an array-insert into a LOAD statement on the SAP HANA dynamic tiering
node. Bulk load is controlled by the bulk_inserts_as_load and bulk_load_as_binary parameters. Both
parameters are 'true' by default. If you need to re-enable the defaults, proceed as follows:
1. Re-enable the bulk load mechanism for optimizing array inserts:
ALTER SYSTEM ALTER CONFIGURATION ('esserver.ini', 'SYSTEM') SET ('row_engine',
'bulk_inserts_as_load') = 'true' WITH RECONFIGURE;
2. Re-enable binary load (instead of the ASCII load):
ALTER SYSTEM ALTER CONFIGURATION ('esserver.ini', 'SYSTEM') SET ('row_engine',
'bulk_load_as_binary') = 'true' WITH RECONFIGURE;
● To increase security and improve performance, configure communication between the SAP HANA database
and the SAP HANA dynamic tiering service over an internal network. For more information, see one of the
following sections in the SAP HANA Dynamic Tiering: Administration Guide:
○ Configure Private Internal Communication Using the Command-Line Interface
○ Configure Private Internal Communication Using the Graphical User Interface
4.6.1.4 Prerequisites for Using SAP IQ via SAP HANA Smart
Data Access as Storage Destination
● A SAP IQ version that is supported by SAP HANA Smart Data Access has to be installed and configured.
For more information, see the installation and configuration guide for the relevant SAP IQ version at http://
help.sap.com/iq.
● SAP HANA Smart Data Access has to be installed and configured for accessing SAP IQ.
For more information, see the following guides at http://help.sap.com/hana_platform:
○ SAP HANA Server Installation and Update Guide
○ SAP HANA Administration Guide
● SAP IQ has to be added as a remote source.
For more information, see the SAP HANA Administration Guide at http://help.sap.com/hana_platform.
4.6.1.5 Sizing Data Lifecycle Manager
Data Lifecycle Manager is a Java script based application, which is not resource demanding, and thus it does not
require additional sizing.
However, SAP HANA needs sizing as well as the storage destinations used for relocating data.
Component/Storage Sizing Information
SAP HANA See section Sizing SAP HANA in the SAP HANA Master Guide
on http://help.sap.com/hana_platform.
SAP IQ On http://help.sap.com/iq search for your SAP IQ version. On
the help page for your SAP IQ version, you can find the Hard
ware Sizing Guide under Additional Information.
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 25
Component/Storage Sizing Information
SAP HANA Dynamic Tiering See section Sizing Dynamic Tiering in the SAP HANA Dynamic
Tiering: Master Guide on http://help.sap.com/
hana_options_dt.
4.6.2 Check for Data Lifecycle Manager Readiness
Before you start working with the Data Lifecycle Manager, you can check whether the system has been configured
properly.
Procedure
1. Log on to the Data Lifecycle Manager with a user that has an appropriate role assigned.
Depending on whether the HTTP or HTTPS port has been configured, the Data Lifecycle Manager is available
on the SAP HANA XS Web server at one of the following URLs:
○ http://<WebServerHost>:80<SAPHANAinstance>/sap/hdm/dlm/index.html or
○ https://<WebServerHost>:43<SAPHANAinstance>/sap/hdm/dlm/index.html
2. In the header area of the screen, a button indicates whether the system has been configured correctly. Click
the button to view the configuration details.
The following dialog box lists the configuration parameters with their statuses in the RESULT column. If the
configuration is incorrect, the RESULT column displays the entry false.
4.6.3 Generate Default Schema for Generated Objects and
Roles Needed for Data Lifecycle Manager
The default schema SAP_HDM_DLM_GNR for generated objects as well as the roles required for working with the
schema and schema artifacts have to be created after Data Lifecycle Manager installation.
Context
During installation of Data Lifecycle Manager an .hdbprocedure file is created, which you use to generate the
default schema for generated objects and roles for working with Data Lifecycle Manager.
26
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
Prerequisites
You have been granted the following privileges and roles:
● System privileges DATA ADMIN and ROLE ADMIN
● Object privilege EXECUTE on "_SYS_REPO"."GRANT_ACTIVATED_ROLE"
● Role sap.hdm.dlm.role::Administrator
Procedure
1. Check for Data Lifecycle Manager Readiness. For more information, see Check for Data Lifecycle Manager
Readiness [page 26].
If the configuration parameters with the keys is_prepared_before_using/generated and
is_prepared_before_using/granted are displayed with result false, proceed as described in the next
steps.
2. In the SQL Console of the SAP HANA studio use the call
"SAP_HDM_DLM"."sap.hdm.dlm.core.db::PREPARE_BEFORE_USING"(); statement to invoke the
procedure that generates the following schema and roles:
○ Schema: SAP_HDM_DLM_GNR (default schema for objects that are generated with lifecycle profile
activation)
○ Roles:
○ sap.hdm.dlm.role.GNR.Administrator
○ sap.hdm.dlm.role.GNR.Display
○ sap.hdm.dlm.role.GNR.Support
Note
Note that the user who executes the statement owns the SAP_HDM_DLM_GNR schema and its objects.
Next Steps
Now the GNR roles can be granted to users intended to work with Data Lifecycle Manager.
SAP HANA Data Warehousing Foundation Installation Guide
Configuring SAP HANA Data Warehousing Foundation
P U B L I C 27
5 Uninstalling SAP HANA Data Warehousing
Foundation
If required, you can uninstall SAP HANA Data Warehousing Foundation using the SAP HANA application lifecycle
management tool.
Prerequisites
● Make sure that there are no scheduled activities for Data Distribution Optimizer or Data Lifecycle Manager.
If there are any scheduled activities, check and deactivate ths XS jobs.
● Previously, Data Distribution Optimizer required the the xsengine.ini file parameter httpserver.embedded to
be set to true. With SAP HANA Data Warehousing Foundation 1.0 SPS 02 and higher, this is not needed
anymore.
If httpserver.embedded has been enabled for SAP HANA Data Warehousing Foundation only, and is not
needed for other applications, you can delete the parameter value. In the Administrator editor in the SAP
HANA Administration Console, choose the Configuration tab and expand the xsengine.ini file. Change the
parameter from the context menu for the httpserver section.
Procedure
1. Log on to SAP HANA Application Lifecycle Management at http://<WebServerHost>:<Port>/sap/
hana/xs/lm/.
2. On the Home screen, select the Delivery Units tile.
3. Select the delivery unit that you want to delete.
Caution
The following delivery units have to be uninstalled in order to completely uninstall SAP HANA Data
Warehousing Foundation. The delivery units have to be deleted in the following order (inverse order to their
installation):
1. HDC_HDM (for uninstalling the SAP Data Warehousing Foundation documentation)
2. HCO_HDM_DDO /HCO_HDM_DLM (for uninstalling Data Distribution Optimizer / Data Lifecycle
Manager)
3. HCO_HDM (for uninstalling the SAP Data Warehousing Foundation core component)
4. Choose Delete with the option include objects and packages.
Note
Together with the functional delivery units selected, the system also deletes the relevant language delivery
units.
28
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Uninstalling SAP HANA Data Warehousing Foundation
5. Drop the following roles:
○ sap.hdm.dlm.role.GNR.Administrator
○ sap.hdm.dlm.role.GNR.Display
○ sap.hdm.dlm.role.GNR.Support
6. Drop the Data Distribution Optimizer and Data Lifecycle Manager schemas with the SQL statement DROP
SCHEMA <schema_name> CASCADE;:
○ SAP_HDM
○ SAP_HDM_DDO
○ SAP_HDM_DDO_REMOTEMODE
○ SAP_HDM_DLM
○ SAP_HDM_DLM_GNR
7. Check whether you need to reset the configuration of SAP HANA system properties. For information about
the system properties and how to reset them, see Configure SAP HANA System Properties [page 11].
SAP HANA Data Warehousing Foundation Installation Guide
Uninstalling SAP HANA Data Warehousing Foundation
P U B L I C 29
Important Disclaimers and Legal Information
Coding Samples
Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system
environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and
completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, unless damages were caused by SAP
intentionally or by SAP's gross negligence.
Accessibility
The information contained in the SAP documentation represents SAP's current view of accessibility criteria as of the date of publication; it is in no way intended to be a
binding guideline on how to ensure accessibility of software products. SAP in particular disclaims any liability in relation to this document. This disclaimer, however, does
not apply in cases of willful misconduct or gross negligence of SAP. Furthermore, this document does not result in any direct or indirect contractual obligations of SAP.
Gender-Neutral Language
As far as possible, SAP documentation is gender neutral. Depending on the context, the reader is addressed directly with "you", or a gender-neutral noun (such as "sales
person" or "working days") is used. If when referring to members of both sexes, however, the third-person singular cannot be avoided or a gender-neutral noun does not
exist, SAP reserves the right to use the masculine form of the noun and pronoun. This is to ensure that the documentation remains comprehensible.
Internet Hyperlinks
The SAP documentation may contain hyperlinks to the Internet. These hyperlinks are intended to serve as a hint about where to find related information. SAP does not
warrant the availability and correctness of this related information or the ability of this information to serve a particular purpose. SAP shall not be liable for any damages
caused by the use of related information unless damages have been caused by SAP's gross negligence or willful misconduct. All links are categorized for transparency
(see: http://help.sap.com/disclaimer).
30
P U B L I C
SAP HANA Data Warehousing Foundation Installation Guide
Important Disclaimers and Legal Information
SAP HANA Data Warehousing Foundation Installation Guide
Important Disclaimers and Legal Information
P U B L I C 31
go.sap.com/registration/
contact.html
© 2017 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any
form or for any purpose without the express permission of SAP SE
or an SAP affiliate company. The information contained herein may
be changed without prior notice.
Some software products marketed by SAP SE and its distributors
contain proprietary software components of other software
vendors. National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company
for informational purposes only, without representation or warranty
of any kind, and SAP or its affiliated companies shall not be liable for
errors or omissions with respect to the materials. The only
warranties for SAP or SAP affiliate company products and services
are those that are set forth in the express warranty statements
accompanying such products and services, if any. Nothing herein
should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks
of SAP SE (or an SAP affiliate company) in Germany and other
countries. All other product and service names mentioned are the
trademarks of their respective companies.
Please see http://www.sap.com/corporate-en/legal/copyright/
index.epx for additional trademark information and notices.