Good morning everyone,

I'm looking to create a reasonable workflow for reporting from sage with SSRS. Currently, we're using report builder with an ODBC connection to achieve this, but even with limited testing we're noticing that this slows down the system for other users.

What I'd like to do is setup some tables on our MS server in SSMS that import information once per day to some tables stored there to prevent our activities from slowing down the main system. Currently, we can access the tables using openquery, using the ODBC connection to create a linked database. The first solution that comes to mind is to write a stored procedure every day to save the output from the openquery run locally and do reporting from there, but this seems roundabout and my instinct tells me there is probably a better way.

Has anyone here used a setup like this?