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.
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... .