Managing Data Sources

This section outlines how to manage data sources. It covers:

•   Using the Data Sources Tab

•   Planning Data Sources

•   Creating and Editing SQL Data Sources

•   Deleting Data Sources

Using the Data Sources Tab

The User Administrator window SQL Data Sources tab is used to create and edit data sources. The SQL Data Sources tab allows you to create new data sources that can hide details regarding the names and locations of databases and tables from Netcool Reporter users.

The SQL Data Sources tab appears at the bottom of the User Administrator window, as shown below.

 

   Figure 366: SQL Data Sources Tab

Netcool Reporter only supports only SQL data sources.

Planning Data Sources

Before you create new data sources, you must plan the data sources and database user accounts through which your users can access the databases.

To create data sources, you need to decide what data you want your users to access and whether you want to create virtual groups of users.

If specific database users with specific access privileges are already set up in the database, then you can use the existing database user accounts when creating your data sources.

 

   Note:


    Each Netcool Reporter data source is associated with a specific administrator account. If the account is deleted, all of the data source information for that account is deleted as well. You may want to retain the single, common administrator account to create data sources, and keep that account regardless of the individual that is performing the administration duties.


Collecting Information Associated with the Databases

To put user information in product-level login tables, you must collect the following information:

•   The names and passwords of the database users from the database administrator.

•   The database connect string from the database connectivity middleware.

Creating and Editing SQL Data Sources

If you are using the Netcool Reporter gateway to populate your data source, the default data source is called reporter. This data source provides access to the tables contained within the schema, which holds the data forwarded from the Netcool/OMNIbus ObjectServer.

To create new data sources, on the User Administrator window select Data SourceÆNew Data Source. The New Data Source window is displayed, as shown below.

 

   Figure 367: New/Edit Data Source Window

Table 116 describes the information you need to enter or change in each field name to add a new data source or modify an existing one.

Table 116: Required Data Source Information

Field Name

Explanation

Data Source Name

The name that you want your Netcool Reporter users to use in order to connect to the database. The name must not include the following characters: \ / : ‘ ? ‘ < > |

Database User Name

The name of a database user.

Database Password

The password of the database user.

Database Type

The database type. Select one of three database type values: Oracle, ODBC, or Sybase.

Connect String

The name of the connect string that the middleware for your database uses.

You must choose the name of your new data source based on the type of data your Netcool Reporter users receive, rather than on the location of the data.

Editing Data Sources

To edit a data source you have already created, highlight a data source name on the User Administrator window Data Sources tab and select the menu option Data SourceÆNew Data Source. Make the changes to the data source and click OK.

Deleting Data Sources

To delete an existing data source, highlight the data source on the User Administrator window Data Source tab, and select UserÆDelete Group. A window appears asking you if you are sure you want to delete the data source. If you are sure, click Yes.

 

   Note:


    Reports are associated with specific data sources that were used to create them. Deleting a data source also renders invalid any reports created using that data source.