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]Microsoft employee 14 hours 31 minutes ago Moving to the SSIS forum as it's related to that topic.

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

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...