We would like to pull in data using Lightning Connect and create reports in Salesforce on that data. Is this possible and what problems/challenges should we expect?
3 Answers
For those who don't follow this space closely, reporting against External Objects has been introduced with Winter '17. Check out the Release Notes for more information.
Note that there are numerous restrictions in terms of the number of records that can be returned from the External Object(s), Child/Parent relationships, etc.
Update
Reporting against External Objects has been introduced with Winter '17. Check out the Release Notes for more information.
Currently the lightning connect dont support reports .I got the information from below document
https://help.salesforce.com/HTViewHelpDoc?id=platform_connect_considerations_compatibility.htm
-
2
Look into qlikview. We recently implemented this tool and it's amazing. We have even integrated it to Salesforce by making the URL that the reporting/dashboards a web tab.