SAP HANA - Architecture - Database Development Documentation and Tools
About
The important SAP HANA guide and tools for Database Development.
After having build the data persistence model with a programming_language, you can add above an analytic model.
The data-persistence model can be queried by:
- SQL (with a client interface such as ADBC or JDBC).
- or HTTP (with an application service) See Core Data Service
Programming Language
To define the data-persistence model, the following languages can be used:
- SQLScript,
- the .hdbtable syntax family (hdbview, hdbsequence,…),
- or Core Data Services (CDS)
| Programming Language | Development Artifacts | Tools | SAP HANA Information Source |
|---|---|---|---|
| SQLScript | Tables, SQL Views, Procedures, UDFs, application & business functions… | Eclipse (SAP HANA studio) | SQLScript Reference, BFL Reference, PAL Reference |
| SAP HANA DB (.hdb* syntax, hdbtable, hdbview…) | Tables, SQL Views, Procedures, Search index (InA) … | Eclipse (SAP HANA studio), SAP HANA Web IDE | Developer Guide, SQLScript Reference |
| SAP HANA DB (CDS syntax) | Entities, data types, contexts, SQL views… for HTTP request | Eclipse (SAP HANA studio), SAP HANA Web IDE | Developer Guide |
| SAP HANA DB | Analytic and calculation views, decision tables, … | Eclipse (SAP HANA studio), SAP HANA Web IDE | Developer Guide, Modeling Guide |
Task
| Task | Details | Information Source |
|---|---|---|
| Create tables, SQL views, sequences… | Code, syntax, … | SQLScript Reference, Developer Guide |
| Packaging, activation, implementation, … | Developer Guide | |
| Create attribute, analytic, calculation views | Code, syntax, … | SQLScript Reference |
| Packaging, activation, implementation, … | Developer Guide | |
| Examples, background | Modeling Guide | |
| Create/Write SQLScript procedures, UDFs, triggers… | Code, syntax, … | SQLScript Reference, Developer Guide |
| Packaging, activation, implementation, … | Developer Guide | |
| Create/Use application functions | Code, syntax, … | SQLScript Reference, BFL Reference, PAL Reference, Developer Guide |
| Packaging, activation, implementation, … | Developer Guide |
Guides
Developer
SAP HANA Developer Guide for Studio
- Build a data model (persistence|analytics)
- Create SQLScript procedure
- Create UDF
- Build SQL Query
Modeling
- Explains how to use the SAP HANA modeler to create information models based on data that can be used for analytical purposes.
- Create attribute, analytic, and calculation views
- Create decision tables
- Import/Export data
SQL System Views
- Describes all SQL data types, predicates, operators, expressions, functions, statements, and error codes.
- Query state of SAP HANA using SQL commands
SQLScript Reference
SQLScript Reference. See SAP HANA - SQLScript
- Describes how to use the SQL extension SAP HANA SQLScript to embed data-intensive application logic into SAP HANA.
- Build SQL scripts
- Create UDFs
- Build SQL procedures
SQLScript Command Network Protocol
SQLScript Command Network Protocol
- Describes the SQL Command Network Protocol that is used by SAP HANA clients to communicate with SAP HANA.
- Define routes for SQL statements
- Set up authentication (SAML…)
- Handle large data objects
- Enable distributed transactions
Core Data Services (CDS)
SAP HANA Core Data Services (CDS) Reference
- Explains how to use Core Data Services (CDS) to build design-time data-persistence models in SAP HANA Extended Application Services. The data-persistence model defines the data to expose in response to client requests via HTTP, for example, from an SAPUI5-based application.
- Create CDS Documents
- Define tables, table types, and SQL views
- Define associations between data objects
- Import data into a table