Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
By continuing you indicate that you agree to Terms of Service and Privacy Policy of the site.
SAP Data Services

How to install SAP BODS - Standalone

Updated on Oct 01, 2020

This article is a step by step guide on how to install and configure standalone SAP BODS Batch Job Server, Client Components, Web based Administrative Console.

SAP BusinessObjects Data Services Setup Guide

Follow the instructions below on how to setup SAP BusinessObjects Data Services:

  • After having the licensed version of SAP BODS XI, Click the installation icon "setup.exe" to launch installer.
BODS Setup
BODS Setup
  • Click Next
  • Check the option "I accept the License Agreement" and Click the Next button.
BODS License Agreement
BODS License Agreement
  • Click on the Next button and provide the license information as provided by SAP.
BODS License User Information
BODS License User Information
  1. Full Name: XYZ.
  2. Organisation: XYZ CORP.
  3. Product Key: SAP Provided License Information.
  • Click Next button to continue.
  • Change the software installation directory to D:\Business Objects\BusinessObjects Data Services\

    You can install in any local directory of your choice and also on SAN drive.
BODS Installation Directory
BODS Installation Directory
  • Click the Next button.
  • Select the features to install.
BODS Components
BODS Components

By default the server, client and web components are selected.

Real time services i.e. Message Client Components are not available in this license copy.

  • Click the Next button to continue.
BODS Local Repository Setup
BODS Local Repository Setup
  • Select the option Use an existing database server.
  • Click the Next button to continue.
  • Provide the pre configured database connection information. (MSSQL Server in this case)
BODS Local Repository Connection Information
BODS Local Repository Connection Information
  1. Database Type: Microsoft SQL Server
  2. Database Server Name: EDWDEVETL
  3. Database Name: DEVETLREPO
  4. User name: DEVETLREPO
  5. Password:
  • Click on the button Get Version to check whether the service can connect to database.
BODS Local Repository Connection Check
BODS Local Repository Connection Check
  • Click the Ok button.
  • Next check the Create option and click the Next button to continue.

This will create local metadata repository of SAP BODS.

  • Click the Next button to configure the Job Server.
BODS Job Server Configuration
BODS Job Server Configuration
  • Check the option - Configure a new Job Server
  1. Job Server name: JS_DEVETLREPO
  2. Job Server port: 3500
  • Next click on the Advanced button, to change Cache Directory for this job server.
BODS Job Server Cache Directory
BODS Job Server Cache Directory
  • Change the Cache folder as D:\Business Objects\CacheDir
  • Leave the ports as default. Click the OK button.
  • Click the Next button to continue with the Service Login Information.
BODS Service Login Information
BODS Service Login Information
  • Check the option Use system account and click the Next button to continue.

BODS services namely BOE120TomcatDI_JOBSERVICE and will be created under this system account.

  • Click Next to Continue.
BODS Access Server for Real Time Jobs
BODS Access Server for Real Time Jobs
  • Next check the option Skip Access Server Configuration and click the Next button to continue. Since we are not using Real Time Data Services we skip this configuration step.
  • Click Next to install the web application server.
BODS Web Application Server
BODS Web Application Server
  • Check the option Install Tomcat application server and click the Next button to continue.
BODS WAS Tomcat Configuration
BODS WAS Tomcat Configuration
  • Leave the ports as default and click the Next button to continue installation.

This tomcat web application server will host the Data Services web based management console.

  • Click Next to finalize the installation. The list of programs and services to be installed are displayed.
BODS Install Confirmation
BODS Install Confirmation
BODS Install Finalisation
BODS Install Finalisation
  • Click the Next button to start the SAP BODS installation.

After successful installation of SAP Business Objects Data Services reboot to reflect configuration changes.

BODS Install Success
BODS Install Success
  • Click Finish to exit installation.
  • Next Restart the System to configure BODS installation.
BODS After Install Restart
BODS After Install Restart"
  • 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.
BODS Programs
BODS Programs

In this part of the article, we will see how to change the default Log file directory of SAP BODS, Create Local, Central (Secured version control for multi-user environment) and Profiler (Data profile) repositories, Configure Job Server, Configuring DS Management Console, Add/Remove license information and Configuring SAP BODS Metadata Integrator with SAP BOXI.

BODS Directory Structure

BODS automatically creates an environment variable, called LINK_DIR which points to the root folder where BODS is installed. In our case, this root folder is:

LINK_DIR="D:\Business Objects\BusinessObjects Data Services"

For the sake of future conveniences and logical grouping, we may also create the following directory structure for SAP BODS.

Custom Directory Structure for BODS

Cache: "D:\Business Objects\CacheDir"
Log: "D:\Business Objects\LogDir"
Scripts: "D:\Business Objects\ParamDir"
Target Files: "D:\Business Objects\TgtFiles"
Source Files: "D:\Business Objects\SrcFiles"

Separating the directories in the above fashion, makes it easy for us to quickly access them later.

We need to create the folders in windows and use them for the purpose defined above. For example to point the source or target file to proper directory either enter the directory path in the Root directory option of the File Format or you can also use Substitution Parameters for each environment.

Changing default location of BODS Log Directory

For BODS Log files, the default log directory is :

D:\Business Objects\BusinessObjects Data Services\log

But you may change the default log directory location to some other folder, eg. the below folder for quicker access:

D:\Business Objects\LogDir

In order to do this, Open the file DSConfig.txt in the location:

D:\Business Objects\BusinessObjects Data Services\bin\DSConfig.txt
DSConfig
DSConfig

Modify the line

AL_JobServerLogDirectory1=

As below

AL_JobServerLogDirectory1=log
AL_JobServerLogReDir1=D:\Business Objects\LogDir
DSConfig Modified
DSConfig Modified

Next Restart the BODS Job Server or BODS Services and you are done.

Create SAP BODS Local Repository

Businessobjects Data Services(SAP BODS) solutions are built over 2 different types of meta-data repositories called central and local repository. While the local repositories can be used by the individual ETL developers to store the metadata pertaining to their ETL codes, the central repository is used to "check in" the individual work and maintain a single version of truth for the configuration items (e.g. ETL code). Without the necessity of installation of the additional modules, it supports the team work in the ETL projects. The central repository allows adding tested scripts and then import them to local repositories or check them out and open them in exclusion mode. Versioning is also fully supported. 

Go to SAP BODS Repository Manager and enter the following information to configure the Local Repository:

  1. Repository type: Local
  2. Database type: Oracle (or whatever database you are using)
  3. Database connection name: ORCL
  4. User name: DEVETLREPO_L1
  5. Password: (specify password here)
Local Repository Connection Test
Local Repository Connection Test

Click on Get Version button, first to check it is able to connect to database.

Next Click on Create button to create the metadata tables.

Local Repository Creation
Local Repository Creation

Local Repository was successfully created.

How to Create SAP BODS Secured Central Repository

As discussed in the previous page, Businessobjects Data Services (SAP BODS) solutions are built based on a central repository which is independent from the local repositories of the ETL developers. The central repository, among other things, supports the team work in the ETL projects. Versioning is also supported. Here is how to configure the central repository.

Go to SAP BODS Repository Manager and enter the following information to configure the metadata of the Central Repository:

  1. Repository type: Central
  2. Check Enable Security
  3. Database type: Oracle (or whatever database you are using)
  4. Database server name: EDWDEVETL
  5. Database connection name: ORCL
  6. User name: DEVETLREPO_CENTRAL
  7. Password: (specify password here)
Central Repository Connection Test
Central Repository Connection Test

Click on Get Version button, first to check it is able to connect to database.

Next Click on Create button to create the metadata tables.

Central Repository Security Key
Central Repository Security Key
Central Repository Creation
Central Repository Creation

The above message shows that the Central Repository is successfully created.

Purpose of SAP BODS Central Repository

Central repository is used for the sole purpose of version control check-in and check-out functionality ideal for multi-user development environment. You cannot run the jobs or you cannot configure a job server to point to a central repository.

How to create SAP BODS Profiler Repository

A profiler repository is a special repository that contains the profiling information for the objects. Among other things, this repository stores the column level details including cardinality, max, min and Null values etc. A job server needs to be associated with the profiler repository. Next we will see how to configure a profiler repository. Go to SAP BODS Repository Manager and enter the following information to configure the metadata of the Profiler Repository:

  1. Repository type: Profiler
  2. Check Enable Security
  3. Database type: Oracle
  4. Database server name: EDWDEVETL
  5. Database connection name: ORCL
  6. User name: DEVETLREPO_PROFILER
  7. Password: (your password here)
Profiler Repository Connection Test
Profiler Repository Connection Test

Click on Get Version button, first to check it is able to connect to database.

Next Click on Create button to create the metadata tables.

Profiler Repository Creation
Profiler Repository Creation

Profiler Repository was successfully created.

Purpose of SAP BODS Profiler Repository

Profile repository is used for the sole purpose of performing column level profiling of the DW tables. You must configure or associate a Job Server with the Profiler Repository.

How to Configure Job Server using DS Server Manager

You need to configure a Job server before you are able to execute data services ETL jobs. Job server needs to be configured on some local repository that you have already created. Here we will see how may we configure a BODS job server. Go to SAP BODS Server Manager.

Data Services Server Manager
Data Services Server Manager

Click the button Edit Job Server Config.

Job Server Configuration Editor
Job Server Configuration Editor

Click Add and enter the Name of the Job Server and associate it with the local repository.

  1. Job Server name: JS_DEVETLREPO_PROFILER
  2. Job Server port: 3501

Next click the Add button to associate the repository to the Job Server.

  1. Database type: Oracle
  2. Database connection name: ORCL
  3. Username: DEVETLREPO_PROFILER
  4. Password: (your password here)

Check the option Default repository.

Click Apply.

Job Server Properties
Job Server Properties

Next Click OK.

Job Server Added Successfully
Job Server Added Successfully

Next Click OK.

Job Server Restart
Job Server Restart

Next click Restart Button to restart BODS Services.

Next we will learn how to CONFIGURE SAP BODS MANAGEMENT CONSOLE.

How to Configure SAP BODS Management Console

Click on the Data Services Management Console. Login as admin/admin.

Management Console Login
Management Console Login

You will be greeted with the below screen once you login.

Management Console - Administrator
Management Console - Administrator

Next Click on Administrator to Register the Repositories. Following screen will appear. You may click on the image below to enlarge the same.

Management Console Repositories
Management Console Repositories

On the left hand pane Click on Management list item and then Click on Repositories.

Next Click the Add button to register a repository in management console.

Enter the repository credentials.

  1. Repository name: DEVETLREPO
  2. Database type: Oracle
  3. Machine name: localhost
  4. Database port: 1521
  5. Service name/SID: ORCL
  6. User name: DEVETLREPO
  7. Password: (your password here)

Click Test.

Management Console Add Repository
Management Console Add Repository

Click Apply.

Management Console Local Repository
Management Console Local Repository

Next register the Profiler Repository as above mentioned steps.

Management Console Add Profiler Repository
Management Console Add Profiler Repository
Management Console Profiler Repository
Management Console Profiler Repository

Similiarly add the Central Repository.

Management Console Add Central Repository
Management Console Add Central Repository
Management Console Central Repository
Management Console Central Repository

How to add Central Repository Users and Group in BODS

Go to Administrator, Central Repositories, DEVETLREPO_CENTRAL. Click on Users and Groups.

Management Console Central Repositories
Management Console Central Repositories

Click Add.

Enter Group Name as Grp_Central_Repo.

Central Repository Group Information
Central Repository Group Information

Next Click Apply.

Central Repository Group
Central Repository Group

Next Click on the Users tab.

Central Repository Users
Central Repository Users

Click Add and then Enter the new user credentials.

  1. User name: DEVETLREPO_CENTRAL
  2. Enter Password and confirm password.
  3. Display name: DEVETLREPO_CENTRAL
  4. Default Group: Grp_Central_Repo
  5. Status: Active
  6. Member of: Grp_Central_Repo
Central Repository User Information
Central Repository User Information

Click Apply.

Central Repository User
Central Repository User

Next we will learn how to ADD PROFILER REPOSITORY USER

Go to Management, Users and Click the add button.

Profiler Repository User
Profiler Repository User

Next enter the Repository user credentials:

  1. User name: DEVETLREPO_PROFILER
  2. Enter Password and confirm password.
  3. Display name: DEVETLREPO_PROFILER
  4. Role: Profiler Administrator
  5. Status: Active
  6. Profiler Repository: DEVETLREPO_PROFILER
Profiler Repository User
Profiler Repository User

Now you will be able to connect to the Profiler Repository using this User.

Profiler Repository User Created Successfully
Profiler Repository User Created Successfully

BODS Designer

Login to the Local Repository we created earlier:

BODS Designer Login
BODS Designer Login
  1. Database type: Oracle
  2. Database connection name: ORCL
  3. User name: DEVETLREPO
  4. Password: (your password here)

Click OK, to login to local repository.

BODS Designer
BODS Designer

Next Check the JOB SERVER STATUS.

Look at the bottom right hand corner for job server symbol. On pointing the mouse it will show Job server JS_DEVETLREPO is running.

Designer Job Server running
Designer Job Server running

Next CONNECT TO PROFILER SERVER.

Look at the bottom right hand corner for Profiler Server symbol. On pointing the mouse it will show Profiler Server is not running. Double click the Profiler server, or go to Tools and click Profiler Server Login... to enter the login credentials.

Profiler Server Login
Profiler Server Login
  1. Host: localhost
  2. Port: 28080
  3. User name: DEVETLREPO_PROFILER
  4. Password: (your password here)

Click on Test button.

Profiler Server Running
Profiler Server Running

Next Click on Connect button.

Profiler Server Connected
Profiler Server Connected

Now, on pointing the mouse to the Profiler Server will show the server running and the user connected.

Profiler Server Connected
Profiler Server Connected

Next CONNECT TO CENTRAL REPOSITORY.

Go to Tools and click on Central Repositories...

Central Repository Connections
Central Repository Connections

Next click Add button.

Enter the Login Credentials as follows:

  1. Repository Name: DEVETLREPO_CENTRAL
  2. Check Secure
  3. Database type: Oracle
  4. Database connection name: ORCL
  5. Next click the button Read Security Key
  6. Select the default key in the location, which was generated during Central Repository Creation.
  7. User name: DEVETLREPO_CENTRAL
  8. Password: (your password here)
Central Repository Editor
Central Repository Editor

Note: You can create separate Logins to central repository for individual developers from Management Console and provide the same to the developers who will connect to Check-In and Check-Out Objects.

Next click OK.

Secure Central Repository Configured
Secure Central Repository Configured

Click the Activate button and enter the password again to activate central repository with this current local repository.

Secure Central Repository Activate
Secure Central Repository Activate

Pointing the mouse over the secure central repository will show the details.

Secure Central Repository Details
Secure Central Repository Details

Next CONNECT TO Management Console from Designer.

Click on the Data Services Management Console icon shown above to connect from the designer GUI. Else go to Tools, Data Services Management Console..

Data Services Management Console
Data Services Management Console

Login to Management Console as

  1. User Name: admin
  2. Password: (your password here)

Click Login.

Data Services Management Console Login
Data Services Management Console Login

Next use SAP BODS LICENSE MANAGER to Add new license information using the Add button or to remove existing old license information using Remove button.

Regarding installation and configuration of SAP BODS METADATA INTEGRATOR we will discuss in another topic as this particular component need to be installed in BOXI server machine. So both BOXI and BODS can reside in the same machine or in different machine. But the metadata integrator component should be installed and configured at the BOXI server or precisely where the BOXI CMS resides so that we can take the full advantage of lineage and impact analysis of the target report fields with their counterpart source columns.