locked
Report Model with mulitple data sources RRS feed

  • Question

  • Hi,
    We have requirement to develop report model in 2008 having multiple data sources which includes SQL SERVER 2012 and Oracle database so end user can all the relevant data in one place to run in report builder. So please advise how this can be achieved.

    One option I can think of pulling all the data into one database through SSIS and then build a smdl on it.

    I heard it might be possible to build Tabular cube and then use Report builder on it not sure which is the best option unless any other solution.

    Thanks,

    • Moved by Kevin Cunnane [MSFT] Friday, February 13, 2015 8:57 PM Moving to the SSIS forum as it's related to that topic.
    Friday, February 13, 2015 12:29 AM

Answers

  • You can use SSIS to collect data from multiple sources (SQL Server, Oracle, etc.) and store it in SQL Server database. Then you can use SSAS to build a cube on that database. With SSRS/reportbuilder you can create reports on the cube or on the database...

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Friday, February 13, 2015 10:23 PM

All replies

  • Hi,

    Not sure, although I suggest you try the SSRS forum first, this forum is for SSDT which doesn't cover SSIS/SSAS/SSRS I'm afraid.

    Regards
    Jamie

    Friday, February 13, 2015 12:42 PM
  • You can use SSIS to collect data from multiple sources (SQL Server, Oracle, etc.) and store it in SQL Server database. Then you can use SSAS to build a cube on that database. With SSRS/reportbuilder you can create reports on the cube or on the database...

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    Friday, February 13, 2015 10:23 PM