Configuring MS SQL database connection within Netcool/Impact

Edit online

You can configure a connection to a valid MS SQL database from within IBM® Tivoli® Netcool®/Impact.

Before you begin

In Netcool/Impact 7.1.0.13 and later releases, it is recommended to use the Event Analytics configuration wizard instead of the ./nci_trigger command to edit properties in the NOI Shared Configuration properties file. For more information, see Configuring Event Analytics using the wizard.

MS SQL support requires, at minimum, IBM Tivoli Netcool/Impact 7.1.0.1.

To use MS SQL as the archive database, you must set up a remote connection to Netcool/Impact.

About this task

Users can run seasonality event reports and related event configurations, specifying the time range and name with MS SQL. Complete the following steps to configure the ObjectServer data source and data type.

Procedure

  1. Log in to the Netcool/Impact UI. 
    https://impacthost:port/ibm/console
  2. Configure the ObjectServer data source and data type.
    1. In the Netcool/Impact UI, from the list of available projects, select the NOI project.
    2. Select the Data Model tab and select ObjectServerForNOI.
      1. Click Edit and enter the following information <username>, <password>, <host name>, <port>.
      2. Save the Netcool/Impact data source. Click Test Connection, followed by the Save icon.
    3. Edit the data type, expand the data source and edit the data type to correspond to the ObjectServer event history database type.
      For example, AlertsForNOITable
    4. For Base Table, select <database table>.
    5. To update the schema and table, click Refresh and then click Save.
    6. Select the Data Model tab and select ObjectServerHistoryMSSQLForNOI.
      1. Click Edit and enter the following information <username>, <password>, <host name>, <port>, <sid>.
      2. Save the Netcool/Impact data source. Click Test Connection, followed by the Save icon.
    7. Edit the data type. Expand the data source ObjectServerHistoryMSSQLForNOI and edit AlertsHistoryMSSQLTable.
    8. For Base Table, select <database table name>.
    9. To update the schema and table, click Refresh and then click Save.
    10. Select the Services tab and ensure that the following services are started.
      • ProcessRelatedEvents
      • ProcessSeasonalityEvents
      • ProcessRelatedEventConfig
  3. Configure the report generation to use the MS SQL database.
    1. Generate a properties file, go to the <Impact install location>/bin directory to locate the nci_trigger and in the command-line interface enter the following command. 
      nci_trigger <server> <username>/<password> NOI_DefaultValues_Export
 FILENAME directory/filename
      <server>
      The server where Event Analytics is installed.
      <user name>
      The user name of the Event Analytics user.
      <password>
      The password of the Event Analytics user.
      directory
      The directory where the file is stored.
      filename
      The name of the properties file.
      For example, ./nci_trigger NCI impactadmin/impactpass NOI_DefaultValues_Export FILENAME /tmp/seasonality.props.
    2. Update the properties file. Some property values are overwritten by the generated properties file, you might need to update other property values in the generated properties file. For a full list of effected properties, see Generated properties file.
      • If you do not have the following parameter values, update your properties file to reflect these parameter values.
        history_datasource_name=ObjectServerHistoryMSSQLForNOI
history_datatype_name=AlertsHistoryMSSQLTable
history_database_table=<database table name>
history_database_type=MSSQL
    3. Import the modified properties file into Netcool/Impact, enter the command. 
      nci_trigger <Server> <username>/<password> NOI_DefaultValues_Configure  
FILENAME directory/filename
      For example, 
      ./nci_trigger NCI impactadmin/impactpass NOI_DefaultValues_Configure 
FILENAME /tmp/seasonality.props