In the first chapter of this article we have learnt the very basic of BODS. In this part of the article we will begin with BODS Repository creation process

Before launching the BODS application and starting actual BODS programming there are three mandatory activities which needs to completed they are –

  1. Repository Creation
  2. JobServer Configuration
  3. Registering Repository with CMC.

Creating a Repository

The first and foremost activity one has to do after installing BODS and database is, creating a local repository. The below mentioned are the step by step process to create it-

1. Log on to your Database (SQL server 2008 Express in this case)

2. Create a new database (Example - DS_LOCAL_TEST in the figure 2.1).This database would be used for Local repository. (This article does not explain how to create database and tables outside BODS.)

Figure 2.1

3. Go to Start menu open SAP BusinessObjects Data Services 4.0 SP1 -> Data Services Repository Manager

4. A screen as shown in the below diagram (Figure 2.2) would popup. Enter the required parameters into the text boxes as stated below -

Figure 2.2

Below are the credentials one would need to fill in the Repository Manager.

Repository type – Local
Database Type – Microsoft SQL Server (in this case)
Database Sever name – This should be the machine/server name where the database is residing. If you have installed database in your local machine the machine name or machine IP has to be provided.
Windows authentication – DONOT check this option .It is always recommended to use password authentication.
User name – The login name of that is used to login to the above mentioned Database residing in the Database server mentioned.
Password - The same password used to login to the above mentioned Database residing in the Database server mentioned for the login id specified.

5. Click on create. The below displayed message could been seen(Figure 2.3), indicating “The local repository was created successfully”. (If you do not get the success message, then, any one of the credentials is incorrect like the database server name or the database name or user id password)

Figure 2.3

6. Close the window

Attaching repository to JobServer

The next step following the creation of repository is attaching the repository to a Jobserver. Only once it is attached to a job server, it can be opened using designer. Below are the steps to associate a repository to Jobserver-

1. Go to Start Menu -> SAP BusinessObjects Data Services 4.0 SP1->Data Services Server Manager. A screen as shown below would be displayed (Figure 2.4)–

Figure 2.4

2. Click on “Configuration Editor” and the screen Figure 2.5 would be displayed.

Figure 2.5

3. Next click on “Add” button and below screen would be displayed (Figure 2.6)

Figure 2.6

4. Click on “Add” button on the “Associated Repositories” label to enable the options in the “Repository Information” label.

5. Enter the credentials as shown in Figure 2.7 and click “OK”.

Figure 2.7

  • Job Server name – Enter any name that you wish to assign for the Jobserver. Example in the above figure JobServer_Test in this case.
  • Job Server port – By default it is 3500.If there occurs any error assigning the port as 3500, then try to increment the value like 3501 or 3502 or higher.
  • Ignore the Check boxes and go to the label “Repository Information”.
  • Database type – Select the database in which you created the repository. Microsoft SQL Server in this case.
  • Database Server name – Name of the machine/server where database resides.
  • Database name – Name of the database which was created for local repository.
  • Username and Password – Same user name and password used to log in to SQL Server database in which the local repository database resides.
  • Leave the “Default repository” check box as is.

6. Click on “Apply” and screen as shown in Figure 2.8 would be displayed.

Figure 2.8

7. The “Associated Repositories” box would be automatically populated with the concerned repository name.

8. Click on OK. Screen as in figure 2.9 can be seen.

Figure 2.9

9. Click on OK and we get a screen as shown in figure 2.10

Figure 2.10

10. Click "Close and Restart” to finish the JobServer configuration for the repository created. This will restart the BODS Engine and dialog box may be popped confirming it would restart the engine.

Please ignore all the other Tabs and buttons for now. Those would be a part of Advanced BODS tutorial

In the next part of the article, we will learn how to register the repository with CMC.

Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • Getting Started SAP BODS

    This article is a step by step guide to learn the basic of SAP BODS. Starting from the Basic we will cover the essential topics like SCD implementation, Fact loading, CDC Mechanisms, Persistent Cache, Substitution Parameters, Variables and...

  • Data Services Metadata Query Part 3

    This article is a continuation of the previous topic related to Data Services Metadata Query. Let us explore more into the Data Services Repository Metadata.

  • How to use Lookup and Join in SAP Data Services

    In this tutorial, we will learn how to perform lookup and join in SAP BusinessObjects data services using the Query Transform. In the way, we will also see how to use some of the basic inbuilt functions that are provided in data services. A short...

  • Why SAP Data Services

    SAP BusinessObjects Data Services delivers a single enterprise-class solution for Data Integration, Data Quality, Data Profiling, and Text Data Processing that allows us to integrate, transform, improve, and deliver trusted data to critical...

  • Data Services Metadata Query Part 1

    Data Services provides full access to the repository metadata tables and views for metadata analysis. To access this metadata either we can use SQL SELECT statements or use the metadata reporting from Management Console.

  • SAP BODS Cluster Installation

    This article is a step by step guide on how to configure SAP BODS for High Availability using Windows Cluster services. To take advantage of fail-over support for SAP BusinessObjects Data Services services in a Windows Clustering Environment,...

  • One Stop to SAP BODI/BODS

    BODI Business Objects Data Integrator or BODS Business Objects Data Services is a GUI workspace that allows to create jobs that extracts data from heterogeneous sources, transforms that data using built-in transforms and functions to meet business...

  • How to use SAP Data Services Case Transform

    In this tutorial, we will learn how to use SAP data services Case Transform. Case transform provide us a means to implement "If... Then... Else" logic in data services. In the end a short video is provided with this tutorial to give you a hands-on...

  • SAP Data Services Analytic Functions

    In this tutorial we will learn how to implement Cumulative Sum in SAP Data Services (BODS). Since there is no available in-built Analytic Functions in SAP Data Services, we will achieve the end result by exploiting some in-built Data Services...

  • SCD implementation from Source based CDC table

    Consider a scenario where we want to capture all or any changes in the source table to be maintained as history in our data warehouse dimension table. So if we consider day end batch load we will miss out any intermediate changes to the master data as...