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

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

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

Documentation / Reference


Powered by ComboStrap