Cisco Unified Intelligence Center Report Customization Guide, Release 11.6(1)

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Book Contents
Find Matches in This Book
Available Languages
Download Options

Book Title

Cisco Unified Intelligence Center Report Customization Guide, Release 11.6(1)

Chapter Title

Data Sources

Results

Updated:
July 8, 2021

Chapter: Data Sources

Data Sources

Overview

Unified Intelligence Center supports the following types of data sources:

  • Query based SQL Data Source

    • Microsoft SQL Server

    • IBM informix

  • Streaming Data Source


    Note

    To perform any action on Configure > Data Source, you will be redirected to the legacy interface.

  • Mediasense Data Source (Rest Web Services)

Data Source Rules

  • Set up a database with an SQL user account and password, with read-only permission for the database.

  • The database server must allow SQL authentication to enable TCP/IP and remote network connection.

  • Do not block the database port by firewalls or any other security software (such as Cisco Security Agent).


Note

Windows integrated authentication connection to MS SQL Server is not supported.

Streaming Data Source

Live Data report uses Streaming data source. This is a stock data source in Unified Intelligence Center and the fields are not editable. On the data source listing page, the primary and secondary host name or IP address is displayed.

Figure 1. Data Source Page

Note

When you launch the data source listing page, a new tab displays to accept certificates.

MediaSense Data Source

Before you begin

After upgrade or fresh install of Cisco Unified Intelligence Center 11.6(1), to enable the Reporting for MediaSense apply MediaSense COP ciscocuic.enable_rest_datasource.cop.sgn. You can download and install the COP from https://software.cisco.com/download/release.html?mdfid=282163829&softwareid=282377062&release=11.6(1)&relind

To configure MediaSense data source, perform the following steps:

Procedure

Step 1

Navigate to the Data Sources page.

Step 2

In the Type field, select Rest Web Services.

Step 3

To configure the Base URL enter https://<MediaSense ipaddress>:8440/ora/

Step 4

In the Topic Schema URL field, enter https://localhost:8444/cuic/mediasense/schema_getSession_CUIC_compat.xml.

Step 5

Enter the User Name and Password of MediaSense Server.

Create or Edit a Query Based Data Source

A data source can be created or edited only by users with System Configuration Administrator role.

To create a data source, follow the steps below.

Procedure

Step 1

Click the Data Sources drawer.

Step 2

In the Data Sources tab, click Create.

Note 

To edit a data source, select the data source, and then click Edit.

Step 3

On the Primary tab, enter the name of the data source in the Name field.

Step 4

In the Description field, enter a description for the data source.

Note 
Cross-site scripting (XSS) vulnerability is not addressed for the Description field in Data Sources. For more information on XSS, see Security Considerations.
Step 5

From the Type drop-down list, select the type of data source.

Step 6

In the Datasource Host field, enter the hostname or IP address of the target data source.

Step 7

In the Port field, enter the port number that will allow Unified Intelligence Center to communicate with the database.

Note 
The port number is a mandatory field only for Informix database.
Step 8

In the Database Name field, enter the name of the database.

Step 9

In the Instance field, enter the instance of the database.

Note 
The name of the database instance is a required field only for Informix databases.
Step 10

From the Timezone drop-down list, select the time zone that the database is located in.

Step 11

In the Database User ID field, enter the user ID required to access the database.

Step 12

In the Password field, enter the password for the user ID required to access the database.

Step 13

In the Confirm Password field, enter the password again.

Step 14

From the Charset drop-down list, select the character set that is used by the database.

Note 

For Unified CVP, the charset value should be UTF-8 for Informix database.

Step 15

From the Max Pool Size drop-down list, select the maximum pool size.

Note 

Value ranges from 5-200. The default Max Pool Size value is 100 and is common for both the primary and secondary data source tabs.

Step 16

Assign the appropriate permissions to access and manage the data source.

Note 

Permissions are set only for the All Users and My Group. For specific permissions, see Manage User Permissions.

My Group refers to the data source owner's default group. If this default group is All Users group, the option to set permissions for non-administrative users is disabled. Only administrative users can set permissions for the All Users group.

Step 17

Click Test Connection to ensure that the database is accessible and the credentials provided are correct.

Step 18

Click the Secondary tab to configure a failover for the data source.

Note 

If you do not want to configure a failover for the data source, go to Step 20 directly.

Step 19

Check the Failover enabled check box.

Step 20

Enter the required details for the failover data source as described in Steps 6 to 16.

Step 21

Click Save.

Switch Nodes to a Data Source

A data source can be switched over to the secondary data source manually if required. However, a secondary data source has to be configured. For more information on configuring data sources, see Create or Edit a Query Based Data Source.

To switch over to an alternate data source, follow the steps below:

Procedure

Step 1

Click the Data Sources drawer.

Step 2

Select the data source that you want to switch over.

Step 3

Click Switch Over.

Note 

Switch Over is not applicable for Streaming data source.

Delete a Data Source

To delete a data source follow the steps below:

Procedure

Step 1

On the Data Sources page, click the radio button to the left of the data source name and click Delete.

Step 2

In the dialog box that appears, click OK to confirm the deletion, or click Cancel to cancel the action.


Note

Data sources are referenced by Report Definitions and Value Lists. When you delete a data source, a message informs you that you cannot delete the data source until the dependent Report Definitions or Value Lists are deleted or are updated to reference another data source.


Warning

Do not delete the “UCCE Historical” or “UCCE Real-Time” data sources that are configured out of the box. Deleting them results in unexpected failures (for example, user synchronization). Adding the same data sources manually does not fix these failures.

Was this Document Helpful?

FeedbackFeedback

Contact Cisco