Import MS SQL Report into Site

[Mario Bruckmayr]

Hello,

I'm trying to import content from an Reporting Server into my Confluence page. I use the HTML-INCLUDE macro for this. The Reporting Server has an authentification which allows "everyone". The problem is that it still requests a Kerberos ticket even though that it doesnt matter. Confluence runs on a Linux Red Hat Server with a non-Domain Service User. When i open my Confluence Site an Error displays with "Site not allowed". How can i display the results of my Reporting Server in Confluence?

[Mike Rathwell · Accepted solution]

Mario,

I ran into this also but in a different way. I set up a SQL server as a datasource to tomcat and had to put a username/password in the URL. There was no way to get around it even though the view I had didn't need authentication. For that, I set up a service account to get access.

If I could also suggest an alternate and far more flexible way of getting your reports into Confluence: As noted above I set up a SQL Server DB as a datasource to tomcat (among other DB servers on a variety of platforms). I use many of Bob Swift's SQL tools to make SQL queries to present live tables and charts on the Confluence pages. With the DBs that I created for my own purposes and other corporate DBs (or views to them), I have the flexibility of creating the reports I need when I need them and presenting them as is best.

Good luck with that connection. Connecting to PostgreSQL, Oracle, and MySQL was relatively painless; SQL Server.... not so much.

Mike