It's all about the answers!

Ask a question

How do I set up the data warehouse?


Barry von Tobel (1727) | asked Apr 15 '16, 12:02 p.m.
I'm installing CLM version 6.01 and have created all the databases in MS SQL Server.  however when I go to configure the data warehouse, I get pretty confused.  It defaults to Derby, but if I click on SQL Server, the example shows the 'jazz' database which doesn't exist, and there are values like 'table set' that the directions don't give me guidance on.  Or should I keep the default Derby installation?

One answer



permanent link
Donald Nong (14.5k614) | answered Apr 18 '16, 12:28 a.m.
The setup wizard will not know what database you have created, so it should not matter what it shows by default. Have you checked the official documents?
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_wizard.html
(Step 9)

Comments
Barry von Tobel commented Apr 19 '16, 9:27 a.m.

Donald,
yes, I followed the official documents, but still don't know what SQL database to use.  the example on the setup pages suggest using the database 'jazz'.  But the setup (above links) didn't configure a 'jazz' database.  Maybe its the 'dcc' one?

Refer to sentence 5b on this link.  http://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.1/com.ibm.jazz.install.doc/topics/t_ugrade_configure_dw_late.html?cp=SSYMRC_6.0.1&lang=en
where do I find these values for MS SQL Server?


Donald Nong commented Apr 20 '16, 9:05 p.m.

If you refer to the first link in my answer above, that will be the "dw" database. Note that the page does not "suggest" any values, and it should be taken as a placeholder only.

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.