For a BODS developer creating a repository should be the first step because before having one repository for yourself you cannot actually login to designer and start working on jobs. So in this tutorial we will see how to create BODS repository using Data Services Repository Manager. Creating and making the repository accessible will include a couple of steps listed below.
- Create a BODS Repository Using Repository Manager
- Configuring Repository in CMC
- Adding Repository to Job Server
Creating a BODS Repository using Repository Manager
We have read about different types of repository in BODS in the article : Understanding SAP BODS.
In this post we will create a local repository.
Step 1 : Navigate to Data Services Repository Manager
It is usually available at Start > SAP Data Services 4.2 > Data Services Repository Manager
As stated in the article Understanding SAP BODS repository is nothing but database table which holds user created and system defined objects, so while setting up a repository we need to decide which database we are going to use for it and hence the next step is to provide the database details to repository manager.
Step 2 : Choose repository type and Input database details
In this article we will use MS SQL Server as the underlying database for our repository. Make sure you have a dedicated database for repository so that you don’t mishandle it which might corrupt your repository.
once you have inserted all the database details click on “Create“, and the box at the bottom will start showing some logs, and once it is done it should appear something like below screenshot.
Configuring Repository in CMC
Once the repository is created via Repository Manager our next task is to configure it in Central Management Concole (CMC). To do this we will again have some set of steps.
Step 1 : Login to CMC portal and navigate to Data Services
Once you are logged in to CMC portal you can navigate to Data Services using the top left drop down or the link at the bottom of the page.
Step 2 : Click on Configure Repository
Step 3 : Provide all the database details
Make sure you use the same DB name used earlier while creating a repository from Repository Manager.
Step 4 : Test Connection and Save
If the details provided are all correct the below popup should appear.
Once the connection is saved you can view your repository in the list.
Now the repository is configured in CMC and will be available in the list while the user logins the designer.
The repository can be used now to create datastore and jobs, but you will not be able to execute these jobs because the repository is still not added to job server.
Adding Repository to Job Server
Job Servers are usually maintained by the admin team and you might not have access to it, but I will give you an overview of how it is done.
Step 1 : Navigate to Server Manager Tool for Data Services
Step 2 : Under the Job Server tab choose Configuration Editor
Here you can add new job server or view any job server and add repository to it.
Once you see the Job Server details you can add your repository to it by providing the details.
Once it is done you can see the job server related to it on the bottom.
So this was all which is required to make your repository up and running.
Now the repository is all ready and we can move ahead in creating jobs now.