Try out the functionality of the SAP HANA database explorer by adding databases, creating, importing and exporting database objects, browsing with the database browser, querying with the SQL console, exploring multi-model (graph, document store, and spatial), creating remote sources, and using the debugger, code coverage, code analysis, explain plan, SQL Analyzer and tracing to troubleshoot.
Learn about the SAP HANA database explorer and how to start using it with SAP HANA Cloud free tier, SAP HANA, express edition, or SAP HANA Cloud basic trial.
This tutorial will explore different instance types, such as SAP HANA Cockpit Database, SAP HANA Cloud, data lake Relational Engine, data lake Files, and SAP HANA Deployment Infrastructure (HDI) that can be added, along with the different operations that can be performed on them.
Create a user group, users, roles, and populate a sample schema that includes tables, views, functions and procedures using the SQL console.
Use wizards or SQL statements to export and import data and schema using CSV, Apache Parquet, or binary formats.
See how the database browser can be used to explore and examine objects in an SAP HANA database.
Explore features of the SQL console and see how it facilitates querying an SAP HANA database.
Explore knowledge graph, property graph, JSON document store, and spatial capabilities in the SAP HANA database explorer.
Use SAP HANA federation capabilities to query data from other SAP HANA and SAP HANA Cloud, data lake Relational Engine databases using SAP HANA smart data access (SDA) and the Cloud Connector.
Explore the available tools to help diagnose and debug SQL or SQLScript.
Learn how files such as CSV or Parquet stored on a data lake Files instance can be queried using SQL on Files.
Learn how the SAP HANA database explorer for Visual Studio Code extension can be used to connect to both SAP HANA Cloud and on-premise databases, about related general Visual Studio Code features, how to use the catalog browser, and how to execute SQL queries. The SAP HANA database explorer for Visual Studio Code extension contains similar functionality to that in the web-based SAP HANA database explorer although not all functionality is available.
Dive into using the database objects app to explore and inspect schema objects in an SAP HANA Cloud, SAP HANA database or data lake Relational Engine.
Learn how the SQL console can be used within SAP HANA Cloud Central to quickly query a selected database.
Joule is an AI assistant. Generative AI may produce inaccurate, incomplete, or biased information. Always verify important details before acting on them.
Conversations are sent to SAP-hosted large language models for processing. Do not include personal data, credentials, or confidential information in your messages.
Joule's responses are based on the SAP tutorial catalog and may not reflect the latest product changes. For authoritative guidance, consult the linked tutorials and official SAP documentation.