How can I embed an SSRS report into Confluence

Tim Riddle May 5, 2015
 

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 5, 2015

You probably need to explain what you mean by SSRS - my original training leads me to reach for "Social Skills Rating System", which would generate reports you could embed in Confluence.  But the question is really "how is your SSRS system making the data and/or reports available in a way Confluence can read it and hence be able to embed it?"

(I know what you really mean, but I still don't actually know how such a system would make the reports available to Confluence.  REST?  SOAP?  Plain Http?  Read tables from a database an wrap them in a formatted report?  etc)

Tim Riddle May 5, 2015

sounds like you need to go back to your original training. :) We are experienced with pushing SSRS to the limits but don't have any experience with getting that content into Confluence programattically.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 5, 2015

I concentrated on the ratings that dealt with how well people could understand that other people don't necessarily have the same understanding of meanings. It was a useful course - IT people do have a tendency to score low, we often assume everyone understands our acronyms and jargon when they don't. Anyway, the question still stands - how is your SSRS system publishing this data? We're looking for a route for Confluence can ask for it to hand data over to be embedded Whether that's a complete block of "here's a report" or just "here's data that you can use to build the report is the second question, but you'll probably answer that as you explain the publishing.

Tim Riddle May 5, 2015

I can put the ssrs report output in word, excel, pdf, html, etc. as an email attachment or in a shared folder or....something else of your choice. I need direction as to how to get this into a confluence page without manual intervention.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 5, 2015

Ok, the formats are fine - most of them could be attached, and then referenced in pages in Confluence with the standard macros that can read attachments. For word, you could even import them as pages, discarding the word wrapper. But this is more about automation than formats - the implication of what you've said is that you need to do something in SSRS to get a file out of it. Is that purely something a human does in the UI? Or are there hooks in SSRS that would allow Confluence to request the exports? Or could you enable SSRS to run something that pushes the exports out? (That might be better, because Confluence has a stack of REST functions that allow other systems to easily push pages and other data into it)

TAGS
AUG Leaders

Atlassian Community Events