V11 SP8
Loading...

Connecting to the CommServe Database with Data Cube

Administrators can use the database connector in Data Cube to connect to the CommServe database. They can then collect information about their CommCell environment to generate reports perform other administrative tasks.

Before You Begin

You must log in to Data Cube with user credentials that are associated to the master role in the CommCell Console. If you are not assigned the master role, then you will not see the option to select the CommServe database.

Procedure

  1. In a Web browser, log in to the Web Console and then click Analytics > Database.
  2. Under Data Connectors next to Database, click Add New.
  3. On the New Data Source (Database) page, configure the source as follows:
    1. Under Data Source Name:
      • Click the Analytics Engine list and select the Analytics Engine on which to store the crawling data.
      • In Data Source Name, enter a name for the data source. The name can only contain alphanumeric characters, underscores, and dashes.
      • In Data Source Description, enter a description for the data source.
      • Click Next to proceed to the next section.
    2. Under Database Connection Details:
      • Select CommCell Database.
      • Click the CommCell list and select the CommServe host that you want to connect to.
      • Click Next to proceed to the next section.
    3. Under SQL Query and Preview:
      1. Click the Table list and select whether you want to select from a list of database tables or views.
      2. Click the list to the right and select the table or view that you want to connect to.

        A select all query automatically appears in the box below.

      3. Modify the query in the SQL query box according to your needs.

        Note: The SQL query is used to gather the data from the CommServe database. Even if you select a different table in the drop-down list, the SQL query will take precedent.

      4. Click Preview to execute the query and view the results. You can modify the query and click Preview again to preview your changes.

      5. Click Next to proceed to the next section.
    4. Under Advanced Options:
      • If a column in the database contains multiple values, click Add next to the Split by option, and then specify the column name and the delimiter used to separate the values in the column.

        Note: This option must be configured when creating the initial database source.

      • To crawl only updated values in the database, enable Incremental Crawl and enter a Primary Key, Delta SQL Query, and Delta Import SQL Query.

        For more information, see Incremental Crawling Database Sources.

      • Click Next to proceed to the next section.
    5. Under Entity Extraction:
      • To enable entity extraction for the data source, select Enable Entity Extraction.
      • Click the Content Analyzer list and select the content analyzer cloud that you want to use.
      • Click the Entities to Extract list and select the check boxes next to the types of entities that you want to include during crawls.

        Tip: Use the search bar to search for the entities that you want to select.

        For more information about the entity types, see Entity Extraction Types for Data Cube.

      • In Fields to Extract Entities From, select the fields that you want to use for entity extraction.
      • Click Next to proceed to the next section.
    6. Under Data Blending:
      • If you want to configure data blending, select Enable Data Blending and configure the data blending options.

        For more information, see Configuring Data Blending in Data Cube.

      • Select Start Crawling Now to start crawling the data source after the data source is saved.
  4. When finished, click Submit.