cognos-analytics-2

Blog: Email Cognos Reports using Gmail SMTP Server

This blog explains how easy it is to set-up your Gmail account to send out reports to your Cognos users!

*Note: This can only be done with Cognos versions 10.2.2 or higher.

 

  • The first thing you will need is a Gmail Account
  • Log into Google using a Gmail account that you would like to use to send reports to users or simply create a new Gmail account.
  • Make sure that you choose an email address that you will want the recipients of the Cognos to see (i.e. the reports will be sent by this email address. Example: [email protected]

Once the Gmail account exist you will need to “allow less secure apps” on your Google account (Cognos is seen by Google as a less secure app).  To do this you will need to do the following steps:

  • Go to My Account
  • Go to “Sign-in & Security”
  • At the left hand pane go to “Connected apps & sites”
  • Turn “ON” – “Allow less secure apps”

Next you will need to set up the Cognos Connection to the Gmail mail server:

  • To test that the mail server connection is successful you can right click “Notification” and click test.
  • Enter the following values for Notification Properties
    • SMTP mail Server: smtp.gmail.com:465
    • Account and password: Input the Gmail email address and password
    • Default Sender: Gmail email address you have set up.
    • SSL Encryption Enabled: True
  • Open the Cognos Configuration application and click “Notification”
  • Once the mail server tests successfully you will need to save the Cognos Configuration and restart the Cognos Service

cognos-reports

And that’s it! You will now be able to send reports from Cognos via email.

Be aware that google has sending limits for these mail servers. You can find more information about the limits and the SMTP servers in the following links:

Gmail SMTP options:

https://support.google.com/a/answer/176600?hl=en

Gmail sending limits:

https://support.google.com/a/answer/166852

I hope you find this Blog post informative and help you to open up more options to share your Cognos Reports!

 James Bingham a Business Analytics Consutlant @ ProStrategy 

 Contact ProStrategy @ 01-4291977

Email UsEmail Us
Call UsCall Us
RequestRequest Contact
X