Well,

What I really want to do is this:

Create a SF Button.
That button fires an APEX Class/Trigger that pulls the most recent data from an external DB, through SSRS API.
That data then returns into the account AND then I also create a VF page that displays as a PDF for email purposes.

I have access to the SSRS API.

I just need to know if I can create the necessary class to call the SSRS API to return me the values I need.
   The third part is only possible if I get what I want above done, so let's start there.

I can't find documentation outside of the SF Canvas for what I am looking to do... Any fingers pointing in the correct direction would be amazing.