Skip to Content

Pre Installation Steps

Take the necessary screen shots for the configuration of below mentioned items after the installation of BODS.

  1. Job Server Details(Repositories that are associated with job server)
  2. Access Server Details
  3. Data Management Console Details
    1. List of users to be added in the Data Management Console
    2. List repositories to be added to the Data Management Console
    3. List of Scheduled batch Jobs
    4. List of Real-Time jobs
    5. List of jobs to be added in Web Services
    6. Other configurations that need to be performed

DI Installation Steps

  1. Copy the Data Services software from the path to the existing server and then start the installation.
  2. Start the installation by running the setup.exe. After the “Welcome” screen is displayed, click Next to begin your installation.
    /wp-content/uploads/2014/09/as_542957.png
  3. Agree to the license terms by selecting I accept the license Agreement. Click Next to continue.
    /wp-content/uploads/2014/09/as_542957.png
  4. Enter the Full name, organization and product key code. Click Next to continue.
    /wp-content/uploads/2014/09/as_542957.png
    – Enter the Product Key for Data Integration Premium
    – Enter the Product Key for Data Quality Management Premium
    – Enter the Product Key for Universal Data Cleanse
  5. Select the path to install the software in destination folder. Click Next to continue.
  6. Select all features to install. Click on the topmost down arrow next to “Data Services” and select “Entire feature will be installed on local hard drive” so that all the features in the tree will be selected.  After selecting click Next to continue.
    /wp-content/uploads/2014/09/as_542957.png
  7. Click on “Skip Configuration”, in case you already have a repository database available for your environment. This will automatically skip the “Job server” configuration as well, which we can manually do after installation.
    /wp-content/uploads/2014/09/as_542957.png
  8. Click the Next button to continue with the Service Login Information. Check the option Use a service account and click the Next button to continue.
      – User Name: <user-name>
      – Password: <password>
    /wp-content/uploads/2014/09/as_542957.png
  9. Skip the “Access Server” configuration as well, which we can do manually do after installation.
    /wp-content/uploads/2014/09/as_542957.png
  10. Click Next to select the web application server.
  11. Select Install Tomcat application server” option to install Tomcat on the same server where BODS is installed. The war files will be deployed as part of the installation.
    /wp-content/uploads/2014/09/as_542957.png
  12. We shall then copy the war files and deploy them manually in the Weblogic server, after completion of installation./wp-content/uploads/2014/09/as_542957.png
  13. Click Next to finalize the installation. The list of programs and services to be installed are displayed. Check all the details and then click Next to Continue.
    /wp-content/uploads/2014/09/as_542957.png
  14. Click the Next button to start the SAP BODS installation. After successful installation of SAP Business Objects Data Services reboot the server, to reflect configuration changes./wp-content/uploads/2014/09/as_542957.png
  15. Click Finish to exit installation. Next Restart the System to configure BODS installation./wp-content/uploads/2014/09/as_542957.png
  16. Click Yes. After machine restart do the initial validation to check the SAP BODS Services and Programs installed. Click Start then All Programs, next check the SAP BODS Installed programs./wp-content/uploads/2014/09/as_542957.png
  17. Install DS service pack SP2.
    /wp-content/uploads/2014/09/as_542957.png
  18. Then install the DS fix pack version

    Note: Once installation has been completed and restarted the server, open the Command Prompt with “Run as Administrator”, go to the DS installation folder and run the below commands one by one to register the OCX files in the “Registry”. Otherwise Data Services Designer will not work.    
    REGSVR32.EXE BODataView.ocx
    REGSVR32.EXE BODiffCtrl.ocx

Configuring Job Server & Access Server

  1. Open Data Services Server Manager -> Click on “Edit Job Server Config” -> Click on Add and provide the Job Server configuration as below.                      Job Server name: <Name of Job Server>                     Job Server port: 3500           
                                 Enable both the check boxes
               
                                 Communication Port: 4001
    /wp-content/uploads/2014/09/as_542957.png
  2. Click on “Add” button at the bottom and add a repository to the job server. Provide an existing repository details at the right hand side and click on “Apply”.
    /wp-content/uploads/2014/09/as_542957.png
    Note: The above screen shot is to add the repository associated with the MS SQL Server. Depending on the back end database associated,
                      we need to provide the corresponding details.
          
  3. Follow the same procedure to add the repositories to the job server and click on Ok. The added repositories appear on the left side, as shown below.          
           /wp-content/uploads/2014/09/as_542957.png 
  4. Click on Ok twice and click on “Edit Access Server Config” to add a new Access server.          
  5. Click on Add and provide the below details                
    Directory: D:\ProgramFiles\BusinessObjects\BusinessObjectDataServices\bin\DS_AS_<ENV>_<Name>              

    Note:The folder structure might differ depending on the acceptance of the server installing. The spaces present in the path might need to be                               removed if the system does not accept the path while installing the DI software.       
                                            /wp-content/uploads/2014/09/as_542957.png

  6. Click on Ok twice and configure SMTP by providing the details, and click on Apply.             
  7. The screen looks like this:                          
       
    /wp-content/uploads/2014/09/as_542957.png
  8. Click on Restart to submit the Job server and Access server configurations. This will take few minutes and the window closes automatically.

Test Case:

  1. Open the Data services Designer for successful login to repository (Database Server Name).
  2. Check whether Data services Server Manager is working.
  3. Check whether Data services repository Manager is working.

Data management Console configuration on Weblogic Server      Deploy DS on Weblogic

  1. Browse to: “D:\ProgramFiles\BusinessObjects\BusinessObjects Enterprise 12.0\java\applications” in the BODS installation server.
  2. Copy DataServices.war, Doc.war & webservice.war from above location and paste them to D:\BOEAPPS  on the Weblogic Server.
  3. Create a new domain in the Weblogic Server.
  4. Create the DI Installation folder structure in the D: drive of WebLogic server. D:\ProgramFiles\BusinessObjects\BusinessObjectDataServices
  5. Create 2 folders under the above mentioned directory.
    1. conf
    2. ext

      Note: Once we deploy the war files using Weblogic admin Console, “admin.xml” file gets created under this directory in conf folder once we launch the Data Management Console. The repository and user details of Management Console gets stored in this file.

  6. Log in to admin server console in Weblogic server and go to “Deployment” tab and click on Install.
    /wp-content/uploads/2014/09/as_542957.png
  7. Now you have to enter the path in which the .war files are present. Now click next so that it will display the files present in the path. Now select the radio button DataServices.war. Click Next to continue./wp-content/uploads/2014/09/as_542957.png
  8. Select the Radio Button Install this deployment as an application” and click next to continue.
    /wp-content/uploads/2014/09/as_542957.png
  9. Now select the deployment target by checking the box <Domain Server>. Click next to continue.
    /wp-content/uploads/2014/09/as_542957.png
  10. Keep the default settings & click Finish.
    /wp-content/uploads/2014/09/as_542957.png
  11. Now the confirmation screen appears, select the radio button “No, I will review the configuration later” cross verify the details and click on finish.
    /wp-content/uploads/2014/09/as_542957.png
  12. Now go to Deployment” section and check the status of the application you have installed. It has to be in “Active” state. Some war files take longer than the others to install, so please be patient.
    /wp-content/uploads/2014/09/as_542957.png
  13. Now double click on the application that has been installed to open the settings of the application. Now go to “Testing” tab and take the url to access the application.

    Note: To access the Data Services Management Console, use admin as user name and password to generate the admin.xml file for the first time.
    /wp-content/uploads/2014/09/as_542957.png

Test Case:

Make sure that the Data Management Console is running with the link provided in the testing tab. 

Add a repository to the console, then restart the Weblogic server and check if the configuration still remains in the console.

Sl. No. Test Cases
1 Create a sample workflow/Dataflow and validate them
2 Create a datastore and import tables
3 Create a new job in Designer using job server
4 Validate and Execute the new job in the Designer using job server
5 Execute the Job using Data Management Console using job server
6 Add DEV & QA Central repository in the Designer
7 Export the objects to Central repository(Check out/check in)
8 Import the objects from Central reposity(get latest version)
9 Export the objects to ATL files(Backup)
10 Schedule the jobs in Data Management Console
11 Add the users to data management console and check the login access
12 Enable and start the real-time services in data management console
13 Check the configuration of data management console which should replicate the old DM Console
14 Restart Job/Access Servers through Data Service Server manager
15 Creation of local repository using  Data Services Repository Manager
To report this post you need to login first.

4 Comments

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

  1. samia el yousfi

    Hello, could someone help me? I get this error message when I try to run the job server.

    Thanks for feedback

    —————————
    SAP BusinessObjects Data Services Designer
    —————————
    ERROR: Could not execute the job. Error returned was 1. Message is: Cannot execute job ’12_05_2016_23_38_46_3__ce2f784b_0aca_4373_8a36_d6fdc28a8cf2′. Create Process fails for x:/bin/al_engine.exe -PLocaleUTF16 -C”C:\Program Files (x86)\Business Objects\BusinessObjects Data Services/log/JS01/xe__system/command_12_05_2016_23_38_46_3__ce2f784b_0aca_4373_8a36_d6fdc28a8cf2.txt”Le fichier sp�cifi� est introuvable.
    —————————
    OK
    —————————

    (0) 

Leave a Reply