Development in SAP HANA Cloud
What applications can you build with SAP HANA Cloud?
To unlock the complete potential of all the data you can access via your SAP HANA Cloud database, you can build and run applications that can access, display and transform this data according to need.
You can build any kind of applications you want, using any kind of programming language you prefer. SAP HANA Cloud offers a powerful transactional and advanced analytical database, which your application can connect to. Good examples of applications that would work well with SAP HANA Cloud include:
- Applications that support large-scale events, including registrations and ticket sales, complex schedules, personalized schedules, and digital communication between attendees
- Applications that display and analyze real-time information about multiple financial markets
- Applications that support a large network of franchises, allowing each franchise to not only stay informed but also make orders for products and work materials
- Applications that combine analytical processing with transactional workloads
- Multi-model applications combining geo-spatial data processing, graph analysis, NoSQL, and SQL workloads
- Applications accessing data from various sources like SAP HANA, data lake, Hadoop, Azure Blob Storage, and more
Learn more with the SAP HANA Cloud Deployment Infrastructure Reference.
To develop applications and bind them to an SAP HANA Cloud instance, you can use the SAP Web IDE full stack. The advantage of using SAP Web IDE full stack is that you can take advantage of the SAP Database Module, among others, to seamlessly connect your application to specific database schemas.
Learn more about binding your application to an SAP HANA Cloud instance.
SAP HANA Cloud can help you make sure your application has excellent performance as well, if you choose to host it with SAP Cloud Platform. This gives you freedom of choice of how to deal with your existing applications and the data they need, or the performance of you application overall.
Learn more here about the SAP Web IDE with our Developer Guide.
Which programming languages can you use to create applications on SAP HANA Cloud?
SAP HANA Cloud is one single data gateway to all data, which makes it ideal to use it as the central data platform for your custom or third-party applications. With SAP HANA Cloud, you can develop applications in one of the industry-standard programming languages and then connect your application to SAP HANA Cloud to natively communicate with your database using SQL interfaces.
SAP HANA Cloud provides customers with an integrated development environment called SAP Web IDE. There you can create your development projects and deploy them into production using SAP Cloud Platform. SAP HANA Cloud already offers clients for the following programming languages:
You can easily add a SAP HANA Cloud driver for your module in SAP Web IDE by adding it to the build descriptor (pom.xml, package.json, etc.). Most SAP HANA Cloud drivers are available on public registries like Maven Central or SAP’s NPM package registry to facilitate easy consumption.
SAP HANA Cloud is built around the flexibility and low maintenance aspects of a cloud-native solution, taking advantage of every tool that SAP can offer to help you build the applications you need powered by the SAP HANA engine.
Learn more about SAP Web IDE with this video:
Click here for a detailed learning mission on how to query an SAP HANA Cloud (or SAP HANA, express edition) database using SAP HANA Cloud clients in Node.js, Python, and Java from Windows, Linux or Mac.
Modeling data in SAP HANA Cloud
SAP HANA Cloud offers you the ability to create data models as design-time objects and then run them on the database. To model data, you will need to use SAP Web IDE, an SAP tool that can be enabled for your SAP HANA Cloud instance.
Learn here how to enable SAP Web IDE for your SAP HANA Cloud instances.
If SAP Web IDE is new to you, you should enable a few extensions that will make the data modeling process easier. These extensions are:
- SAP HANA Database Development Tools
- OData Model Editor
- SAP HANA Database Explorer
Learn here how to enable SAP Web IDE Extensions.
Once the extensions are enabled, you will need to setup a project and add a SAP HANA Database Module to this project. Make sure the project is set up with the SAP HANA Database Version: HANA Cloud.
Under the source folder of your SAP HANA Database Module, right-click on the folder and then click on New.
Here you can either choose to create a Database Artifact, which then allows you to choose between multiple artifact formats, or to go directly to creating a Calculation View. You can use the JAVA API to create Calculation Views out of JAVA. Click here to learn more.
Calculation Views offer more than just a graphical way of creating data models. Additionally, Calculation Views allow you to leverage SAP HANA specific performance techniques and to benefit from analytic features that are readily available using a graphical tool.
Beyond just the graphical interface, using a calculation view for your modeling offers other advantages. For example, Calculation Views nicely integrate into version control and life-cycle management tools. This allows you to manage different versions of your views, transport it into different systems, and ensures a consistent dependency management. It also makes it very easy for you to share your view with your colleagues, by using Git.
There’s much more to discover about data modeling and calculation views. Here are some recommended resources to learn more: