After your SAP HANA XS project is activated, you should see many new objects installed in SAP HANA repository. Before testing your SAP HANA XS application, you should assign this role at a user account, you wish to test the application. To perform the role assignment, you must execute a procedure within the target SAP HANA instance. So, the steps required to execute this procedure, when working with SAP HCP trial account:
- Within Eclipse IDE, open SAP HANA DEVELOPMENT perspective, and switch to SYSTEMS tab.
- Select connection node for your remote SAP HANA instance and click on SQL button in top-level toolbar.
- This will open SQL CONSOLE window, within which you’ll want to build the call to HCP_GRANT_ROLE_TO_USER procedure.
- Once your CALL statement procedure has been crafted, click on EXECUTE button to perform the assignment.
If you’re working with a customer or a partner account, the role assignment procedure is similar to that of a trial account but it calls for the use of a different set of stored procedures.
Importing Test Data
After the role assignments are finished, your application is live for business. But, the tables created are empty. So, to get things up and running, you need to load your data model with some test data. One of the convenient ways of accomplishing data loads is to use the data import model wizard included in SAP HANA Tools plug-ins installed in Eclipse IDE.