It's all about the answers!

Ask a question

Multiple Data Warehouses in Insight 1.0.1.1


Nataliya Kisina (862115) | asked Mar 20 '12, 11:48 a.m.
Is there a way to have multiple data warehouses for Insight?
The customer is planning to ETL about 100 CLM projects and I wonder if it would be better to break those into separate databases?
Does anyone have any suggestions/experiences with ETLing that much data?
Thank you,

Nataliya

3 answers



permanent link
Jackie Albert (1.6k14947) | answered Mar 20 '12, 8:16 p.m.
We have 190 CLM projects in a single data warehouse, and although it took a long time to get the initial data loaded, we haven't had any problems otherwise.

permanent link
Nataliya Kisina (862115) | answered Mar 21 '12, 9:03 a.m.
If you don't mind me asking what are your specs for both database and report servers? are you running windows or linux?

permanent link
Jackie Albert (1.6k14947) | answered Mar 21 '12, 12:07 p.m.
We're primarily running Linux. I'll pull together our system specs, including size of our RTC and RQM projects and send them along to you.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.