Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Importing Remedy Data into Rational Insight?

Questions
Tags
Users
Badges
Jill Davies
(24●14●17) Nov 29 '13, 8:40 a.m.

Hi,

I'm interested in whether it is possible to import data from Remedy into Rational Insight.

Has anyone does this?  Please can you give me some pointers?

Thanks,

Jill

0 votes

Comments
sam detweiler
Nov 29 '13, 9:02 a.m.
what do you mean by import? store in Insight database? yes, that is what Insight supports, outside data, where RRDI does not. you would have to use the Cognos data mgmt tools to build another database, and then your favorite ETL tool to get the data out of Remedy and into the new tables. you 'may' be able to access in place, depending on the location of the database under Remedy. here is a presentation on the Cognos Framework Manager

Jill Davies
Nov 29 '13, 9:11 a.m.
Hi, Yes I do mean store Remedy data in the Insight database. Please could you be a little more specific on what you mean by using "my favourite ETL tool" to get the data out of Remedy? I have previously used the OOTB ETL jobs to get data from the CLM applications, extracted data from ClearQuest, Lotus Notes (using NotesSQL) and from Excel, but I don't particularly have a "favourite" tool ;-) Thanks, Jill

sam detweiler
Nov 29 '13, 9:15 a.m.
some shops like particular tools. We used stuff built on top of Pentho, our IT department used Informatica. I was just saying, its database to database,  so use whatever u are comfortable with. no one particular tool is required. we had Insight setup on top of both DB2 and MS SQL Server.

1 answer
5,526 views
0 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) edited
Nov 29 '13, 9:56 a.m.
Hello Jill,

Insight doesn't support the integration with Remedy, meaning there is no out of the box ETL job that will load the Remedy data in the data warehouse.

Insight however allows customization of the Data Warehouse and Framework Manager Model, since it provides the necessary Cognos tools.
This mean that if Remedy provides its data over REST API or direct DB connection you can create your own ETL process (with Data Manager or another tool) that will load the Remedy data in the data warehouse and modify your Framework Manager Model to include this data in the reports.
This is not a trivial task and requires some advanced Cognos skills to create and maintain.

Best Regards
Francesco
Jill Davies selected this answer as the correct answer

0 votes

Comments
Jill Davies
Nov 29 '13, 10:37 a.m.
thanks Francesco

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,145

Question asked: Nov 29 '13, 8:40 a.m.

Question was seen: 5,526 times

Last updated: Nov 29 '13, 10:37 a.m.

Confirmation Cancel Confirm