SAP BODS Repository Creating & Updating - SAP BODS

What is SAP BODS Repository Creating &Updating?

To create BODS Repository, you want to have a database connected. You can use SQL Server, Oracle database, My SQL, SAP HANA, Sybase, etc.

Creating Repository

You have to create the following users in database while connecting BODS and to create Repositories. These users are essential to login to different servers such as the CMS Server, Audit Server etc.

Create User BODS Identified by Bodsserver1

  • Grant Connect to BODS;
  • Grant Create Session to BODS;
  • Grant DBA to BODS;
  • Grant Create Any Table to BODS;
  • Grant Create Any View to BODS;
  • Grant Drop Any Table to BODS;
  • Grant Drop Any View to BODS;
  • Grant Insert Any table to BODS;
  • Grant Update Any table to BODS;
  • Grant Delete Any table to BODS;
  • Alter USER BODS QUOTA UNLIMITED ON USERS;

Create User CMS Identified by CMSserver1

  • Grant Connect to CMS;
  • Grant Create Session to CMS;
  • Grant DBA to CMS;
  • Grant Create Any Table to CMS;
  • Grant Create Any View to CMS;
  • Grant Drop Any Table to CMS;
  • Grant Drop Any View to CMS;
  • Grant Insert Any table to CMS;
  • Grant Update Any table to CMS;
  • Grant Delete Any table to CMS;
  • Alter USER CMS QUOTA UNLIMITED ON USERS;

Create User CMSAUDIT Identified by CMSAUDITserver1

  • Grant Connect to CMSAUDIT;
  • Grant Create Session to CMSAUDIT;
  • Grant DBA to CMSAUDIT;
  • Grant Create Any Table to CMSAUDIT;
  • Grant Create Any View to CMSAUDIT;
  • Grant Drop Any Table to CMSAUDIT;
  • Grant Drop Any View to CMSAUDIT;
  • Grant Insert Any table to CMSAUDIT;
  • Grant Update Any table to CMSAUDIT;
  • Grant Delete Any table to CMSAUDIT;
  • Alter USER CMSAUDIT QUOTA UNLIMITED ON USERS;

To create a new Repository after installation

Step 1 − Generate a database Local Repo and go to Data Services Repository Manager. Construct database as local repository.

create_new_repository

A new window will open.

Step 2 − Enter the details in the following fields −

Repository type, Database type, Database server name, Port, User name and password.

repository_details

Step 3 − Click the Create button. You will catch the following message –

click_create_button

Step 4 − currently login to Central Management Console CMC in SAP BI Platform with User name and Password.

cmc_login


Step 5 − On the CMC Home page, click Data Services.

cmc_homepage

Step 6
− From the Data Services menu, Click Configure a new Data Services Repository.

data_services_menu

Step 7 − Enter the information as given in the new window.

  • Repository Name: Local Repo
  • Data Base Type: SAP HANA
  • Data Base Server Name: best
  • Database Name: LOCAL_REPO
  • User Name:
  • Password:*****

details_new_window

Step 8 − Click the button Test Connection and if it is successful, click Save. Once you save, it will come under Repository tab in CMC.

Step 9 − Apply access rights and security on local repository in CMC → User and Groups.

Step 10 − Once access is given, go to Data Services Designer → Choice Repository → Arrive User name and password to login.

repository_login

Updating the Repository

To update a repository, follow the given steps.

Step 1 − to update a Repository after installation, form a database Local Repo and go to Data Services Repository Manager.

Step 2 − Configure database as local repository.

configure_database

A new window will open.

Step 3 − Enter the information for the following fields.

Repository type, Database type, Database server name, Port, User name and password.

services_repository_manager

You will see the output as presented in the screenshot displayed below.

sap_bods_output

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BODS Topics