OK so here are the answers to your reply.  I am really not sure where the connection is broken, but I don't see any errors indicating anything is wrong.  It's just not pulling data into RRDI.  I have run through all the configuration during setup and everything validated successfully and seems to have created all DB's and connections to the different jazz servers seemed to validate successfully so I'm not sure where the disconnect is.  I think it might be best to open a PMR to get some assistance.  Thank you for your reply.
Brian

1) Does the data collection jobs run successfully in CLM?
See the admin page of JTS/CCM and QM > Reports > Data Collection Job Status
This is how the data warehouse is populated.
--Yes they seem to be running successfully

2) Does the user that is logged into RRDI have access to project areas in CLM?
This if you are using the data model with security
--Yes, there are 2 people that have access, myself and another team member, both have access to the project area and RRDI.

You can also check if there is data in the data warehouse, for example by checking tables like RIODS.REQUEST contains data (this should contain reference to RTC workitems for example).
--There is no data in the RIODS.REQUEST table

Thanks Francesco,  after following your last reply I checked and the CLM has a DW db and RRDI is using a local RIDW db, so I have 2 DW db's.  So I guess I need to now change RRDI to point to the actual DW db on the CLM server correct?  Can you point me to directions to do so or do I just need to go through the configuration setup again and change it, re-validate it?

Brian

OK so I followed your link and went through the Configuring the server to connect to the operational data warehouse.  It seems pretty simple filling in the new connection string, I enter the user and password and test, but  it fails wit the below error.  My database person has validated the user-name and password connects localy on the db server in being used.

QE-DEF-0285 The logon failed.
QE-DEF-0321 The userID or password is either missing or invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0129 Invalid login information was detected by the underlying database.
[IBM][CLI Driver] SQL1013N  The database alias name or database name "xxx_DW" could not be found.  SQLSTATE=42705

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(776): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(500): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2028): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

I currently have DB2 installed locally on the RRDI server.  Currently RRID points to the local RICM and RIDW db's.  I need to point the RRDI to a DW db on another server.  The DB2 server that back-ends the jts/clm/rqm servers.  I have all the connection info to connect to the db, host name:port, db name and user name and password are setup with read access.  We are able to connect to the DB locally.