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.

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. 1. Logon to your SAP HCP Trial Account.

1. 1. Choose Databases & Schemas in the navigation area left.

1. 1. Choose New on the Databases & Schemas page. The New Database/Schema screen is displayed.

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

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

Connect to your SAP HANA Database from your Eclipse

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

1. 1. Go toWindowShow ViewOther

1. 1. SelectSAP HANASystemsand choose OK.

1. 1. From the Systems context menu, chooseAdd Cloud System.

1. 1. Enter your SAP HANA Cloud Platform account information:account name, e-mail or user name, and password.

1. 1. Choose Next.

1. 1. In the SAP HANA Schemas and Databases window, choose radio button Databases.

1. 1. From the dropdown menu, select your database, e.g. marketingcloud, and enter database user SYSTEM with your defined password.

1. 1. Choose Finish.

1. 1. You are now connected to your SAP HANA database.

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. 1. From the context menu of your SAP HANA cloud database, chooseOpen SQL Console.

1. 1. Enter the following script andExecute 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;

1. 1. 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. 1. From the context menu of your SAP HANA cloud database, chooseOpen SQL Console.
      

1. 1. Enter the following script andExecute 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;

1. To check that the schema was created successfully choose Refresh from the context menu of folder Catalog. Afterwards expand the folder.