RRDI 2.0 Preparation Step Question
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?
PS: I don't understand the namespace under SQL Server with Windows authentication either.
One answer
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
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!