Central Repository in BODS

This post talks about how to set up a central repository using the repository manager.

Below are the main steps involved:

  • Create a DB in the SQL server
  • Create a Central Repository Using the Repository Manager
  • Login to designer and Add the Central repository
  • Upload a job from local repository to the central repository
  1. Login to the SQL and create a local repository and a database “DB_CENTRAL”

See the below screenshots

b1.png

 

Click on ok and the database will be created. You can see it on the left of the screen.

b2.png

2. Create a central repository

Go to repository manager, give credentials and create a central type of repository

b3.png

3. Add the central repository to the designer

Login to the Data services designer and login using the local repository credentials.

Once you are in the designer, from menu bar “tools” select Central repositories.

b4.png

Click on add on the right side after selecting the Central repository connections  on the left side

b5.png

Give the central repository credentials and click on ok.

You will find the central repository added to the repository connections.

Select the repository and click on Activate.

Now your Central repository is active and it is ready for you to add your contents from the local object library to the central.

Before you add your contents, you can add the below artifacts of Data services to the central repository-

  1. Jobs
  2. Work flows
  3. Data flows
  4. Data stores and Functions

Go to the local repository, select a job and add it to the central repository

b6.png

Select “Objects and dependents” to add the job and all the components of the jobs to the central repository.

You can also add the data flows, work flows and the data stores to the central repository.

Once you select objects and dependents the below screen will come

object and dependents

Give the comments and click on apply to all.

You will get the message saying that your job is added. Go to central repository and check the job and its components.

You will find central repository button active on the screen. Click on the Central object library-

central repo library

 

Go through the tabs work flow, data flow and data store to check if your components are added.

Central object library supports multiple user instance

We will demonstrate to show that central repository supports multiple user login.

Main steps involved-

  • Add the central repository to the management console
  • Add the user Group and users
  • Login to the designer with the new user name
  • Get the job from the central repo.

Step 1: Adding the central repository to management console-

To add a central repository to the management console, the repository should be secure.

Go the repository manager & give the same central repository credentials.

Check the get version button- it will show it’s non secure, check the “Enable security” check box and click on “upgrade”.

b7.png

Now your central repo is upgrade with the security, go to management console and add the central repository.

Login to management console using the user id and password for Administrator.

Click on Administrator.

Select the repositories under the management and click to add on the right side.

Give the credentials and click on “Test” to check the connection.

Click on apply. Now you can find the Central repository active on the left side and expand it to see Users and Groups and reports under it.

Click on the users and groups and click on add on the right side to add a group “ Central Administrator”

Give the name “ Central Admin” and click on apply. Similarly add the group ‘Developers’.

Click on ‘Users’ tab and then click on ‘ADD’.

Select Central admin or Developers as the user group-

Click on apply. Similarly create another User and add it to the developers group or to both the groups and click on apply.

All the users of one particular group will get the roles assigned to it.

Now go back to the designer.

Tools- central repository, Select the central repository and de activate it. Click on edit.

Click on secure and click on the read security key and select the key generated when you applied security to the central repository (You can identify with the DB name)

Give the user name and password which you created when you created users in the management console.

Click on ok and activate the repository again.

Now you assigned security to the central repository and assigned a new user and user groups too.

Go back to the central object library and you can’t find any jobs there.

Add a job.

Right click on the job and add to the central repository with objects and dependents and click on give a comment and apply to all.

You can see ‘FULL’ permission next to the job.

Click on the drop down next to the central admin and select developers group, you can see the change in the permission-

You can check out to lock the job or components of the job so that even if anyone adds the same job to the central repository it will not be over written. Once the final version is done you can again check in. To check in and checkout you can right click on the job or components in the central repository.

Also when you add the job in to the central repository you can go with filtering.

Right click the job in the local object repo – add to central repo- with filters.

This will give you the destination status and action to be taken when you upload the job to the central repository. You can exclude creation using the target status button.

You can also compare the job in the local repository to the central repository and vice versa to check if both are in different versions or any changes done in the job.

This concludes the central repository, administration and check in and checkouts.