Data Warehouse consists of two tools (Data Options and Refresh Settings) that allow management of standard data warehouse functionality.
The data warehouse is a read-only database that allows optimized access to data for reporting and analysis purposes. The data warehouse periodically flattens views from the live, production database and stores them as part of a backup that can be accessed by reporting tools.
Use of the data warehouse allows a district/state to materialize views into tables, simplify joins, and improve overall reporting and database performance. Views can be added or excluded through use of the Data Options tool.
See the Data Warehouse articles to learn more about Data Warehouse tools and how they are used.
Data Options
The Data Options tool allows a system administrator the ability to manually add/remove specific database views from being "flattened" by the data warehouse optimization process.
Refresh Settings
Initial Data Warehouse configuration is performed by Infinite Campus Hosting, after which a district/state system administrator can modify the details of the views included in the backup process (Data Options) and for setting the refresh schedule for data warehouse backups (Refresh Settings).
Available Tool Rights
Assigning the proper tool rights to users is imperative in keeping information safe and confidential. A limited number of users should have access to the data warehouse and related reporting tools.
Users need RWAD access in order to have full access to Data Warehouse functionality. A Campus system administrator will automatically have access to the data warehouse and reporting options if the All Tools checkbox is flagged on his/her User account.
Data Warehouse Settings Tool Rights
For full access to the data warehouse tool, a user will need full rights (RWAD) to the System Administration > Data Utilities > Data Warehouse Settings tool right. Granting full rights to this tool right will also grant full rights to the Refresh Settings and Data Options sub-rights/tools).
- Refresh Settings sub-right: This controls access to the Refresh Settings tool which allows scheduling and configuration of the data warehouse backup process.
- Data Options sub-right: This controls access to the Data Options tool which allows a user to add/remove the individual database views included in the data warehouse backup.
Task Scheduler Tool Rights
The user will see that a data warehouse task exists as a scheduled task in the Task Scheduler if he/she has RWAD rights to the System Administration > Preferences > Task Scheduler tool right.
The data warehouse cannot be configured or scheduled within the Task Scheduler, despite tool rights to this area.
Ad hoc Reporting Tool Rights
When the data warehouse is enabled on a site, it becomes the default data source for all ad hoc reporting, unless a user otherwise selects the "Live" option of the Data Source field of a reporting tool. The user will need R rights to the Data Warehouse: Allow Live Data As Source sub-right for each reporting tool in which he/she should have the ability to select the "Live" database option from the Data Source field.
This sub-right is not applicable to the Letter Designer tool.
Suggested User Groups
Typically, users of these tools have already been assigned one or more Product Security Roles that grant administrative-level access; therefore, a user group assignment is not necessary.
If your district's needs are different, you may choose to create a group that meets those needs.