Tuesday 15 January 2019

Develop a full-stack multi module business application(MTA) by using java as middle-ware

In this blog, I will explain the step by step process to create a multi module business application(MTA) by using java as the middle-ware component with the help of SAP Web IDE full-stack and this application will be deployed onto the Cloud Foundry trail account.

Functionality of the Application :- Here I am going to display the list of employees of an organization.

Technical Architecture : –


SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

Prerequisites: –


1. Access to SAP Web IDE Full-Stack.
2. Enable SAP HANA Database Development Tools, Tools for Java Development, SAP HANA Database Explorer and SAP Cloud Platform Business Application Development Tools features in Web IDE.
3. Enable Cloud foundry in the SCP trail account.
4. Create Space and Organisation in the Cloud Foundry account.
5. Configure the Cloud Foundry space and install the Builder.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

Application: –


◈ Launch SAP Web IDE full-stack and create a MTA application from the template.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ One MTA project will be created in your workspace with name MTA_Employee.
◈ Create a DB module for the MTA project as shown below.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Create a CDS view in the DB module as shown below.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Give the name of the CDS view as Organization.
◈ One CDS view will be created under scr folder, now open the CDS view in the Code Editor and replace the entire code with the code given in the path Organization.hdbcds..
◈ Build the CDS view to create the Employee table in the HANA DB.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Once the Build is successful one table will be created in the DB, which can be checked from the Data Base explores by adding the DB to the  DB explorer in the Web IDE.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Add some records into the table by generating and executing the insert statement.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Execute the above SQL query by putting some values as shown in the screenshot.
◈ Create a calculation view in the DB module to read the Employee table.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ One Calculation view will be created under the src folder with name GetEmployees, now open it in the Code Editor and replace the entire code with the code given in the path ◈ GetEmployees.hdbcalculationview.
◈ Build the DB module by right clicking and selecting Build on the DB folder.
◈ Now we will create Java module.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Now Java module is created and the folder structure will look like as below.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Open the pom.xml and replace the entire content with code given in the path pom.xml.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Open the web.xml and replace the entire content as given in the path web.xml.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Now create the below java classes and copy the code from the mentioned path. Make sure the folder structure is exactly same, create the missing folders.

     - GetEmployeeServlet  :-  GetEmployeeServlet.java
     - EmployeeEDMProvider :- EmployeeEDMProvider.java
     - EmployeeProcessor :- EmployeeProcessor.java

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Java module is now created, build the Java module as shown below.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Now Create UI module.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ UI module is now created and the folder structure will look like as below.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Open the following files and replace the content from the mentioned path.
     - Xs-app.json :- xs-app.json
     - Home.view.xml :-  Home.view.xml
     - Component.js :- Component.js

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Open the mta.yml file in the editor mode and replace the entire content with the code from the path mta.yaml.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ MTA application is now ready, build the MTA application to create the achieve file.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Once the build is successful then you can find the archive file under the mta_archives folder.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Deploy the .mtar file to the Cloud Foundry.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ You will be prompted to enter the details of the Cloud Foundry.
◈ Once the deployment is successful then you can see three applications in the Cloud Foundry.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Click the UI application to find out the URL of the MTA App.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Learning, SAP HANA Tutorial and Material

◈ Click the URL to run the application.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Guides

5 comments: