Post reply

Combine SQL Server DB & Oracle DB data in the SSRS Report.

  • February 24, 2012 at 8:04 am

    #265222

    Hi,

    I have a SQL Server DB and a Oracle DB. I'm writing a report that needs to combine data from those two sources into a single report. Could you please give idea for combine the query for combine both the DB Tables. What is the best way to do this?

    Thanks.

  • February 24, 2012 at 9:02 am

    #1451463

    You could use a linked server from the SQL Server side and retrieve the data from Oracle via stored proc. In that stored proc join the data and then just use SSRS to present the data.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply