What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Creation of Local Repository as PDF --


1. To create a DI Oracle local repository, first of all we need to log logon to oracle sys account

Connect SYS/SYS AS SYSDBA

2. Now we have to create a user

CREATE USER BODI_REPO IDENTIFIED BY BODI_REPO

DEFAULT TABLESPACE USERS

QUOTA UNLIMITED ON USERS;

3. Now we have to provide some privileges to that user

GRANT CONNECT, RESOURCE TO BODI_REPO;

4. Now create a repository using repository manager

Start–> Programs–> BusinessObjects DataIntegrator–> Repository Manager

5. Specify the Database connection name

6. Give username and password as BODI_REPO and click on Local

7. Select the option Show Details and click on Create button

di_local_repo

8. Creation of Local repository has been completed successfully

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

4 comments on “Creation of Local Repository

    • Dear Amandeep,

      You can follow almost same steps I mentioned above, only thing you need to do is, select your database type(as SQL Server) in repo manager, provider your server name and SQL server user credentials. Before that you need to create a database in SQL server with appropriate user roles.

      Cheers,
      Sudheer

  1. Hi Sudheer

    I am unable to create the local repos. Please review the error I am getting
    “Unsupported Database Type specified as repository.
    Valid types are DB2, Informix, Microsoft_SQL_Server, MySQL, Oracle, and Sybase.
    Please make sure database type matches in spelling to the supported types.”

    I am using Oracle DB and its spelled correctly 😉 not sure why its throwing this error. Could any body help?

    Thanks in advance.

    Regards
    Mani

Leave a Reply to Mani Cancel reply

Your email address will not be published. Required fields are marked *


*