Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP HANA Articles
Page 48 of 58
Can we create multiple database in SAP HANA system?
In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as owner name while defining a schema.CREATE SCHEMA [OWNED BY ]If it is not defined, the system takes the current user as the owner of the schema.
Read MoreUse of SPATIAL function in SAP HANA
In SAP HANA, geospatial data types are not defined as such and you need to use scalar values like a.ST_X().You can create a table like this −CREATE COLUMN TABLE MYSCHEMA.SpatialShapes_GEOMETRIES ( ShapeID integer, SHAPE1 ST_Point, SHAPE2 ST_GEOMETRY );SAP provides a complete guide to handle Geospatial data in applications. You can refer this link for more details:https://help.sap.com/doc/PRODUCTION/9db42d044f8e415180d4a4475873b50a/2.0.00/en-US/SAP_HANA_Spatial_Reference_en.pdf
Read MoreTaking schema wise backup in SAP HANA
Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ...
Read MoreHow to build a java web application using SAP platform and HANA database?
You would require to change the connection.properties file of your local Tomcat Server (Server > Java Web Tomcat 8 Server-config/config_master/connection_data), to point to the HANA database.Here are the usual parameters that need to be configured for HANA databasejavax.persistence.jdbc.driver=com.sap.db.jdbc.Driver javax.persistence.jdbc.url=jdbc:sap://:/?reconnect=true&autocommit=false javax.persistence.jdbc.user=db-user javax.persistence.jdbc.password=db-pass eclipselink.target-database=HANA
Read MoreImporting data from Pgsql to SAP HANA database
Import and Export using a flat file is the easiest option. You can use CSV file if it is a onetime activity. However, If you think it is a repetitive activity then I would suggest you use HANA ETL options like HANA SLT replication, Smart Data access, etc.SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction ...
Read MoreTaking backup of schema in SAP HANA
It is always recommended to back up your critical systems.ExampleFollowing SQL command can be used to export schema in HANA:EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH REPLACE;This can also be directly zipped to Linux as below:tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/
Read MoreGetting memory error while doing UNION in SAP HANA
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.To use this UNION clause, each SELECT statement must haveThe same number of columns selectedThe same number of column expressionsThe same data type andHave them in the same orderWhile performing UNION you need to note that what data it will bring. To perform UNION ALL you need to ensure that views should be fully materialized.To know more about SAP HANA Modeling, you can refer SAP Guide:SAP HANA Guide
Read MoreDifference between Open SQL, Native SQL in SAP HANA
As you know SAP was not providing any db for ECC and it had to be purchased separately. When you call your database in ABAP program, you need to write a SQL. As R/3 from SAP works with most relational databases, a common set of features had to be used, with some SAP specific extensions which are translated by the ABAP kernel to be understood by the actual DB. This language is known as Open SQL language.When you develop only for one database, it uses native instructions. IT is developed in Native SQL. Now when you use SAP HANA as ...
Read MoreHow to create a list in SAPUI5?
I have gone through your code and it looks your list binding is incorrect. When you bind your data, your data should be in a JSON array format. Please find below the updated working code.Examplevar oModelData = [ {Animal: "Kangaroo", Zoo: "Sydney"}, {Animal: "Tiger", Zoo: "Melbourne"}, {Animal: "Lion", Zoo: "Alaska"} ]; var oItem = new sap.m.StandardListItem({ title : "{ Animal }", description : "{ Zoo }" }); var oList = new sap.m.List({ headerText:" Items", items: { path: "/", template: oItem } });Hope it helps!
Read MoreHow can I update a third party database outside SAP after completing a Transaction?
As you need to make some changes to happen when an activity gets completed in SAP, I would suggest you to go for services. Services are the best way to communicate when you are dealing with two discrete systems.Firstly you need to create a program on SAP side which can do the following task Fetch the file from a specified directoryConverts the file into a formatted data or send the data to a serverAt the webserver end, have a listener which receives POST requests (send by SAP). You need to have proper authentication set up ...
Read More