This section outlines how to manage data sources. It covers:
• Creating and Editing SQL Data Sources
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.
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.
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.
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.
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.
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.
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.