Creation of Local Repository
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
8. Creation of Local repository has been completed successfully
How to create a local repository in MS SQL 2005?
Regards,
Amandeep
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
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
Hi Mani,
Send the error & repo creation screen shots to godasudheer@dwhnotes.com.
Cheers,
Sudheer