Skip to Content
Technical Articles
Author's profile photo Eileen Koehler

Setup of SAP HANA Database in SAP Hana Cloud Platform Trial Account to build Segmentation Views for Hybris Marketing Cloud

With SAP Marketing Cloud you are able to import own SAP HANA Views for segmentation by using the SAP Fiori App “Add Custom View”. This blog will tell you until SAP Marketing Cloud version 2005 which steps you need to carry out before you can start to build your own views using an SAP HANA Database in your SAP Hana Cloud Platform (HCP) Trial Account. For SAP Marketing Cloud version 2008 onwards, please read blog post Create Hana 2.0 Custom Views in SAP Web IDE using Cloud Foundry Trial.  

Bildschirmfoto 2016-06-14 um 19.25.31.png

Prerequisites: Creation of SAP HCP Trial Account and Setup of SAP HANA Tools for Eclipse

If you have not signed up for an SAP HCP trial account so far, register yourself on https://account.hanatrial.ondemand.com.

Afterwards logon to your account. Setup your eclipse environment with SAP HANA Tools as described here. You can also use the Webtools as describe here. You will need the SAP HANA Tools in order to logon to your SAP HANA Database.

Creation of SAP HANA Database

You create a SAP HANA database in your account with the following steps:

  1. Logon to your SAP HCP Trial Account.
  2. Choose Databases & Schemas in the navigation area left.
  3. Choose New on the Databases & Schemas page. The New Database/Schema screen is displayed.
  4. Enter a database ID like “marketingcloud” and select (HANA MDC (<trial>). Define a password for the SYSTEM User. You will logon with this user and your password to your database for first time usage.
    /wp-content/uploads/2016/06/1_985333.jpg
  5. Choose Save. The Events page is displayed. It shows the progress of the database creation. Wait until the tenant database is in state Started and visible on your Databases & Schemas list.
    /wp-content/uploads/2016/06/2_985361.jpg

Connect to your SAP HANA Database from your Eclipse

You connect to your SAP HANA database from Eclipse with the following steps:

  1. Go to /wp-content/uploads/2016/06/1_985426.gif Window /wp-content/uploads/2016/06/2_985445.gif Show View /wp-content/uploads/2016/06/2_985445.gif Other /wp-content/uploads/2016/06/3_985463.gif
  2. Select /wp-content/uploads/2016/06/1_985426.gif SAP HANA /wp-content/uploads/2016/06/2_985445.gif Systems /wp-content/uploads/2016/06/3_985463.gif and choose OK.
  3. From the Systems context menu, choose /wp-content/uploads/2016/06/1_985464.pngAdd Cloud System.
  4. Enter your SAP HANA Cloud Platform account information:account name, e-mail or user name, and password.
  5. Choose Next.
  6. In the SAP HANA Schemas and Databases window, choose radio button Databases./wp-content/uploads/2016/06/4_985376.jpg
  7. From the dropdown menu, select your database, e.g. marketingcloud, and enter database user SYSTEM with your defined password.
  8. Choose Finish.
  9. You are now connected to your SAP HANA database./wp-content/uploads/2016/06/5_985377.jpg

 

Create SAP HANA Database User

For modelling of views a sufficient SAP HANA database user is needed. You create a user with the following steps:

  1. From the context menu of your SAP HANA cloud database, choose/wp-content/uploads/2016/06/2_985465.pngOpen SQL Console.
  2. Enter the following script and /wp-content/uploads/2016/06/3_985499.png Execute it:
    CREATE USER HANA_USER PASSWORD Initial1;
    GRANT CONTENT_ADMIN TO HANA_USER;
    GRANT MODELING TO HANA_USER;
    GRANT CREATE SCHEMA TO HANA_USER;
    GRANT EXPORT TO HANA_USER;
    GRANT IMPORT TO HANA_USER;
    CALL GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE(‘_SYS_BI_CP_ALL’,‘HANA_USER’);
    GRANT REPO.READ ON“.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.MAINTAIN_NATIVE_PACKAGES ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.MAINTAIN_IMPORTED_PACKAGES ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.EDIT_NATIVE_OBJECTS ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.EDIT_IMPORTED_OBJECTS ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.ACTIVATE_NATIVE_OBJECTS ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
    GRANT REPO.ACTIVATE_IMPORTED_OBJECTS ON “.REPO_PACKAGE_ROOT” TO HANA_USER;
  3. Logon with the user HANA_USER to your SAP HANA cloud database with initial password Initial1 like described in section “Connect to your SAP HANA Database from your Eclipse”.

 

Create Schema ABAP

Hybris Marketing Cloud requires modelling of calculation views based on tables in schema ABAP. Create a schema ABAP with the following steps:

  1. From the context menu of your SAP HANA cloud database, choose/wp-content/uploads/2016/06/2_985465.pngOpen SQL Console.
  2. Enter the following script and /wp-content/uploads/2016/06/3_985499.png Execute it:
    CREATE SCHEMA ABAP;
    GRANT SELECT ON SCHEMA ABAP TO _SYS_REPO WITH GRANT OPTION;
    CREATE SCHEMA SAP_CUAN_CRM;
    GRANT SELECT ON SCHEMA SAP_CUAN_CRM TO _SYS_REPO WITH GRANT OPTION;
  3. To check that the schema was created successfully choose Refresh from the context menu of folder Catalog. Afterwards expand the folder.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raphael Schmitz
      Raphael Schmitz

      Awesome functionality!

      Author's profile photo Former Member
      Former Member

      Very helpful!

      Author's profile photo Mohd Iqbal Quraishi
      Mohd Iqbal Quraishi

      Good blog

      Author's profile photo Mouhssen Bensalem
      Mouhssen Bensalem

      good tutorial, thankx

      Author's profile photo PRAKHAR VASHISHT
      PRAKHAR VASHISHT

      very nice and brief!!

      Author's profile photo Former Member
      Former Member

      Resourceful

      Author's profile photo Former Member
      Former Member

       

      I have forgot my password for the Hana trial account , how to reset it .

      thanks

      Author's profile photo Eileen Koehler
      Eileen Koehler
      Blog Post Author

      Hi Nitin,

      on the Hana Trial account page account.hanatrial.ondemand.com press the logon button. On the next screen press the button "Forgot password".

      Best regards,

      Eileen

      Author's profile photo Noor Fathima H
      Noor Fathima H

      Hi Eileen,

      For my newly created database, default database user 'SYSTEM' am unable to logged into it.

       

      Thanks

       

      Author's profile photo Eileen Koehler
      Eileen Koehler
      Blog Post Author

      Hi Noor,

      please see this Q&A: https://answers.sap.com/questions/171549/sap-cloud-platform-trail-version-forgot-password-o.html

      Best regards,

      Eileen

      Author's profile photo Tobias Schneider
      Tobias Schneider

      Hi,

      I'm missing the "Add Cloud System" in the Systems Context Menu for Eclipse Oxygen.

      Does anyone have an idea how to solve that problem?

      Best regards

      Tobias

      Author's profile photo Senthilvel Murugesan
      Senthilvel Murugesan

      Hi Tobias,

      Please use Neon version of Eclipse. Oxygen has some problem and it is not allowing.

       

      The link for Neon is http://www.eclipse.org/downloads/packages/release/Neon/3

      Author's profile photo Tobias Schneider
      Tobias Schneider

      Hi Senthilvel,

      works fine, thank you! 🙂