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

Using SAP HANA Extended Services (XS) versus ADO.NET/C# for application development

Would it be better from an application developer point of view to use native XS engine which is tightly coupled with SAP-HANA database, rather than using ADO.NET for connectivity and using ASP.NET/C# for application development ? Which would give…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
1 answer

Connect to SAP HANA Database using VBA

I am trying to fetch data into Excel from SAP HANA database using vba. I came across the below questions. Do I need to install SAP HANA MDX Provider for this? If yes, please provide the link. I am unable to spot any. What would be the vba script…
Vikram
  • 65
  • 2
  • 9
0
votes
2 answers

cloud foundry dependency jars for spring boot

Suppose when I make a java spring boot application, it needs jars . But when I deploy my app to cloud foundry will all the jars get build with my app and then go to cloud foundry or cloud foundry provides the jars dependency by seeing pom etc. I…
pradeep
  • 31
  • 7
0
votes
1 answer

Capture Calling statement as a variable

Want to know if it is at all possible to capture the calling query... example SELECT SITE,NAME,COUNT(ITEMS) FROM SQLVIEW1 WHERE NAME = 'JIM' in the SQL view it has something like this DECLARE VAR1 where VAR1 would equal the above query that…
JRhino
  • 99
  • 2
  • 14
0
votes
1 answer

Run time exception (Java Version Issue)

I tried to start with new JSP hello world program in eclipse neon - which runs in java version 8. I did remember the code was working few days back. Now,If i run in java web server in local. I see below message java version "1.8.0_121" Java(TM) SE…
user7896515
  • 41
  • 9
0
votes
1 answer

SAP HANA Vora distributed log service refused to start

I installed SAP HANA Vora on a 3 node MapR cluster. While trying to bring up Vora service via Vora Manager UI, I get the following error: Error occurred while starting all services: vora-dlog refused to start. Cannot continue Start All Jobs.…
AnshulN
  • 1
0
votes
1 answer

Visual Studio 2013 - .NET provider for HANA not visible in entity model

I have to use entity framework with HANA database in visual studio 2013. I am following below steps- 1. I already have Visual studio 2013 professional edition installed on my desktop. 2. I downloaded SAP HANA client package from SAP market place and…
Deepak Tiwary
  • 120
  • 2
  • 12
0
votes
2 answers

Adding transformations in Sybase replication server

We have primary source database as Oracle 11gR2 and target as SAP HANA. We are trying to test SAP - Sybase Replication server for replication from Primary ORACLE to Target HANA. We need to add extra columns such as RECORD_DATE and LAST_MODIFIED_DATE…
Anirudh D
  • 181
  • 3
  • 14
  • 33
0
votes
1 answer

Hexadecimal to decimal through system defined function

I am working on creating one view in SAP HANA. I have column A, Data type for A is NVARCHAR. Values in A are something like below. I need to use only last 5 digits and convert it into decimal. A …
Naziya
  • 1
  • 1
0
votes
2 answers

Get data from on premise SQL server to Mobile App in SAP HANA Cloud Platform

I have installed cloud connector to a server that SQL is installed and I have a couple of databases. I want to create a native Android app in SMP on SHCP in and use some of the data stored in my on premise SQL server. Do I have to write an OData…
mike_x_
  • 1,900
  • 3
  • 35
  • 69
0
votes
2 answers

Combining two tables without losing column or rows

I have two tables: The first one has the colums "SomeValue" and "Timestamp". The other one has the columns "SomeOtherValue" and also "Timestamp". What I need as an output is the following: A table with the three Colums "SomeValue", "SomeOtherValue"…
Bofrostmann
  • 31
  • 5
0
votes
2 answers

SAP HANA Smart Data Access: Can't count rows of virtual Table (Hive)

I have a HANA Express VM which I want to interact with a Hadoop cluster. I have a Hive table which I connected via Smart Data Access (SDA) to HANA. Everything works fine with the virtual table, I can use SAP HANA Studio for querying the Hive data…
D. Müller
  • 3,336
  • 4
  • 36
  • 84
0
votes
1 answer

HANA SQL CTE WHERE CONDITION

I'm writing a scripted calculation view on HANA using SQL. Looking for some performance booster alternatives for the logic that I have implemented in a while loop. Simplified version of code is below. It is trying to get similar looking vendors in…
Anup Kulkarni
  • 13
  • 1
  • 6
0
votes
1 answer

How I can insert data in SAP HANA Vora virtual table from SAP HANA Studio?

I have a SAP HANA Vora virtual table with a single varchar field. I try to execute this following query into this Vora virtual table from SAP HANA Studio: INSERT INTO "BPINST"."VORA_TEST_VORA_VARCHAR" values ('OPT') But the following error…
Joan Sánchez Escudero
  • 9
  • 6
0
votes
1 answer

How to return zero value from a count with no rows

Here is my below query which gives the count and group by each hour SELECT ADD_SECONDS(start_time,- MINUTE(start_time) * 60 - SECOND(start_time)) as time , to_integer(to_varchar(start_time, 'DD')) as day , count(*) as count FROM SYSTEM.TABLE where…
John
  • 305
  • 2
  • 4
  • 18
1 2 3
…
99
100