Report development begins on your desktop. Reports are then promoted (or published) to an online environment when the report is ready to be shared with and viewed by others.
The table below summarizes the purpose of each report development environment, the URL for each online environment, the source of the data used to populate the report, and the file back-up protocol maintained centrally for each layer in the architecture. A three-tiered server architecture (Production, Test, Development) supports the online reporting environment.
|Report Environment||Description||Report Server||Report’s Data Source||Backups Maintained Centrally|
|Report Developer’s Desktop||Initial report development is done on your desktop computer, using Business Intelligence Development Studio (BIDS).||N/A||Production Data||None|
|The “sandbox” area for Reporting Services is an environment for you to publish prototype reports and where business users test and review these reports.||Test Data*||None|
|This environment is used to conduct report performance testing done by Enterprise Data & Analytics staff.||https://edwtestbi1.s.uw.edu/ReportsTEST/||Test Data*||Yes|
|This environment hosts the production report.||https://edw.washington.edu/Reports/||Production Data||Yes|
*Refreshed weekly from production data