Data Sets for Build Your Own Reports
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 CommServ 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.
To help you determine which tables or columns to use, we have created a webpage that lists all CommServ database tables, including table and column descriptions. You must have a user account on the Cloud Services website to view this webpage. For instructions, see Getting Access to the Cloud Services Website. To view the webpage, see SnapProtect Database Tables.
Alternatively, you can request additional information about the database, views, tables, columns, and values by sending an email to firstname.lastname@example.org.
HTTP Data Sets
HTTP data sets are made using SnapProtect REST APIs or third-party REST APIs.
Data Cube Data Sets
You can create data sets using Data Cube in the Analytics application on Web Console, and then use those data sets to build reports. For more information about the data sources available with Data Cube, see Data Cube Overview.