It's all about the answers!

Ask a question

Is it possible to install RRDI with shared JTS and multiple DW?


Charlotte Harris (32811) | asked Sep 23 '13, 7:51 a.m.
retagged Sep 26 '13, 2:09 p.m. by Lisa Caten (342913)
Hi

I have the following CLM setup:

Server 1 - JTS with RTC and DW
Server 2 - RTC and a DW
Server 3 - QM and a DW
Server 2 and 3 share server 1 JTS.

I've installed RRDI for server 1, all working fine. However RRDI for server 2 doesn't connect to the DW. I'm thinking RRDI only supports 1 DW, hence the problems I'm seeing? Is Insight my best option?

Many thanks



 

One answer



permanent link
Krzysztof Ka┼║mierczyk (7.4k34694) | answered Sep 23 '13, 8:18 a.m.
Hi Charlotte,
You should use only one DW for all applications in given server, not separate one for each application.
So you architecture should be e.g.  following:

Server 1 - JTS with RTC and DW database
Server 2 - RTC
Server 3 - QM
Server 2 and 3 share server 1 JTS.

Let us know if it helps you.

Comments
Krzysztof Ka┼║mierczyk commented Sep 23 '13, 8:42 a.m.

Hi Charllotte,
You should follow further conversation here: https://jazz.net/forum/questions/128010/merging-data-warehouse-databases

Your answer


Register or to post your answer.