Publish to a SharePoint List
As a last test we used CoRePublisher to publish data to a SharePoint List. For this purpose we used a different report, also a list report but in XML format, which is required. See picture below. It is sort of an employee expense list.
We also did create an empty list beforehand in SharePoint with columns that match the data/report we want to publish to SharePoint.
Step 1 and 2 are again the same as witch our Folder and SharePoint Directory test, we just selected “SharePoint Lists” and did not include any condition.
The last step was similar to the SharePoint Document Library step. But instead of matching the metadata, we could here match the actual data from the XML report with the SharePoint List columns.
And after finishing the wizard we had again a new publication entry, and moments later the corresponding results in SharePoint.
Final Notes and Conclusions
- We did not perform any stress testing or heavy loads, so we cannot deduct any conclusions on performance.
- At various points in the process enhanced capabilities are possible by adding VBScrips, these were not tested.
- A fully functioning trial version of CoRePublisher can be downloaded from the xplore+ website
- As mentioned on their website, xplore+ will be present at IBM IOD 2013 from November 3th till 7th in Vegas.
- Installation went smooth (potentially we will document this as well).
- The tool does not require changes or installation on source and target systems.
- CoRePublisher is easy and simple to use but has powerful dynamic features using report metadata.
- The parts we tested went without any problem or issue.
- Multiple application areas exist where CoRePublisher can fill a gap.
- Although not tested it is a plus that custom plugins can be written and custom VBScripts can be used.
So all positives then? Well mainly yes, the tool is easy to use, does not require a great deal of training and does not impact other systems. Potential improvements might be an indication of the last publish run in Configurator and an indication of whether a Publication is active or not without having to open the entry. Relatively small things but that would improve user friendliness. The main improvement that we see is that it would be interesting to have this tool for different source systems as well and not only Cognos.
BACK to the beginning (of this post) or back to the review introduction.