Friday, April 20, 2012

OBIEE 11116 repository on MS-SQL I

We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.

1. Create a repository database:

We called ours “Repositories” Winking smile

image

2. Enable case-sensitive collation

ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS

3. Enable Row versioning

ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON

 

4. Allow TCP/IP access to the database:

image

(Bounce the service if you changed it!)

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

5. Create a user (fi: REP_OWN)

image

6. make  the default database repositories:

image

7. Set the public and sysadmin role:

image

Now we can start with the actual repository:

8. Download and unzip de RCU.

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

10. On the database connection details page:

image

11. Select the BI components:

image

12. Enter the passwords

image

13. Succes:

image

image

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

image

Till Next Time

No comments: