Smart Data Integration and SAP HANA as a Service
Priyanka Brodie, 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…
– 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:
- How to configure the Command Line Interface (this is optional, but I would recommend you have it): https://developers.sap.com/tutorials/cp-cf-download-cli.html
- How to configure your SAP Web IDE Full Stack: https://developers.sap.com/tutorials/webide-multi-cloud.html
- How to create an instance of the SAP HANA Service in SAP Cloud Platform. You can use either the Command Line Interface or the graphical one: https://developers.sap.com/tutorials/haas-dm-deploying-haas.html
- Enabling the features to develop with HANA: https://developers.sap.com/tutorials/haas-dm-configure-dev-env.html
- Accessing the Database Cockpit: https://developers.sap.com/tutorials/haas-dm-connect-hana-cockpit.html
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 (126.96.36.199 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-service/ .