Configuring Data Sources for All Reports on Command Center

You can configure remote CommServe computers and third-party databases as data sources for reports using the Command Center. Configure a data source for all reports, or for a single report.

Before You Begin

• To add a data source, your CommCell user account requires a role with the Add Datasource permission and an association with the CommCell entity.

  The Delete Datasource, Edit Datasource, and Query Datasource permissions are automatically assigned when you add a data source.

  For more information on users, permissions, and associations, see User Administration and Security - Overview.

• If the Private Metrics Reporting Server cannot connect to the CommServe computer, or if you have a firewall between the remote CommServe computer and the Private Metrics Reporting Server, then you must establish a connection using the CommCell Console. For instructions, see Configuring CommServes as Data Sources on CommCell Console.

• Verify that a signed SSL certificate is installed on the remote Command Center used for CommCell registration.

  CommCell registration will fail if the signed certificate is not available, because a secure connection cannot be established with the remote CommCell.

Procedure

1. From the Command Center navigation pane, go to Monitor > Reports.

   The Reports page appears.

2. Click the Data Sources tile.

3. Click Add new data source.

4. Perfrom one of the following operation:

   • To add another CommServe database, select Add remote CommCell.

     1. In the Command Center Host Name box, enter the name of the Command Center that connects to the CommServe computer.

     2. In the User name and Password boxes, enter your login credentials for the CommServe Computer on the CommServe computer.

        Your user account must be a member of the Master group in the CommServe computer that hosts the Web Console.

   • To add another type of database, select Add remote database.

     1. In the Database Type list, select the type of database that you want to add.

     2. In the Data source name box, type the name that you want to be displayed in the Select data sources list.

     3. In the Host box, type the name of the computer where the database resides.

     4. The default port number is automatically entered in the Port box.

     5. If you do not use the default port number, in the Port box, type the correct port number.

     6. Configure the database name.

        • For Oracle databases, in the Database name box, type the TNS name for the database that you want to add.

        • For other types of databases and instances, in the Database name or Instance name box, type the name of the database or instance that you want to add.

     7. In the User name and Password boxes, type your login credentials for the database or instance that you want to add.

5. Click Save.

   The data source is added to the list.

Supported Database Types

• Oracle

• SQL

• MySQL