Cisco Unified Intelligence Center Report Customization Guide, Release 10.5(1)
Data Sources
Downloads: This chapterpdf (PDF - 1.18MB) The complete bookPDF (PDF - 2.45MB) | The complete bookePub (ePub - 235.0KB) | The complete bookMobi (Mobi - 386.0KB) | Feedback

Data Sources

Data Sources

Unified Intelligence Center supports the following types of data sources:

  • Microsoft SQL Server
  • IBM Informix
  • Java Message Service (JMS)

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.
    Step 5   From the Type drop-down list, select the type of data source.
    Note   

    To configure a data source of type Java Message Service (JMS), see Create or Edit A Java Message Service Based 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   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 16   Click Test Connection to ensure that the database is accessible and the credentials provided are correct.
    Step 17   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 18   Check the Failover enabled check box.
    Step 19   Enter the required details for the failover data source as described in Steps 6 to 16.
    Step 20   Click Save.

    Create or Edit A Java Message Service Based Data Source

    To create a report definition of query type Real Time Streaming, you need a Java Message Service (JMS) based data source. The JMS based data source does not have a Secondary data source tab. However, JMS based data sources do support failover Broker URLs using the failover: keyword as shown below.


    Note


    Ensure that the 'failover' term in the Broker URL syntax for JMS based data source is always given in lower case letters.
    Ensure that you have the following information handy:
    • URL for the JMS Broker and the failover URL if any
    • URL for the schema that contains the list of published topics
    • User name and password used to access the Schema URL

    To create a JMS based 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   In the Name field, enter the name of the data source.
      Step 4   In the Description field, enter a description for the data source.
      Step 5   From the Type drop-down list, select Java Message Service (JMS).
      Step 6   In the Broker URL field, enter the URL for the JMS broker. The only protocol supported for the JMS Broker URL is tcp. Syntax for the JMS Broker URL is tcp://hostname:port as shown in the example below. The hostname can be replaced with the IP address too. To configure failover broker URLs, use the syntax failover:(tcp://primary hostname:port, tcp://secondary hostname:port)

      Example:tcp://11.111.11.111:61616
      Note    If JMS data source is not configured with failover option, Unified Intelligence Center will not publish the updates to the client in the event of a momentary loss of connectivity with the JMS data source.
      failover:(tcp://11.111.11.111:61616, tcp://22.222.22.222:61616)
      Note   

      The time zone is set to UTC by default for JMS based data sources and cannot be changed.

      Step 7   In the REST URL parameters section, in the Topic Schema URL field, enter the schema URL which contains the list of subscribed topics. The only protocols supported are http and https. Syntax for the topic schema URL is protocol://hostname:port/path where the schema is present. The hostname can be replaced with the IP address too.

      Example:

      http://11.111.11.111:8088/schema/rest/reportdefinition/schema/

      Step 8   In the User Name field, enter the REST username that is required to access the topic URL.
      Step 9   In the Password field, enter the REST password required to access the topic URL.
      Note    Ensure that your REST password does not exceed 12 characters.
      Step 10   In the Confirm Password field, confirm the REST password.
      Note   

      Ensure that the administrator validates the topic schema URL before using it in the JMS data source. If credentials are required to validate the topic schema URL, enter the username and password in the Data Source page.

      The REST topic schema is validated when you create the report definition for that report.

      Step 11   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.

      Step 12   Click Test Connection to ensure that the JMS Broker URL is accessible.
      Note   

      For Data Source, Test Connection validates only the JMS broker URL and not the REST topic schema URL.

      Step 13   Click Save.

      Switch Over to an Alternate 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 a Java Message Service (JMS) data source.