Print Page - BLOBs/CLOBs in Cognos

Title: BLOBs/CLOBs in Cognos
Post by: Kanag on 27 May 2011 01:17:29 AM

Hi Guys,
We have word,excel files stored as CLOBs/BLOBs in Oracle database..,

Is there any way , I can pull those files from DB to Cognos reports??

Any help on this is much appreciated!

Regards,
KR

Title: Re: BLOBs/CLOBs in Cognos
Post by: Kanag on 30 May 2011 12:16:18 AM

Hi Guys,
Any help on this is much appreciated! Thanks!

Regards,
KR

Title: Re: BLOBs/CLOBs in Cognos
Post by: blom0344 on 30 May 2011 10:55:16 AM

Don't think so. My 2 cents would be to store the Office files on the server as files and use the database to store the link. That way you can create a report containing links to the various office files

Title: Re: BLOBs/CLOBs in Cognos
Post by: Kanag on 31 May 2011 12:42:58 AM

Hi blom0344,
Thanks a lot for the reply!

I am going in ur way and came up with few steps to do the same. Would appreciate if u can validate and let me know..,

STEPS:

* Extracting the files ( in my case, MS Word,Excel files) from DB which are stored as BLOBs and CLOBs

* Storing those extracted files in a Microsoft Sharepoint

* Sharepoint link would be a column in a DB table

* Import the table in FM and pull the column in to the report and make it as a HYPERLINK

* Whenever the Hyperlink is clicked, it would be routed to the Sharepoint portal

Hope above steps would work :)

Regards,
KR

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kanag on 27 May 2011 01:17:29 AM