Data sets are the basic building blocks of reports, and they allow you to separate the data collection from the display to create charts, tables, and inputs in a report. You can gather data from databases, through REST APIs, or through Data Cube. You can also combine data from multiple sources in one data set. The CommServ database is automatically available as a data source, and you can register additional data sources, such as remote CommServe computers and third-party databases, like Oracle.
Database Data Sets
Database data sets most often consist of a simple query to a database. They can be made with a CommCell View, which is a stored SQL query to the CommServ database, with a query that calls on a CommServ database table, or a query to call on tables from third-party databases.
We recommend using CommCell Views to create database data sets because they are the easiest method for gathering information about CommCell components and settings. CommCell views combine logically-related data from various tables, and where necessary, display a human-readable translation of coded database information.
In cases where CommCell Views do not provide the information you need to build your own reports, you might need to query CommServ database tables. We recommend that only users with database experience try to build reports from CommServe database tables. For experienced SQL users, SQL Server Management Studio is the primary tool for building and testing SQL queries. SQL Server Management Studio is installed and available on the CommServe computer. You can use SQL Server Management Studio to identify the database schema, table designs, and column values.
HTTP Data Sets
HTTP data sets are made using Commvault REST APIs or third-party REST APIs.