Skip to Content

In the next part of the Live 4 ERP Agility course, the SAP HANA Academy’s Tahir Hussain (Bob) Babar shows how to create a datastore to connect to a SAP HANA database in the SAP HANA Cloud Platform using SAP HANA Cloud Integration for Data Services (HCI-DS). This datastore will then be used as a target connection for where the data will be loaded. Check out Bob’s tutorial video below.

Screen Shot 2015-06-10 at 2.59.12 PM.png

(0:50 – 3:30) Creating the God User and Live4 System User in Eclipse

In the ERP Agility course the target system is the SAP HANA Cloud Platform. There are many ways to connect to the SAP HANA Cloud Platform and in this tutorial Bob will be using Eclipse. For more information about Eclipse please view this tutorial video (App Development on HCP: Setting up the Eclipse IDE) from the SAP HANA Academy.

Currently in Bob’s SAP HANA Development perspective in Eclipse he has no systems. Bob is going to create two connections. One will be the God User, which will have access to everything. The other be a user named Live4, which will be used throughout this project.

Right click in the white area of the system’s tab on the left hand side and select Add Cloud System. Enter your Landscape host name (Bob’s starts with us1). Then enter your SAP HANA Cloud Platform account name, user name and password before clicking next. On the next screen choose Productive instances and enter the instance’s name as well as the database user and database password before clicking finish to create the connection.

Screen Shot 2015-06-10 at 3.11.24 PM.png

If you expand the Catalog folder you can view the various schemas. In the User folder in the Security folder Bob has a user named Live4.

Now Bob right clicks on his system name and selects Add System with Different User. Then under Authentication by database user Bob enters Live4 as the User Name and the Live4 password before clicking Finish.

We’re going to place all of our content into the Tables folder of the Live4 schema of the Live4 user. The Live4 schema is our target system for HCI-DS.

Screen Shot 2015-06-10 at 3.14.26 PM.png

(3:30 – 9:15) Connecting HCI-DS to the Live4 Schema

In the DATASTORES tab of your HCI-DS account click on the blue plus button to build a new datastore. Bob names the datastore MyHCP and sets the Type as SAP HANA application cloud. Bob’s Application Type is the HANA Cloud Platform HANA. Then Bob enters his Account Name and Schema ID. Bob next enters live4 as his DB User Name and pairs it with the live4 user password.

Screen Shot 2015-06-10 at 3.18.31 PM.png

To get the necessary Access Token you must go to the SAP HANA Cloud Platform SDK/Client Console. Check out this video (App Development on HCP: Updating the Eclipse Tools and the SDK) from the SAP HANA Academy on how to install the SAP HANA Cloud Platform SDK.

Bob launches a command prompt and navigates to the hcpsdk he’s installed in his C drive. Bob opens the tools folder of his hcpsdk and identifies a tool called neo that is either a batch file or a shell script if you’re using Linux. If you’re ever unsure of which command to run you can enter neo help to see a list and description for all of the commands. Also entering C:\hcpsdk\tools>neo help list-schema-access-grants displays the necessary parameters.

So Bob enters C:\hcpsdk\tools>neo list-schema-access-grants –i (instance name) –a (account name) –h (host name) –u (SCN User ID)

Screen Shot 2015-06-10 at 3.23.46 PM.png

Then after entering his user password Bob sees that he has no Access Tokens allocated. So Bob enters a similar command to the previous one and types in

C:\hcpsdk\tools>neo grant-schema-access –i (instance name) –a (account name) –h (host name) –u (SCN User ID) –b (HCI-DS system)

Screen Shot 2015-06-10 at 3.25.20 PM.png

Now after entering his password Bob will have an Access Token allocated. So then Bob copies the access token and pastes it into his New Datastore window back in his HCI-DS account. After clicking save Bob will have created his connection from HCI-DS to the SAP HANA Cloud Platform.


Reminder the SAP HANA Academy will build, for free, an ad hoc SAP ERP Agile Solution for any SAP ERP or Business Suite customer. Please contact us hanaacademy@sap.com to inquire.


For further tutorial videos about the ERP Agility with HCP course please view this playlist.


SAP HANA Academy – Over 1,000 free tutorial videos on SAP HANA, Analytics and the SAP HANA Cloud Platform.


Follow us on Twitter @saphanaacademy.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Ben Hofmans

    Some additional information on the command to generate the access token. This command will be different based on the data center where your HCI and HCP accounts are hosted.

    For Europe (hana.ondemand.com or eu1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h hana.ondemand.com -u <userName> -b hcids:dsprod


    For US (us1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h us1.hana.ondemand.com -u <userName> -b hcidsus1:dsprodus1

    For Australia (ap1.hana.ondemand.com):

    neo grant-schema-access -i <schemaID> -a <account> -h ap1.hana.ondemand.com -u <userName> -b hcidsap1:dsprodap1

    Ben Hofmans

    Product Manager SAP HANA Cloud Integration for data services

    (0) 
    1. Rommel Cadavid

      Hi Ben,

      What’s happen if  my company’s HCIDS  is hosted at : us1.hana.ondemand.com but their HCP instancet at : us2.hana.ondemand.com, They hosted systems differs.  what about the neo command in that case, could be this way :

      neo grant-schema-access -i <schemaID> -a <account> -h us2.hana.ondemand.com -u <userName> -b hcidsus1:dsprodus1

      because the hcids is still on us1 data centre.
      thanks in advance.

      (0) 
  2. Ben Hofmans

    The scenario you describe is not feasible with HCI-DS. We do not offer HCI-DS in the US2 data center at the moment, so you are not able to load to a HANA database in US2 with HCI-DS. The HCI-DS instance in US1 can only load to HANA databases in US1.

    However, for loading data into HANA on HCP, we have included SDI (smart data integration) in all current HCI-DS bundles. For this specific scenario – loading data to a HANA database on HCP – SDI is a replacement for HCI-DS and provides more capabilities (more adapters, both batch and real-time replication, more data transformation options, …). SDI can be used in all datacenters, so could be used to load data into HCP on US2.

    Check my blog for more details on using SDI for HCP:  
    https://blogs.sap.com/2016/06/22/smart-data-integration-available-for-hcp/

    Thanks,
    Ben.

    (0) 

Leave a Reply