Wednesday, January 30, 2013

[OBIEE 11g] Repository On MS-SQL


 

OBIEE11g repository on MS-SQL



Create a repository database:



 

*Enable case-sensitive collation 

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS


*Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON




*Allow TCP/IP access to the database:





(Bounce the service if you changed it!)


*If you have a firewall running check if the ms-sql port is open (1433 for a default instance)


*Create a user (fi: REP_OWN)






*make  the default database repositories:






*Set the public and sysadmin role:


 



*Now we can start with the actual repository:


*Download and unzip de RCU


*Start the RCU.bat (..\rcuHome\BIN)


*On the database connection details page:







*Select the BI components:








*Enter the passwords







*Success:










*You can disable the REP_OWN account, the RCU has create dedicated logins:






No comments:

Post a Comment