xplore+ CoRePublisher Review: Hands On

Publish to a SharePoint Directory

So let’s try what probably is the best application for this tool, being able to publish reports to SharePoint Directories. We are going to stick to the same sample report.

The first step is the same as with the folder publication process, only now select “SharePoint” instead of “Folder/Share”.

xplore+ CoRePublisher Review Cognos Report Publisher Configurator SharePoint Document Library

Sending a mail is not selected, so we immediately arrive at the condition step. This one is also identical to the folder publication process.

 xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

The last step is different as this one includes the SharePoint parameters.

xplore+ CoRePublisher Review Cognos Report Publisher Configurator SharePoint Document Library

“Username”, “password” and “domain” are the parameter to connect to SharePoint. The user must have the correct rights, if you are going to publish to a location that doesn’t exist yet, the user must be able to create it. “SharePoint Site” is the URI from the SharePoint environment. And “Document Library” is the name of the Document Library you want to write the report(s) to, it is not required that it exists yet, and it can be made dynamic using the report definition fields on the left. 

Now, we did create the Document Library “Cognos Demo” prior to creating this publication. The upside of doing this is that you can use the existing Document Library fields and match and fill them with the Cognos reports’ metadata. Below you can see a screenshot of the Document Library columns created in SharePoint.

xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

By doing so you can use the “Sample” fields to read these columns and match them with the Cognos report metadata. Below you can see the wizard form completed.

 xplore+ CoRePublisher Review Cognos Report Publisher Configurator SharePoint Document Library

When clicking “Finish” we return to the Configurator Publication tab, where we can see that a new entry is added. This entry is picked up automatically.

xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

Just moments later the report was added to the Document Library with the columns filled in.

 xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

Note that from now on this report exists in SharePoint without any connection to CoRePublisher or IBM Cognos, it is now a SharePoint document and can be used as such just as any other SharePoint Document.

We also noticed (same for the Folder/Share example) that in the common directory an XML file is written for each publication entry.

xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

This file includes all info from that publication entry. Note that the password is encrypted.

 xplore+ CoRePublisher Cognos Report Publisher Configurator SharePoint Document Library

We also found ( in *.txt format) that logs are written for each publication action. So as this is all readable, this can be used as a source for reporting as well in Cognos and/or to set up an audit trail for compliancy purposes.

Ok, so that went rather smooth as well.

NEXT: Publish to a SharePoint List and Conclusions

1 2 3 4

Cognos Service