Enable SAP Data Hub on your SAP HANA, express edition
After having SAP Data Management explained, I wanted to get my hands onto SAP Data Hub, if possible leveraging my SAP HANA 2.0, express edition.
|Before attempting to recreate my proof of concept scenario, I suggest you review the appropriate license agreements for the SAP software mentioned in this blog.|
I start with Updating SAP HANA, express edition (Virtual Machine) to SP 02. I always recommend to Secure your HANA, express edition, so if you did, you would not have to worry about any libraries being up to date.
Next, I am Installing SAP HANA Smart Data Integration. This has come a long way since I had to Enable Smart Data Integration on your HANA, express edition manually, but you might still find some of the steps helpful concerning user roles and in verifying that all works as expected, especially connecting a FileAdapter to it.
With this I Create Space DATAHUB in my HANAExpress Organization:
And continue with my SAP HANA Logical Database Setup:
To complete my SAP HANA Service Broker Configuration:
This allows me to Install SAP Web IDE for SAP Data Hub. I chose the latest P02 Patch 3 for SAP WEB IDE 2 which works fine with the webide_SPS02.mtaext file from SAP Note 2476922 – Installing the SAP Data Hub Modelling Tool:
As a result, I find the SAP Web IDE Web Client in my Installed Software Component:
Subsequently I install Product SAP_DATA_HUB:
As a result, I find SAP DATA HUB 1.0 in my Installed Products:
Finally, after a successful SAP Data Hub Setup:
I can log into my still mostly empty SAP Data Hub Cockpit:
And register my first BW and HANA systems:
In my next blog, I will connect my Data Hub to my SAP Vora Developer Edition.
Excellent blog, Frank! I'll be doing this trial of Data Hub on HXE 2.0 soon, with Vora, so I really appreciate your blog and insight!
In your next blog to connect Data Hub to Vora, could I recommend that you use Vora 2.0 rather than the old Vora 1.4 VM dev edition? Vora 2.0 is a key component of Data Hub 1.x, and I think it even requires Vora 2.0 in Kubernetes. The new Vora 2.0 architecture (Docker containers orchestrated in Kubernetes) is significantly different than in Vora 1.4 when it was installed on Hadoop.
The SAP HANA Academy recently published a YouTube video playlist on setting up Vora 2.0 with kubernetes (minikube) on GCP here SAP Vora 2.0 alongside their detailed scripts in GitHub. I've already done this (adding the Vora-diagnostics) and it's very easy to get Vora 2.0 up and running in GCP. I think Data Hub requires Vora 2.0 (and the Data Pipeline engine) running in Kubernetes. Using HXE2, Data Hub 1.x and Vora 2.0 provides the best scenario to prototype for developers.
Many thanks, Doug.
I followed your advise and used SAP Vora 2.0 on the GCP rather than the Developer Edition:
Connect your SAP Data Hub to SAP Vora and Hadoop
I'm just preparing an AWS environment with Kops Kubernetes Cluster and installation of Hana, express Edition 2.0 SP02.
During Hana Express Edition installation all stuff is deployed automatically in space SAP, also the Web IDE: I could not find any separate package for Web IDE in the specific HANA express download manager.
Thus my question, do I need to undeploy Web IDE in space SAP before I install it from scratch in space DataHub?
Yes, I am afraid you have to uninstall the Web IDE from Space SAP and reinstall the required Web IDE version in Space DataHub.
This weekend's TO-DO. Thanks, Frank.
Since the Architectural changes with SAP Data Hub 2.3, SAP HANA has been containerised to host the former SAP Data Hub Cockpit, i.e. you do not have to install it separately any longer.