Topics ›
Products>sap-Hana-Studio
36 tutorials tagged with Products>sap-Hana-Studio.
Create a Streaming Project in SAP HANA Smart Data Streaming
Part 2 of 9. Create a SAP HANA Smart Data Streaming (SDS) project in SAP HANA Studio with streaming plug-in and visual editor.
Configure SAP HANA Smart Data Streaming Server Connection
Part 1 of 9. Configure SAP HANA streaming connection and add SAP HANA data service in SAP HANA Studio.
Importing Required Calculation Views
Conversion and importation of calculation views for Dynamic Tiering
View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
Create and use a SQL view to query data from both in-memory and Dynamic Tiering tables.
Selectively Move Data Between In-Memory and Extended Tables
Move data between in-memory and extended tables. Set connection property values.
Migrate Records in Related Tables Using Stored Procedure
Using a stored procedure to migrate records in related tables as a single transaction.
Create Tables and Import Data
Create in-memory column store and Dynamic Tiering tables. Import data into both types of tables.
Create Extended Storage
Create extended storage for Dynamic Tiering.
Create a New User and Assign Permissions
Create a new `TCPH` user as well as assign roles and privileges to the new user.
Converting Between an In-Memory Table and an Extended Table
Convert an in-memory column store table to an extended table and vice versa.
Visualize a Graphical Query Plan
Generate and compare query plan for in-memory and extended tables.
Table Statistics and its Effect on Query Plans
Create table statistics. Analyze impact of statistics on query plans.
Detailed Query Plan and Indexes
Generate and access a detailed html query plan. Create indexes on columns.
Compare Prepared and Executed Plan
Generate and compare Prepared and Executed plans.
Multi-Store Tables
Create Multi-Store Tables
Initializing Database Backup and Recovery
Setting up backup and recovery for Dynamic Tiering.
Stopping and Restarting the Extended Storage Service
Occasionally you will need to stop your extended storage service. One case where this will be required is when you change a configuration parameter, you will …
Creating and Removing Extended Storage
Creating and removing Extended Storage using SAP HANA Studio and SAP HANA Cockpit
Additional checks in SAP HANA Cockpit and SAP HANA Studio
Performing additional checks for SAP HANA
Reviewing Available Backups
Reviewing available backups with HANA's backup catalog
Managing Backup Files
Managing backup files is important to ensure disk space does not run out.
Database Recovery With HANA Dynamic Tiering
Recover databases with Dynamic Tiering.
Creating Database Backups
Creating Backups using HANA Studio's backup editor and SQL console.
Creating and Recovering Delta Backups
Delta backups are a feature in SAP HANA to optimize recoveries and backups.
Enlarging a Dbspace File Using Reserved Space
Use reserved spaces to increase the size of a Dbspace file
Dropping a Dbspace File
2 methods to drop a Dbspace file
Adding a Dbspace File
Managing disk storage space using Dbspace files
Seeing Calculation View Results
Generating select statements for results and visualization
Information View Conversion
How to convert information views
Creating a Calculation View from the Union of In-Memory and Extended Tables
How to use unions to create a calculation view
Adding Our Union Calculation View into the Converted Data Model
Replacing old information model with new calculation view
Adding Analytic Privileges and the SAP HANA Modeler Perspective
Understanding the various types of Information Views used in SAP HANA to create analytical reports.
Setting Up SAP HANA System Replication with HANA Studio
How to replicate a SAP HANA System in HANA Studio
Perform a Takeover
Introduction to takeovers.
Disable SAP HANA System Replication
Disable system replication.
Performing a Failback
How to initiate failbacks in HANA Studio