Real time reporting in SSRS RRS feed

  • Question

  • All,

    We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.

    What would be the best approach to build real time report.

    I've few options down...

    1. Directly point to OLTP database as source and write stored procedure to show result set.

    2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.

    3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.

    Thank you

    Friday, June 19, 2015 6:24 AM


All replies