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 or to perform other administrative tasks. After the data source is added, you can restructure the data. For example, you can combine data from two or more data sources into a single data source. For information about the available data restructuring options, see Restructuring Data in Data Cube.
Before You Begin
You must log on to Data Cube with user credentials that are associated with 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
-
From the Data Cube dashboard, next to Database, click Add New.
Tip
Alternatively, click Database to open the Data Sources (Database) page, and then click Add Database in the upper-right corner.
The New Data Source (Database) page appears.
-
In the Data Source Name section, enter the following information:
-
Field Name
Description
Steps
Index Server
The Index Server entity that you want to use for the data source.
The Index Server list is populated by the Index Servers configured for Data Cube in your CommCell Console.
Click the Index Server list and select an Index Server.
Data Source Name
The name of the data source as it will appear in the Data Cube dashboard.
-
Enter a name for the data source.
Note: Only alphanumeric, dash, and underscore characters are supported.
Data Source Description
A short description of the data source that is visible to any user who can view the data source in Data Cube.
- Optional: Enter a description for the data source.
-
-
Click Next.
-
In the Database Connection Details section, select CommCell Database.
-
Click the CommCell list, select the CommCell environment that you want to use, and then click Next.
-
In the SQL Query and Preview section, enter the following information:
Field Name
Description
Steps
Table
Use this option to create a select all (SELECT *) SQL query for a table or view from the CommServe database.
Optional: To create a select all (SELECT *) SQL statement for a table or view from the database, complete the following steps:
-
Click the Table list, and then select to view the database Tables or Views.
-
Click the list that appears and select the table or view that you want to use.
In the SQL Query box, a SELECT * from {table | view} query appears.
SQL Query
The SQL query that you want to use to select data from the database. If you enter a SQL statement in this field, it will take priority over the SELECT statement created from selecting a table or view.
-
In SQL Query, enter the SQL query statement.
-
Click Preview.
A table appears with the data returned from the database.
-
You can modify your SQL query and repeat this procedure as necessary.
-
-
Click Next.
-
In the Advanced Options section, enter the following information:
Field Name
Description
Steps
Split by
If there are data fields in your database with multiple values separated by a delimiter, you can configure these data fields so they function as multi-valued columns in the data source.
Configure delimiters for multi-valued columns in the database by performing the following steps:
-
Click Add.
-
Click the Column list and then select the data field to split.
-
In Split by, enter the delimiter to use for splitting the values in the data field.
-
To add more columns and delimiters, click the plus-sign button (+).
Incremental Crawl
Select this option to crawl only updated values in the database.
For more information, see Incremental Crawling of Database Sources in Data Cube.
- Optional: Click the slider to enable incremental crawling.
Primary Key
When incremental crawl is enabled, the primary key used to uniquely identify rows in the database.
- If incremental crawling is enabled, enter a column name that is a unique primary key for the database.
Delta SQL Query
When incremental crawl is enabled, the SQL query used to determine the database fields that changed since the previous crawl.
- If incremental crawling is enabled, enter the SQL query.
Delta Import Query
When incremental crawl is enabled, the SQL query that selects the data to import from the database for the rows that match the criteria in Delta SQL Query.
- If incremental crawling is enabled, enter the SQL query.
-
-
Click Submit.
The data source name Configuration page appears.