Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
lsubatin
Active Contributor
pbrodie, an amazing intern in HANA Product Management, and I have been busy building some new tutorials based on SAP Cloud Platform, SAP HANA Service.

Fresh out of the oven, the tutorials cover everything from the creation of an instance of the SAP HANA Service in SAP Cloud Platform to consuming a remote source in a virtual table, in an HDI container.


Choose your own adventure


There are multiple reasons to get started with the SAP Cloud Platform, SAP HANA Service.

Since I am talking about the instances you can get in Cloud Foundry, you are probably landing there because you or someone in your company has purchased some memory blocks.











If you need some warm-up…




-          What is HANA as a Service?

-          Here is a more technical description with boxes and everything

-          No, you cannot currently create a full instance for free. BUT… you can use the trial HDI containers in the SAP HANA Service. This tutorial within this mission explaining how to develop an application using the Cloud Application Programming Model has all the instructions you need. You don’t really need a lot of instructions because the CAP model will declare the HDI container as a resource and Web IDE will then call the goblins that create the actual service and wiring behind the scenes.

-          If you don’t know what the CAP model is, an HDI container sounds as funny as a flux capacitor or you have not seen Web IDE before, I would spend half an hour watching this. (well, not me but you… who likes their own voice on video?)


 

How to setup your own instance of HANA as a Service


Including some preliminary steps:

The fun piece: Creating tables and loading data into SAP HANA


Of course it all starts with creating a new SAP HANA Database Multi-Target Application: https://developers.sap.com/tutorials/haas-dm-create-db-mta.html

There is not much new here.

Notice how we are not using `.hdbcds` but SQL DDL to generate tables. We are also loading sample data into them using one of the available methods for this.

Smart Data Integration using the File Adapter


Loading data into the SAP HANA Service using SDI is not as challenging as it sounds nor as different from the on-premise world with XS Advanced.

The full instructions are in this tutorial: https://developers.sap.com/tutorials/haas-dm-connect-sdi.html

From the Smart Data Integration perspective, the story goes like this:

  • Download the latest Data Provisioning Agent from the Marketplace (2.3.5.2 or higher). You’ll need SAPCAR to extract it

  • I would uninstall previous versions of DPA if you have any. This was recommended to me, I didn’t do it at first and my local operating system did not like it

  • Configure the connection to use Web Sockets… You get through this option by choosing “JDBC” first (no, not the first option, but the third...)

  • In my case, I am using the file adapter, so I register that agent once my connection is successful

  • Then, I go into the database explorer, log in to the database and create a remote source.

  • And this is the last thing I will create here. The virtual tables will be created in my HDI container.


 

Again, the step-but-step instructions without quirky comments are here.

The remote source needs to be accessible from my HDI container but… remember… HDI containers do not just see objects outside them!



You need to make the remote source visible to your database module before you can use it in a flowgraph or replication task in an HDI containers.

You know the drill from on premise XS Advanced... Cross schema access with user-provided services and synonyms!

I'm covering this in this next blog post: https://blogs.sap.com/2019/02/23/smart-data-integration-cross-container-access-and-the-sap-hana-serv... .
10 Comments