In Setup database reference, the system specialist can add an existing database to Metrics Management by creating a reference or link to that database. Setup database reference also supports editing and deleting database references.
Creating a database reference
Creating a database reference adds an existing Standard, SQL Server, or Oracle database to Metrics Management.
How to add a database reference
1 Choose File➛Open Servers and Databases.
2 Select a server from the list of servers in the main window.
3 In the Navigator, choose Setup Tools➛Setup database references➛Add a database reference.
How to specify a reference to a Standard database
1 In Add a database reference, in Database management systems (DBMS), select Standard, as shown in Figure 10‑4.
Figure 10‑4 Adding a reference to a Standard database
2 In Metrics Management database name, select a database name.
3 In Web server URL, to redirect this database to another Metrics Management web server, provide the URL for a Metrics Management web server. For information about redirecting a server request, see Installing and Configuring Metrics Management.
How to specify a reference to a SQL Server database
1 In Add a database reference, in Database management systems (DBMS), select Microsoft SQL Server, as shown in Figure 10‑5.
Figure 10‑5 Adding a reference to a SQL Server database
2 In Metrics Management database name, provide the name of the Metrics Management database on a SQL Server.
3 In User connection string, perform one of the following tasks:
To create a connection to the SQL Server database, choose Edit. In SQL Server Database Connection Properties, shown in Figure 10‑6, provide the following parameters. Then, choose OK.
Figure 10‑6 Specifying SQL Server connection settings
1 In Connection, from Server name, select the SQL Server name.
2 In Database user credentials, provide credentials to log on to SQL Server by performing one of the following tasks:
To log on using Windows credentials, select Use Windows integrated security. The account running the Metrics Management Server must have the appropriate rights to SQL Server.
To log on using SQL Server user credentials, select Use this SQL Server login. Then, provide the appropriate user name and password.
3 In Database name, select the name of the Metrics Management database on SQL Server.
4 Choose Test Connection. In the confirmation message, choose OK.
To load a connection file, choose Load. In Select Data Link File, navigate to the connection file. Then, choose Open.
4 In Web server URL, to redirect this database to another Metrics Management web server, provide the URL for a Metrics Management web server. For information about redirecting a server request, see Installing and Configuring Metrics Management.
How to specify a reference to an Oracle database
1 In Add a database reference, in Database management systems (DBMS), select Oracle, as shown in Figure 10‑7.
Figure 10‑7 Adding a reference to a Standard database
2 In Metrics Management database name, provide the name of the Metrics Management database in Oracle.
3 In User connection string, perform one of the following tasks:
To create a connection to the Oracle database server, choose Edit. In Oracle Database Connection Properties, shown in Figure 10‑8, provide the following parameters. Then, choose OK.
1 In Server parameters, in Host name or address, provide the name or IP address of the Oracle database server machine.
2 In Port number, provide the port number for Metrics Management to communicate with the Oracle database server.
3 Perform one of the following tasks:
In Service name, provide the Oracle service name. The service name is the name of Oracle Service on the Oracle database server.
In Instance name (SID), provide the instance name or system ID of the Oracle database.
If both server parameters are provided, Metrics Management connects using the Oracle service name.
4 In Database user credentials, provide the Metrics Management database user name and password.
To load a connection file, choose Load. In Select Data Link File, navigate to the connection file. Then, choose Open.
4 In Web server URL, to redirect this database to another Metrics Management web server, see Installing and Configuring Metrics Management.
How to apply the database reference
Choose Apply.
The database name and directory location displays below its server name in the main window.
Editing a database reference
When a database is moved, the database reference information must be updated. Any users must edit their local database references. Editing server database entries could affect all other users.
How to edit a database reference
1 Choose File➛Open Servers and Databases.
2 In the main window, choose the plus sign to display the databases on the selected server. The list of databases displays.
3 Select the database to edit and choose Setup Tools.
4 Choose Edit reference to selected database.
5 Change any settings, for example change the database name or path.
6 Choose OK.
The server list reflects your changes. Note that database names are not case‑sensitive. Therefore, you cannot save a database reference if changing only the case in a database name.
Deleting a database reference
Deleting a database reference does not remove any database files. This option only deletes the link from the database list. Any user can delete a link that references a database from the list of database reference links.
How to delete a database reference
1 Choose File➛Open Servers and Databases.
2 In the main window, choose the plus sign to display the databases on the selected server. The list of databases displays.
3 Select the database reference to delete.
4 Choose Remove reference to selected database.
5 On the prompt to confirm this action, choose Yes.
The selected database reference deletes from Metrics Management.
To create a connection to the SQL Server database, choose Edit. In SQL Server Database Connection Properties, shown in Figure 10‑6, provide the following parameters. Then, choose OK.
