Tuesday, 26 January 2016

SAP Development Guide




It is basically a German software company whose products allow businesses to track customer and business interactions. It is well known for ERP (Enterprise Resource Planning) and data management programs.SAP means Systems, Applications and Products.

Disks I/O has been a performance bottleneck since the beginning of three tier architecture which led to SAP emerging and developing in-memory technologies to accelerate its applications.


It is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. A revolutionary platform that’s best suited for performing real-time analytics, and deploying real-time applications.


Filling this information will allow you log in to the AWS


 Configuring your eclipse for SAP HANA installation

1)      Download the Luna Eclipse IDE from  : http://eclipse.org/downloads
2)      Unzip your eclipse
3)      On the help menu, Go to Help Install new Software then add: https://tools.hana.ondemand.com/luna
4)      Select all the  tools, done.
6)      SAP Hana Studio Developer Edition  (similar to eclipse installation,you don’t have to do this if you have installed it as a plug-in in eclipse)  can be downloaded from :


After the eclipse have been installed, Open the SAP HANA perspective. Through: Windows > Open Perspective > Other, then choose the SAP HANA Development Perspective.
Now you should connect with the SAP HANA Trial Instance in the cloud.
Select the systems tab which is part of the SAP HANA Development Perspective.

Ensure you have a SAP Hana Instance on the cloud,which you can create via the developer zone as shown below:



Click on the button New Trial Instance which gives you a form to fill with the details





It should give you the following screen after save:


You should have this perspective after  eclipse has finished installing the SAP HANA:


Fill in:
Go to Start of the navigation path Window Next navigation step Open Perspective Next navigation step Other End of the navigation path.
Select SAP HANA Administration Console and choose OK.
From the Systems context menu, choose Add Cloud System.
The Account Information window displays the default landscape host. Modify it manually entering your productive or trial landscape. For more information about landscapes, see Landscape Hosts.
Enter your account name, e-mail or SCN user name, and SCN password.

Account name:         ****************
Username:         *****************
Password:    *****************


Choose Next.
In the SAP HANA Schemas and Databases window, choose radio button Databases.
From the dropdown menu, select the database you want to work with.
Enter your database user and password. For more information, see Creating a Database Administrator User.
Choose Finish.
You are now connected to a dedicated SAP HANA database.

When finished it will give you the Repository, and ready to work with SAP HANA


Creating a repository
To start development on SAP HANA you need to create a Repository
Open the Repositories tab of the SAP HANA Development Perspective
Choose the Create Repository Workspace button:

The new Repository is now ready and will be shown in the Repositories Tab:
Congratulations: With this you are now ready to start your first SAP HANA project with Eclipse.

If objects (tables/views) of a schema (say SCHEMA_ABC) are used to build modeling views then it’s necessary to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.

The following SQL statement must be executed before activating any such modeling views.

If you miss this step, an error will occur when you activate your views later.

Explanation: The activation of modeling views are done in the name of user _SYS_REPO.
Think of _SYS_REPO as "the activation guy". It takes your models and creates the necessary runtime objects from them. Therefore user _SYS_REPO needs the allowance to select YOUR tables/views. (If _SYS_REPO user cannot select on the tables specified in the from-clause of the view-definition, it cannot define that view)
Exposing Services through Odata
Create a file named as model_access.hdbrole.
In that file type the below contents:
role p1941724669trial.mugambinstance.SAP_Exercise::model_access {

Create a file named as businessPartners.xsodata.In that file the contents are as below:
service namespace "sapfirst.services" {
 "NEO_1V39L2WI3XXZTKGTIZGFNYKLF"."DCLS" as "BusinessPartners" ; 

Call this on your sap- hana console:
You can now access your service on the cockpit using the url as :
this will display the metadata
While the data in entity as:
If the table has no data I use a quick insert into the hana console using the query:

 VALUES(100001,'LSO','XDRETY1','XDRETY1','XDRETY1','XDRETY1','Text Field','2015-12-03',1001);

Enjoy and be free to share your opinions.


No comments:

Post a Comment