Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)

This article "Load Demo data in SAP Vora Using Eclipse HANA Modelling tools - Part 3" is continuation of "Configure SAP Vora HDP Ambari - Part 2"

You will need to download Eclipse Neon - Eclipse IDE for Java Developers to connect to the SAP HANA that we setup in Part 1 . After you setup eclipse we will need to configure Eclipse to install HANA Modelling tools that will allow us to connect to SAP HANA and execute sql scripts to setup demo data that we will use from SAP Vora.

Eclipse Setup Procedure

  1. Open the Eclipse IDE.
  2. In the main menu, choose HelpInstall New Software .
  3. Depending on the Eclipse version you have installed, enter one of the following URLs in the Work with field:
  4. Select SAP HANA Tools (the whole feature group).noteIn case you need to develop with SAPUI5, install also SAP HANA Cloud Platform ToolsUI development toolkit for HTML5 (Developer Edition) .
  5. Choose Next.
  6. On the next wizard page, you get an overview of the features to be installed. Choose Next.
  7. Confirm the license agreements.
  8. Choose Finish to start the installation.
  9. After the successful installation, you will be prompted to restart your Eclipse IDE.

Log back in to SAP Cloud Appliance Library - the free service to manage your SAP solutions in the public cloud. You should have HANA and Vora instances up and running. Click on SAP HANA Connect link and click open:

8014-screen-shot-2016-09-26-at-14819-pm.png

You should see the HANA home page for your instance:

8015-screen-shot-2016-09-26-at-15121-pm.png

You will see a warning for 'hosts' file please follow the steps to setup your hosts entry in your local sytem, this will simplify your life.

  1. Open your Terminal or Shell application and type the commandsudo nano /etc/hosts
  2. Add the following line or modify it if you already have it.

    xxx.xxx.xxx.xxx vhcalhdbdb

You will need the server connectivity and CODEJAMMER information for steps in setting up eclipse.

Next lets create a new HOST in eclipse HANA tools. CLICK ADD SYSTEM...

8016-screen-shot-2016-09-26-at-15500-pm.png

Now you will need to add the hostname that you got from HANA home page above, instance is 00, connect using Role: Developer

User: CODEJAMMER Password: CodeJam2016

8017-screen-shot-2016-09-26-at-15629-pm.png

You should have a successful connection like this.

8013-screen-shot-2016-09-26-at-14405-pm.png

Right click on the new system you setup and opensql console

and run the following code:

DROP TABLE "CODEJAMMER"."EMPLOYEE_ADDRESS";

CREATE COLUMN TABLE "CODEJAMMER"."EMPLOYEE_ADDRESS" ("STREETNUMBER" INTEGER CS_INT,
   "STREET" NVARCHAR(200),
   "LOCALITY" NVARCHAR(200),
   "STATE" NVARCHAR(200),
   "COUNTRY" NVARCHAR(200)) UNLOAD PRIORITY 5 AUTO MERGE ;

insert into "CODEJAMMER"."EMPLOYEE_ADDRESS" values(555,'Madison Ave','New York','NY','America');
insert into "CODEJAMMER"."EMPLOYEE_ADDRESS" values(95,'Morten Street','New York','NY','USA');

Next lets test to make sure you got data , run the following sql command:

SELECT * FROM "CODEJAMMER"."EMPLOYEE_ADDRESS";

You should get a result like this:

8018-screen-shot-2016-09-26-at-23952-pm.png

Congrats you create an "EMPLOYEE_ADDRESS" table and populated with sample data. Next article will load this sample data from the Apache Zeppelin. Perform Data Analysis using SAP Vora on SAP Hana data - Part 4

References:

http://go.sap.com/developer/tutorials/hana-web-development-workbench.html

https://help.hana.ondemand.com/help/frameset.htm?b0e351ada628458cb8906f55bcac4755.html

https://community.hortonworks.com/articles/27387/virtual-integration-of-hadoop-with-external-system....

https://community.hortonworks.com/content/kbentry/29928/using-spark-to-virtually-integrate-hadoop-wi...

http://help.sap.com/Download/Multimedia/hana_vora/SAP_HANA_Vora_Installation_Admin_Guide_en.pdf

http://go.sap.com/developer/tutorials/hana-setup-cloud.html

http://help.sap.com/hana_vora_re

http://go.sap.com/developer/tutorials/vora-setup-cloud.html

http://go.sap.com/developer/tutorials/vora-connect.html

http://help.sap.com/Download/Multimedia/hana_vora/SAP_HANA_Vora_Installation_Admin_Guide_en.pdf

1,340 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 09:38 AM
Updated by:
 
Contributors
Top Kudoed Authors