Working with Synthetic Database test profiles
This section covers the following topics:
Preparing for a Database test
Before creating the profile for a Synthetic ‘Database Test’, verify that the database is JDBC compatible, in which case it is accessible by a URL of the form jdbc: <database-type> :// <host>: <port-number>/<name>. The database that serves NetIM, for example, is accessible by a URL like:
jdbc:postgresql://10.20.30.40:5492/vnes
Also ascertain a username and password that can access the database, such as dssadmin and OpNet123! for NetIM’s instance of PostgreSQL.
The 5492 is the port number at which PostgreSQL 9.2 listens.
To enable a test engine to access a JDBC-compatible database, it is necessary to copy the vendor’s JDBC driver jar file to <TestEngineInstallDir> \TestEngine \testengine \active_agent \extensions \test_engine \test_engine_0 \lib \jdbc\. Obtain the jar file from the database vendor or from a directory of support files within the installed product. A test engine comes with the PostgreSQL, Oracle, and Microsoft SQL Server drivers installed. Restart the test engine’s host after copying the jar file.
Using the wizard for a Database test
To create, clone, edit, or delete a Synthetic Database test profile
1. Log in to the UI as a user with administrative privilege.
2. Choose Configure > All Settings > Monitor: Synthetic Testing.
3. On the Choose Action page, select a radio button to specify whether you will Create, Clone, Edit, or Delete a Synthetic Test Profile.
– If you are creating a Profile, click Next.
– If you are cloning or editing a Profile, highlight the name of an existing profile in the list below, and click Next.
– If you are deleting a Profile, highlight the name of an existing profile in the list below, click Next, and then typically click Finish.
4. On the Test Details page, select Active. In the Name field, enter a unique name for this Profile. In the Test Type drop-down, pick Database. In the Test Frequency field, set how often this test will run, or accept the default of 300 seconds. Set Timeout to the number of seconds that this test must wait for a response before giving up.
If this test is associated with the performance of one or more applications, enter the Application name(s) here. Also set the name of a Device under test, if applicable. Device can also be the name of a region, business group, or other designator. These properties are passed to downstream Riverbed products for identifying and organizing Synthetic Test results.
5. Click Next.
On the Test Configuration page, all settings are required.
In the JDBC URL field, enter a single JDBC URL, or enter %URI% which will be replaced with all of the URI’s you enter on the Test Targets page.
6. Enter the Username, and Password.
7. Click Next.
Optionally, click Advanced and enter:
– SQL Query— an SQL Query string.
– Expected Results— If you want to test for specific query results, enter the Column Name and Value.
Use the + sign to enter multiple column names and their expected values. All of the expected values must be present in the result for the test to pass. The expected results need not be in the same row for the test to pass.
8. On the Test Sources page, select one or more test engines from which this test should be run, and click Next.
9. On the Test Targets page, enter the JDBC URL of one or more databases to be tested. If you enter more than one, verify that you entered %URI% on the Test Configuration page. Click Next.
10. On the Summary page, verify all settings. Click Previous to go back and modify, or click Finish to save the profile.