BLOBs/CLOBs in Cognos

[Kanag]

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

[Kanag]

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

Regards,
KR

[blom0344]

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

[Kanag]

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