Search UI on HANA

To search on the data present in HANA, there are some applications already available.

Recently a blog was published on Enterprise Search UI on HANA which is built using SAPUI5 and is very simple to use.

Once the setup is done, the UI can be launched using the URL which looks some like:

Processing XML data in SAP HANA

New capabilities in SAP HANA are introduced with every SP. One such important one is the ability to process XML data which has been introduced with SAP HANA 2.0 SPS1 and SPS2.

XML is in common use for interchange of data over the Internet. Thus, applications require data in xml format for communication with other entities. With the data stored in the RDMS, as SAP HANA, in relational mode as tables, the application layer requires to process the data and render in the format which could be used for communication. Similarly, when the data reaches the application layer, it needs to again process this data, but now to be able to store in the database as tables (format understood by the RDBMS).

HANA XS Core Data Services (CDS) – Troubleshooting, tips and tricks

Today I have decided to create the blog post for people who are struggling with Cloud Platform and HANA XS. My googling skills revealed that the blog posts available here do not tell you important things that you have to know. E.g. there are even mistakes in the code and you should invest your precious time to solve them.

I hope, this blog article will be interesting and helpful for you as it might be interesting for me in cast I forget something. It will be also great if developers read it and improve the product (doesn’t matter which one, but simply improve). By the way, I plan to update the article as long as I will be working with CDS.

What is really changing with SAP HANA 2.0 SPS 01?

This new release includes enhancements for database management, data management, analytical intelligence and application development.

This release also includes another important change which will have a greater influence on the landscape configuration and sizing of SAP HANA and will definitely encourage people to become more creative and flexible with the technical architecture.

Starting with SAP HANA 2.0 SPS 01, multitenant database containers (MDC) will be the only operational mode for SAP HANA systems. This means that if you upgrade to SAP HANA 2.0 SPS 01, you will no longer be able to run a single-container HANA system.

SAP HANA XS Advanced Installation Guide through resident hdblcm (Command based)

SAP HANA XS Advanced Installation:

Prerequisites:
SAP HANA SPS11+, kindly upgrade your SAP HANA to SPS11 to use benefits of XSA

1. Download XS Advanced Run-time from SMP

Myth of HANA

since SAP HANA was avaiable in the year 2011 (GA), I come across a lot of untruth about the new in-memory platform. As consultant I was able to talk to many costumers and other consultants on events like TechED, DSAG, Business partner days etc. Every time I was impressed after this long time that so much dangerous smattering is still out there.
The most answers to the statements are pretty easy to find in the offical notes, guides and other documents (blogs, presentations, articles etc.), but may it is an overload of information.

1) start time
2) cross SID backup
3) col / row store conversion
4) sizing *2
5) statistics
6) data fragmentation
7) persistency layer
8) high memory consumption HANA vs. Linux
9) Backup
10) Backup catalog