?
Solved

How to connecta  notes databas with Cognos to generate reports?

Posted on 2011-04-21
10
Medium Priority
?
958 Views
Last Modified: 2013-11-16
How to establish a connection between lotus notes database and Cognos Data Modeler in order to generate reports?
0
Comment
Question by:shals0628
  • 5
  • 5
10 Comments
 

Author Comment

by:shals0628
ID: 35441880
@sjef - I have already checked out the above options.  The Utility Plug in cannot be considered as of now. I have the method now, We can successfully establish a connection with notes database and cognos using an valid XML document which can be called via a lotus notes web agent where in the XML document can be used as the Data Source for connecting to Cognos. But I have no clue about what data should go into the XML document. :-(  I found this information from the following link --> http://www.techronnati.com/blog/ibm-db2-notes-cognos/integrating-lotus-notes-data-cognos-8-reports/
Please check and let me know how to begin with the XML document. I have installed Notes SQL, Cognos 8 BI and Lotus Notes 8.5 currently.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35444492
You have to develop a Notes agent using a Designer client. The agent is to produce XML "text". The website you linked to says that you can download an example source code when you register. Tried that?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:shals0628
ID: 35504052
I am unable to register to that site. Moreover, there is a confusion, if I have to create a notes agent to generate XML code or vice versa, an XML code which will extract notes data and act as a data source between notes and cognos.  Please guide.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35504131
Are you familiar with Notes development? And are you allowed to access your Domino server to install NotesSQL there?

Please bear in mind that I know nothing of Cognos, but I'll do my best!
0
 

Author Comment

by:shals0628
ID: 35689059
Notes Development scope so far has been less for me, always only minor enhancements .. yes, we have the access. Cognos my knowledge is also 'Nil'
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 150 total points
ID: 35689415
Oh... We make a nice team... ;-))

The example on the techronnati site starts with some print statements, to indicate that the output is indeed XML. After the header, you have to create code to extract the information you from the database, and print output in XML format.

In Cognos, I suppose you have to describe the agent's output-format.

Would this page be of any help:
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/how-to-create-xml-datasource-2974651
0
 

Author Comment

by:shals0628
ID: 35736797
hmmm.. Still no luck with this activity here.. I have found information that we can connect thru ODBC itself .. But when I create a Framework in Cognos, I cannot see the DSN in the list.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 35739710
I'd better throw in the towel... :(
0
 

Author Closing Comment

by:shals0628
ID: 35976369
The links provided are helpful.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Loops Section Overview
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question