Client/Server Applications

A client/server network is defined as a server or central computer hosting data and other forms of resources. OneView can monitor client/server applications by the use of passive and active tests.

The setup is that the software is run from a client installed on a PC. The software can be monitored actively or passively. Furthermore a server part exists and this can be passively monitored.

The following systems can be defined as a client/server application. Please note that some of the below mentioned systems can be both a client/server and a web application:

  • E-mail systems (Outlook, Exchange etc.)
  • Document Management (F2, Documentum etc.)
  • ERP Systems (Enterprise Ressource Planning) (SAP etc.)
  • CRM Systems (Customer Relationship Management) (Microsoft Dynamics)
  • Insurance Software Solutions (TIA)
  • Business Intelligence Systems (SAS Institute etc.)
  • Data Warehouse
  • Telephony

Passive Monitoring of Log Files using the Log Reader

OneView can read the contents of server log files from any client/server application. A number of predefined log formats exist but is it also possible by the use of regular expression to set up your own log reader in order to read any log file.

Passive Monitoring of Database Components

Database Query using the SQL Reader

The OneView SQL Reader can query most databases by the use of a simple database query. Simply connect to the database using one of the many supported templates in OneView and set up the database query.

The result is a simple transaction as defined in the SQL database query.

Database Query using the Service Tester

The OneView Service Tester can perform synthetic transactions towards the database components and perform comparison of databases.

Database Query

The database query executes an SQL query against a relational database. Enter the JDBC URL identifying the database – the format is dependent on the database vendor. Templates for connecting from SQL Server (JTDS), Oracle, DB2, MySQL, PostgreSQL and SQL Server (Microsoft) can be found in OneView. The SQL query is added to get the information required.

The result is a simple transaction as defined in the SQL database query.

Database Compare

The database compare executes queries against two relational databases and compares the results. Enter the JDBC URLs identifying the databases – the format is dependent on the database vendor. Templates for connecting from SQL Server (JTDS), Oracle, DB2, MySQL, PostgreSQL and SQL Server (Microsoft) can be found in OneView. The SQL queries must be valid for the given databases. The compare functionality looks for:

1) Number of rows and columns
2) Order of both rows and columns
3) Values of all cells

Active Monitoring

The most obvious way of setting up active monitoring of the client is by setting up an application robot on the client PC. The application robot simulates a user performing a series of actions, eg. clicking on links and buttons or entering text in the application.

Each user action can be represented by a transaction in OneView with corresponding availability and execution time as well as the complete use case.