Skip to Content

Abstract

          SAP Business objects(BO) is a popular Enterprise software company that develop desktop and web applications for data analysis and reporting . Besides this, Business objects Enterprise provides a Standard Development Kit (SDK) for developing customized tools.Business objcets (BO) Report engine Java SDK (Software Development Kit) is a set of development tools primarily used for the customization of the existing tools available within Business objects.We can also use Dot Net(.NET) SDK. This customization will make the work of report developers easy. This artifact will be helpful to get start with BO Java SDK integration to develop customized BO tools using NetBeans. Business objects has a set of jar(java archive) files when installed.Using the predefined classes and methods  present in the jar files developers can customize and develop a tool as per the business needs.


Software Requirements:

  1. 1)  Netbeans 8.0.1
  2. 2)  Apache Tomcat 7.0 or above
  3. 3)  JDK 1.7 or above (Java Development Kit)

Windows Configuration:

What is a host file?

The HOSTS file is a text file that contains IP addresses separated by at least once space and then a domain name, with each entry on its own line. Any websites can be blocked or unblocked or communication with external servers on a particular machine can be blocked with this host file.

Step 1: The host file will be located in the following path.

C:\Windows\System32\drivers\etc

/wp-content/uploads/2015/02/1_653264.jpg

Step 2: Find the ip address and full host name of the BO 4.1 server

     (a) Find the ip address.

To protect the system from vulnerably all the communication with some external servers will be blocked by default. To create a communication between an external server , developers have to get the help of admin team and ask them to provide the host file entry in their machine with required details. To make a host file entry there are two important things.

  1. 1. IP address
  2. 2. Full HOST name.

The IP address of the server can be found by the following method


          Start -> Run -> cmd -> ipconfig


Note: Developer should be logged in the server machine to do the above operation.

If login to the server is not available, then contact the server administrator to get this done.

    

     (b) Find the Full host name.

Right click on my computer icon in desktop and choose Properties option.

/wp-content/uploads/2015/02/2_653266.jpg

Step 3: Enter the ip address and full host name into the host files as shown in the figure and example.


  1. 127.0.0.0 CHDSEZXXXXXXX  CHDSEZXXXXXX

/wp-content/uploads/2015/02/3_653280.jpg

Tomcat server Configuration:

This following are the steps to configure the username and password for tomcat server which is installed in the local machine.

Step a: Go to the conf folder which will be present inside Apache tomcat installation folder


<Installation_Path>\ Apache Tomcat 8.0.15\ conf

The installation path used here is as follows,


C:\Program Files\Apache Software Foundation\ Apache Tomcat 8.0.15\ conf

/wp-content/uploads/2015/02/7_653312.jpg

Step b: Inside the conf folder there will be a file named tomcat-users.xml. Right click on that file and choose open with -> Notepad


/wp-content/uploads/2015/02/8_653313.jpg

Step c: In the file there will be some sample username and sample provided with comments. Using this file users of this server can be restricted by enabling them limited access. For development needs, username and password with role as manager-script has to be created.


Ex.

<role rolename=”manager-script”/>

<user username=”tomcat” password=”password” roles=”manager-script”/>

Copy and paste the above code in the tomcat-users.xml file within the <tomcat-users> tag and save it. During server configuration enter these credentials. Now, the program will be able to run in the Tomcat server.

/wp-content/uploads/2015/02/9_653314.jpg

Algorithm:

Following are the step by step procedure to develop a web application which will list all the universes from the BO 4.1 server by accessing CMC (Central Management Console) from a local machine using Net Beans.

Step 1: create a new project using the NetBeans IDE 8.0.2.

/wp-content/uploads/2015/02/10_653324.jpg

Step 2: Choose project as Java Web -> Web Application and click on next.

/wp-content/uploads/2015/02/11_653327.jpg

Step 3: Give the appropriate Project name and project location and click on next button.

/wp-content/uploads/2015/02/12_653329.jpg

Step 4: Choose Apache Tomcat or TomEE server by clicking ADD button. This tomcat server is on local machine and is used to run the java code using netbeans IDE on local machine to access the BO 4.1 server.


/wp-content/uploads/2015/02/13_653333.jpg

Note: The tomcat server should be installed in a local machine. There are lot of web servers available like Glassfish, tomcat, etc…It is not mandatory to use Tomcat as web server. Depending upon the availability, any of the web servers can be used along with netbeans from our local machine. But it is mandatory that there should be at least one web server installed in our local machine.

Step 5: Choose Java EE 5 from the Java EE Version dropdown list, as it has the provision to access web.xml file and edit it. The web.xml is a file which will be automatically created during the creation of new project in netbeans. It is used to control many facets of a Web application. Using web.xml, one can assign custom URLs for invoking servlets, specify initialization parameters for the entire application as well as for specific servlets, control session timeouts, declare filters, declare security roles, restrict access to Web resources based on declared security roles, and so on.

/wp-content/uploads/2015/02/14_653334.jpg

Step 6: Framework is a bunch of predetermined software program that forms the basis for an application which can be reused. It helps the developers to develop their application more quickly and easily. It was very hard to develop a complex web applications in early days. But, now because of these frameworks it is very easy to develop such complex application using different kinds of frameworks such as Struts 2, Hibernate, JSF, Spring etc. Choose any of these frameworks for building a web application. Framework is not used in this web application. So, it can be ignored and click on finish button. A web Application will be created.

/wp-content/uploads/2015/02/15_653335.jpg

Step 7: Right click on the “Servers” option which will be available in the “Services” tab in the left pane and click on “Add server”

/wp-content/uploads/2015/02/16_653347.jpg

Step 8: Choose Apache Tomcat and Click next.

Note: In this step, the selected webserver will be configured.

/wp-content/uploads/2015/02/17_653345.jpg

Step 9: Click Browse and point to the Apache Tomcat installation folder.

/wp-content/uploads/2015/02/18_653348.jpg

Step 10: Enter the username and password which we created using the tomcat-users.xml for tomcat server and click finish. Server will be added under Servers in the Services tab.

/wp-content/uploads/2015/02/19_653350.jpg

Step 11: Right click on the Apache Tomcat or TomEE server under services tab and choose properties.

/wp-content/uploads/2015/02/20_653351.jpg

Step 12: By Default, Tomcat will choose 8080 port to run the server. If the local machine is installed with more than one web server then, conflict will arise. In order to avoid the conflict the ports should be checked whether they are open or close. Enter the port number in the “SERVER PORT” field. If it shows any error during server startup then change the sever port. The port should not be between the ranges (0-1023) as these are all system ports. Use any other unused port as server port which are not in the range mentioned above.

/wp-content/uploads/2015/02/21_653352.jpg

Step 13: After completion of the above steps, Right click on the server and choose start. The server should start without any error.

/wp-content/uploads/2015/02/22_653353.jpg

Step 14: To check whether tomcat is working or not, type http://<server-name>:8084/ in server where <server-name> is the name of machine where tomcat server is installed.

The tomcat server is installed in local machine so <server-name> is used here is local host. So the link will look like as follows.

/wp-content/uploads/2015/02/23_653354.jpg

Tomcat server will show a success message like “If you’re seeing this, you’ve successfully installed Tomcat. Congratulations!”

Manager App: Clicking on this will ask for user name and password. Enter the username and password which was created under manager-script role in tomcat-users.xml file.

Step 15: The Tomcat Web Application Manager will contain all the web applications that are created using Net beans. All the application will be deployed in tomcat as WAR file. Demo is a sample web application which will show how to create a BO 4.1 java SDK application.

/wp-content/uploads/2015/02/24_653355.jpg

Step 16: The demo web application is a simple java code to connect CMC (Central Management Console) of BO server 4.1 and retrieve the available list of universe from the local machine.

This web application will contain 3 JSP files.

     1.    Login.jsp -> To get  the cmc address,username,password

     2.    LoginCheck.jsp ->  To verify the credentials with CMC and Display the universe list.

     3.    Logout.jsp -> To logout from cmc.


Step 17: The library files of Business Objects in server has to be added into the library folder available in the left pane of net beans. Right click on Library and choose Add JAR/Folder.

/wp-content/uploads/2015/02/26_653367.jpg

Note: The required library files will be in the following path of the BO 4.1 server.


C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.1\java\lib

*  The installation path might change if BO 4.1 is installed in different location.

Copy the required jar files from this path and get it saved in a folder in your local machine where the netbeans is installed.


Step 18: Browse to that folder where the jar files is saved and select the jar files that needs to be imported. Click on open. This will import the required jar files into net beans environment. The communication between BO 4.1 server and the local machine has been established successfully.

/wp-content/uploads/2015/02/27_653366.jpg

Step 20: Run the program. The following output will be displayed in browser.

Output:


/wp-content/uploads/2015/02/29_653368.jpg

Conclusion:

          Business Object consists of various library files using which users can develop customized BO tools for Universe and report list generation, Scheduling of reports, Universe repointing, etc. depending upon the business needs. BO SDK also helps in automation of mundane tasks.

To report this post you need to login first.

2 Comments

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

Leave a Reply