Our work project requires the use of Cognos as a reporting tool against a number of extensive Notes/Domino databases. Currently we are required to ensure that reporting is not run until the target Notes data is extracted from Domino onto a MS SQL Server. We would like to eliminate the intermediate step by direct accessing the data where it is in place on the Domino server. Is there a way to do this with third party tools?
OpherB 270003XT4A664 Posts
Re: Cognos :: Notes/Domino Integration2013-09-18T18:18:36ZThis is the accepted answer. This is the accepted answer.
I'm not sure you understand the issue here. Note/Domino is not a record-based SQL relational database. How would you expect a record-based SQL reporting tool (which Cognos BI is) to query a foreign envirnment? Sure there are ODBC drivers, but they don't convert the data into an appropriate structure.
IF there were "third party tools" which would make this available on-the-fly, they would result in such poor performance I doubt anyone would actually use them in a production environment.
If you have a solution which extracts to SQL Server, I suggest you stick with it. There may be ways to optimize it so it runs faster, but that is your best approach in the long run.
Mark Leusink 10000054931 Post
Re: Cognos :: Notes/Domino Integration2013-09-27T11:25:57ZThis is the accepted answer. This is the accepted answer.
Haven't tried it yet myself, but I'm having the same requirement as you, so I probably will shortly :-)
Since Cognos can also connect using JDBC, using the JDBC for Domino project from OpenNTF might also be a solution.
MarkUpdated on 2013-09-27T11:52:20Z at 2013-09-27T11:52:20Z by Mark Leusink