+ Start a Discussion
Bayarea 101Bayarea 101 

SSRS integration with Salesforce

we are trying to integrate SSRS into salesforce. Data will be available at SSRS and salesofrce user will be accessing these reports. Is there any way we can achieve it.
Does SSRs have slaesforce Api integrator build in it?
NagaNaga (Salesforce Developers) 
Hi Bayarea,


1.) SOAP API :- You need to make Apex callout from button/Trigger which would call the external DB and return you response.Go through the below link to learn more with sample examples :-

https://developer.salesforce.com/page/Apex_Web_Services_and_Callouts

https://developer.salesforce.com/page/Apex_Callouts

2.) REST API :-  You can use REST API to call your external DB which would return you the response.You can construct your request using HTTP Request class.Go through the below link to learn more :-

https://www.salesforce.com/us/developer/docs/api_rest/

https://developer.salesforce.com/page/REST_API

Hope this helps !!


Best Regards
Naga Kiran