RRDI 2.0 Preparation Step Question

Yenthao Pham (18●4●8) | asked Jul 26 '12, 8:40 p.m.
retagged Sep 28 '12, 9:33 a.m. by Kelly Raposo (46●3)

I'm preparing to add RRDI 2.0 to an existing RTC 4.0 system.

The existing RTC 4.0 System has a server for the 4 applications (JTS, CM, QM, RM) - They are deployed in 4 separate WAS profiles.

The RTC 4.0 System has a separate SQL svr that hold the 4 Jazz dbd, jtsdb, cmdb, qmdb and jtsdw.

I plan to put RRDI report server on a separe Windows 2008 R2 server. However, I use the existing SQL svr to put the RICM (RRDI content store) on it. So far things make sense. However, I don't quite understand what to do with "Creating a reporting user account for the data warehouse connection" (link below). Is the objective to create a user exactly as specified, i.e. RPTUSER, under the windows 2008 SQL svr machine, and then a SQL Server User RPTUSER with SQL Server authentication who is granted read permission to the jtsdw? Is there a separate RRDI DW (RIDW) that I missed? Why can't I use the user that I created for jtsdw?

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.rational.rrdi.admin.doc%2Ftopics%2Ft_configure_datasource_conn_dw.html

PS: I don't understand the namespace under SQL Server with Windows authentication either.

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

ankur sharma (662●1●22●28) | answered Jul 27 '12, 2:09 a.m.
JAZZ DEVELOPER

That link mentions for the DB2 where the database does not have separate user registry and instead uses OS users for access control. For SQL Server, you need only to create the DB user with SQL server.

RRDI needs a separate content store db (RIDW schema will be created in RICM db )
see (http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.rational.rrdi.admin.doc/topics/t_create_content_store_sql.html)

You can use the same user to create rrdi db that was used to create jts db. RPTUSER, on other hand, is used to run the report queries and thus you may not want it to have DBA privileges.

Comments

Yenthao Pham commented Jul 27 '12, 9:28 a.m.

Hi Ankur, You said: RRDI needs a separate content store db (RIDW schema will be created in RICM db ) see (http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.rational.rrdi.admin.doc/topics/t_create_content_store_sql.html)

The step in the link above did not tell me to create the RIDW schema. Step 4 c,d specify to create a schema, but I think it is not RIDW. Can you clarify? So I need to create a SQL login account for the RPTUSER, who has read access only to the jtsdw db, right? Will this RPTUSER account be used later when I set up RRDI? Thanks!

It's all about the answers!

Related questions

RRDI 2.0 Preparation Step Question

One answer

Your answer