Does RRDI have the ETL Catalog database?
Michael Walker (992●15●201●157)
| asked Dec 11 '12, 9:06 p.m.
retagged Dec 13 '12, 9:57 a.m. by Kelly Raposo (46●3)
When following the instructions in the Help documentation for Upgrade Rational Reporting for Development Intelligence 1.0.2 to Rational Insight 1.1 one of the first steps is backing up the data. In addition to backing up the Data Warehouse and Content Store it says to backup the ETL Catalog database.
Is this part of RRDI or only Insight? For RRDI I only see the DW and RICM dbs. When I go through the Insight install it tells you to create the ETL Catalog.
showing 5 of 8
show 3 more comments
|
Accepted answer
Hello Michael,
you are right, the ETL Catalog database is only used by the Insight Data Manager ETL and is not part of RRDI. Michael Walker selected this answer as the correct answer
|
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.
Comments
Michael
can you provide a link to the Help documentation that contains this statement so it may be corrected?
It's in the Rational Insight doc. Looks like a few of the other items it states to backup are Insight only also. It's confusing when you're starting in RRDI and those don't exist.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.migrating.doc%2Ftopics%2Ft_upgrade_rrdi_to_insight.html
Ok. I figured out what the issue is, I think. When I followed the link, I could not find any mention of the ETL Catalog database. In fact, Step #1 says 'Back up your Data Warehouse and Content Store Database data' which is correct and appropriate for the topic of migrating from RRDI to Insight. However, when you follow the link in Step #1 that comes after 'For information about backing up data, see...', then you are directed to a topic that is Insight specific and thus, it is written for Insight not RRDI.
You have to keep that in mind. It happens sometimes.
What's important is that Step #1 did say, accurately, what specific dbs you needed to backup.
Sorry I posted the wrong link. It's migrating from RRDI to Insight 1.1, not the Insight 1.0.1.1 I originally sent.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.migrating.doc%2Ftopics%2Ft_upgrade_rrdi_to_insight.html
I guess the links are the same but the topic is Upgrade Rational Reporting for Development Intelligence 1.0.2 to Rational Insight 1.1
It's under Upgrading with other products to 1.1
Yes, ok.
That topic we could possibly open a doc defect on. But the other one is ok.
I have opened the workitem
Incorrect info provided in step 1 as to which databases to backup (77805)
Rosa,
In the same document step 4L says the following:
"Open a web browser to http://<hostname>:<port>/insight, log in and run some existing reports to verify the installation."
However, the instructions say when installing Insight during a migration to keep the /reporting part of the URL. The above step has only worked for me during a migration when I use /reporting. The above instructions seem more for a fresh install of Insight and not a migration from RRDI.