You need to sign in to do that
Don't have an account?
russkarp
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.
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.
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
Thanks,
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
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
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
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.