SAP Home Learn Build Integrate Model Operate Extend with AI ConnectTutorial navigator Knowledge Graph API Devtoberfest Developer Advocates App Space

Manage my Account SAP Devs YouTube ↗ Learnings ↗ Community ↗ Provide Feedback ↗
Logout
⤢ Open full site
GROUP

Get Started with SAP HANA Dynamic Tiering

Beginner · 120 min. · 8 Tutorials

Tutorials

1

Create Extended Storage

Beginner · 15 min. · 4 steps

Create extended storage for Dynamic Tiering.

2

Create a New User and Assign Permissions

Beginner · 15 min. · 3 steps

Create a new `TCPH` user as well as assign roles and privileges to the new user.

3

Create Tables and Import Data

Beginner · 15 min. · 4 steps

Create in-memory column store and Dynamic Tiering tables. Import data into both types of tables.

4

Convert an in-memory column store table to an extended table and vice versa.

5

Move data between in-memory and extended tables. Set connection property values.

6

Using a stored procedure to migrate records in related tables as a single transaction.

7

Create and use a SQL view to query data from both in-memory and Dynamic Tiering tables.

8

Multi-Store Tables

Beginner · 15 min. · 4 steps

Create Multi-Store Tables

Learn more →