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
6
votes
1 answer

Connect to SAP HANA DB using jdbc and Kerberos Delegation

Is it possible to connect to SAP HANA DB from my java application using jdbc and Kerberos Delegation? Now I can create jdbc connection to SAP HANA DB without input db login and password, using only windows login. For this I set Kerberos External ID…
Alexander
  • 481
  • 3
  • 11
6
votes
2 answers

Replacing multiple occurrence by single occurrence in string

I have data like "11223311" and I want all the multiple occurrence to be replaced by single occurrence i.e. the above should turn into '123'. I am working in SAP HANA. But by using below logic I am getting '1231' from '11223311'. SELECT …
Sarthak Srivastava
  • 101
  • 3
  • 19
6
votes
1 answer

Developing SAPUI5 applications with WebStorm

Looking at some of the delivered SAPUI5 code on HANA I noticed that WebStorm and even RubyMine was used by some SAP developers. I have also heard that various other developers on customer sites use WebStorm for code checked into the ABAP…
Jasper_07
  • 2,453
  • 2
  • 18
  • 23
6
votes
1 answer

SAP HANA and Hibernate Support

I have an existing Java application which uses Hibernate with DB2. My application has 40-45 tables in DB2. We are planning to replace DB2 with SAP-HANA. In that case I would like to know your opinion on the following items: Is there Hibernate…
Dhams
  • 251
  • 7
  • 15
6
votes
2 answers

SAP HANA XS File upload with UI5

I'm trying to implement a file upload in a UI5 application on a HANA XS Server. I can't find many informations how to do that - somebody got an idea?
user2345998
  • 649
  • 13
  • 31
5
votes
1 answer

Adding where clause after HANA placeholders in SQLAlchemy

I'm trying to construct a query like this: SELECT "Inventory".item_id, "Inventory".region FROM "Inventory" ('PLACEHOLDER' = ('$$P_Param$$', '0')) WHERE "Inventory".region = :region_1 My select statement is adding the HANA placeholders at the end…
J.D. Marlin
  • 253
  • 1
  • 3
  • 15
5
votes
3 answers

Copy Activity is failing with the following error

{ "errorCode": "2200", "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'PdwManagedToNativeInteropException…
Sam
  • 103
  • 1
  • 1
  • 10
5
votes
3 answers

How to do an IF EXISTS in hana SQL query

I have this query code: IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BAL_WMS_STAGING]') AND type in (N'U') ) DROP TABLE [dbo].[BAL_WMS_STAGING] GO CREATE TABLE I am trying to use this statement to…
isambardtech
  • 51
  • 1
  • 1
  • 3
5
votes
3 answers

How to add a (primary) key to an existing table using SAP HANA

What is the SQL command to add a (primary) key to a table in SAP HANA? The ALTER TABLE docu form SAP Library is cryptic to me
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
5
votes
1 answer

"Cannot find libSQLDBCHDB.dll" when connecting to SAP HANA with .NET

We are getting the error "Cannot find libSQLDBCHDB.dll" when trying to connect with our AWS HANA instance from dotnet code. We installed the HANA Client developer edition 64 bit on our 64 bit windows machine and also set the PATH env variable to the…
Samar
  • 2,091
  • 1
  • 15
  • 18
5
votes
3 answers

What are the differences between PyHDB and the hdbcli python package from the HANA client?

In order to work with HANA in python, I've always used the pretty old python 2.6.4 that came with the HANA client. There are ways to get it working with other python versions, too, but they seem to by very hacky. Now I've found the very…
203
  • 499
  • 1
  • 6
  • 17
5
votes
2 answers

HANA SQLScript "Sleep" Command

Is there an equivalent of a Sleep(1000) command in HANA SQLScript? I'm not seeing anything in the HANA SQLScript reference, so I'm wondering if there might be a creative workaround that won't peg the CPU at 100%.
Peder Rice
  • 1,764
  • 3
  • 28
  • 51
4
votes
3 answers

How can I join 2 tables with converted UUID field?

In SAP EWM the material ID is stored in /SAPAPO/ tables using the data element /SAPAPO/MATID which is a CHAR 22. In the other hand, /SCWM/ tables use the data element /SCWM/DE_MATID which is a RAW 16. All the standard code I've seen, uses the class…
Marshal
  • 41
  • 3
4
votes
1 answer

Cannot execute SQL HANA query in Python - syntax error

I have problem executing SQL HANA query in Python. I established connection (in R I am able to connect to this HANA data table and it's working perfectly) but in Python I receive syntax error related to query -> I searched multiple sources how to…
Mike
  • 73
  • 6
4
votes
1 answer

Difference between In-App extensibility and side-by-side extensibility?

Can anyone explain the key difference between key-user extensibility and side-by-side extensibility in SAP?
Anmol Jain
  • 63
  • 2
  • 7
1
2
3
…
99 100