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.
(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.
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.
(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.
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)
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)
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 email@example.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.