+ Start a Discussion
russkarprusskarp 

Cognos Integration

Hi Everyone,

Does anyone have experience integrating Cognos with SFDC?  I am looking to initiate a Cognos report from SFDC which will contain both SFDC and external data.  I also need to keep SFDC sharing rules intact.

Thanks in advance.
Ashish_SFDCAshish_SFDC
Hi , 


There's an integration for Cognos 8 BI on the AppExchange. 

http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016YGYEA2

Also see the links below, 

http://www-01.ibm.com/software/analytics/cognos/solutions/salesforce/

http://www-01.ibm.com/support/docview.wss?uid=swg21614133

http://blogs.datadirect.com/2011/08/salesforce-integration-cognos-business-intelligence-odbc.html


Regards,
Ashish
russkarprusskarp
Ashish, thanks for pointing those out.  I have looked a the options there but was looking for confirmation whether my scenario will work.  To simplify, I have a single Cognos report that is initiated in SFDC and has both SFDC/other source data.  Will SFDC security be enforced based on the user who is running the report?

Thanks,
Russell
Ashish_SFDCAshish_SFDC
Hi Russell, 


Is the data model similar for both the Objects in Salesforce and the External System?

We can configure a Call Out from Salesforce to the External System and Fetch the required list may be in a Vifualforce page. 

So if it is a Webservice it is defaulted to the System mode sharing which means users who can call will see all the records. 

We can change the sharing to without sharing which will limit them to see only that data which they have access to. 


Regards,
Ashish
russkarprusskarp
Ashish,

The schemas will be identical between Salesforce and the external system.  That is an interesting option and sounds like it will work.  Do you foresee any issues with performance in this scenarios?

Thanks again,
Russell
Ashish_SFDCAshish_SFDC
Hi Russell, 


Performance depends on lot of things, If you keep a limited list and apply selective query that query subset of records rather than all Records then we can get better performance. 

See the best practices doc for Visualforce performances, 

http://www.salesforce.com/us/developer/docs/pages/Content/pages_best_practices_performance.htm


Regards,
Ashish
russkarprusskarp
Thanks again.  I will take a look.
PC2012PC2012
Hi Ashish,

Did you get the answer? I have similar requirement where in Salesforce is just a launch pad for Cognos reports. and I was thinking of configuring custom UTLs with parameters to pull reports from SFDC, is this possible?

Regards.