Stack Overflow
Stack Overflow

Questions tagged [hana]

SAP HANA is SAP SE’s implementation of in-memory database technology. Not to be confused with similarly named products and technologies e.g. S/4HANA, Boost.Hana, SAP HANA Vora, or SAP Cloud (SAPcp)

###About

SAP HANA is a development platform and database management system that uses in-memory database technology allowing the processing of massive amounts in real-time.

It integrates a wide range of data processing capabilities (predictive analytics, SQL, Geospatial, graph processing, data stream analytics, data warehousing, machine learning) with enterprise grade data management and with modern application development/deployment tools (cloud foundry style containers).

SAP HANA is the data processing platform SAP uses for all its products, both on-premises and in the cloud. It is the basis for future developments.

A resource streamlined version of SAP HANA on a free license up to 32 GB (including productive scenarios) is available for download and for deployment in cloud PaaS setups like AWS, MS Azure and Google Cloud Platform (HANA Express Edition, see link below).

Available interfaces & Capabilities

  • JDBC
  • ODBC
  • ODBO (OLE DB for OLAP, used for business intelligence)
  • SQLDBC (C++)
  • Python DBAPI
  • MDX
  • REST APIs
  • node.js HDB library
  • SQL and SQL Script
  • Text Analysis and Text Mining
  • Graph Data processing
  • Hadoop and Spark integration
  • node.js, Java and Bring Your Own Language development
  • Geospatial data processing
  • Predictive Analytics
  • Data Streaming

Links

###Related tags

, , , , , , , , , , , , ,

1915 questions
4
votes
1 answer

Why SAP Hana DB ADO.NET DLL loading may fail?

For a .Net C# app that uses SAP.DATA.HANA.v4.5 v2.3.119 and is installed on the runtime machine with the libadonetHDB.dll v2.3.119 with the environment variable HDBADONET pointing to the app folder where libadonetHDB.dll exists. The application…
Streamline
  • 2,040
  • 4
  • 37
  • 56
4
votes
1 answer

Getting autoincrement id on insert in SAP Hana

I have a table with an autoincrement column, as described here This is how it's defined in Java/Hibernate: @Id @GeneratedValue(strategy=GenerationType.IDENTITY) private int ID; And this is how the column is defined in the CREATE TABLE (note, no…
ps0604
  • 1,227
  • 23
  • 133
  • 330
4
votes
3 answers

Rolling sum based on date range in sql

Looking for a performance effective SQL code to calculate Rolling Sum based on DATE Sum. My data looks like: +----+-----------+----+ | ID | Date | Qt | +----+-----------+----+ | 1 | 1/12/2009 | 2 | | 2 | 1/13/2009 | 3 | | 3 | 1/14/2009 |…
Jay
  • 61
  • 1
  • 2
  • 4
4
votes
1 answer

How to recreate (export/import) Hana DB structure/data via command line or GUI?

We are new to Hana DB and starting to build a Hana DB connector for our existing application for an existing customer adopting SAP B1 with a Hana DB. Our application just needs to make connections to the Hana DB and perform some basic SQL SELECT…
Streamline
  • 2,040
  • 4
  • 37
  • 56
4
votes
3 answers

READ_TEXT similar function in CDS View

I need to read text stored for invoice, order, etc. In ABAP we can use READ_TEXT function module, but I need to read it within a CDS view. Is there a way to read text from database tables directly in a SELECT statement?
Eralper
  • 6,461
  • 2
  • 21
  • 27
4
votes
1 answer

SAP HANA - Change password SQL

How do I change my password in SAP HANA via SQL. (or other users if I am an Administrator) I did view the HANA Dokumentation : ALTER USER Statement So I tried ALTER USER PASSWORD '' with no success.
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
4
votes
1 answer

Selecting from a CDS entity versus from a CDS Database view

In SAP's ABAP CDS, the define view statement is used to create a CDS view. This object has a CDS entity name, which is how it appears in the editor and packages but it also has an AbapCatalog.sqlViewName annotation that has to be different. The…
Lilienthal
  • 4,327
  • 13
  • 52
  • 88
4
votes
2 answers

Fetch primary key generated by sequence using jdbctemplate / jdbc for Hana db

We are trying to insert record in hana db so we are currently using jdbc template and key holder to save data and retrieve newly generated column id.This works fine for postgress but not for hana. query ="SELECT CURRENT_IDENTITY_VALUE() FROM…
pruthvi pv
  • 51
  • 3
4
votes
1 answer

SQL to get rows with hightest value per month and over all months

I need some help writing SQL statement for below requirements(FINAL REULT). note: I am writing this SQL on SAP HANA system(database) using SQL syntax. The SQL syntax is normal universally used. some abbreviations used for column names: cust =…
nomann
  • 41
  • 3
4
votes
2 answers

SAP HANA data provider for Microsoft ado.net

I need to connect my C# web application with SAP HANA database using Entity Framework 6. I've got this documentation: obsolete link (possibly, Microsoft Entity Framework Support (SAP HANA Data Provider for Microsoft ADO.NET) may correspond.) This…
Abhishek
  • 411
  • 8
  • 19
4
votes
4 answers

sap connector 3.0 c# with sap hana

Is it possible? In another company always get info from RFC made at SAP R/3 and APP made in VS Studio C# (through sap connector). Somebody told me to do the same, but in sap hana... Can i build an RFC in SAP HANA ? and get the Information with the…
ivan
  • 65
  • 1
  • 5
4
votes
2 answers

Extracting query-history in SAP HANA

I have been using SAP HANA db instance, and have been running several queries on this. I need to extract the query-history, preferably from a system-table or elsewhere. Please let me know if this is possible and any pointers to achieve it, if…
Nishanth Reddy
  • 589
  • 2
  • 14
  • 27
4
votes
1 answer

SAP HANA alternative for cross apply

Is there an alternative in HANA sql for the "cross apply" operator as available in MsSql? Or is there a way to apply a function for values in a table? Something like select T.*, F.* from T cross join someFunction(T.Value) F
florin
  • 405
  • 4
  • 20
4
votes
1 answer

How to print from XSJS to Console

I have some code in XSJS to populate/Update my Hana DB based on some conditions. I am looking for a mechanism where I can print few comments to console or to some log file. I know i can use console.log(); for normal javascript on web browser but it…
Raghuveer
  • 1,413
  • 3
  • 23
  • 39
3
votes
1 answer

MONTHS_BETWEEN('2018-12-31', '2019-02-28') outputs 1?

Simply shown above, this has been causing inconsistencies with our data. I'm currently writing an AMDP Logic that makes use of the difference between the months of each records, but surprisingly, the function MONTHS_BETWEEN() is not consistent for…
Piolo Quintos
  • 75
  • 6
1 2
3
…
99 100