|
The
Client
The client is one of the leaders in configuration audit and
control. It enables companies to control risk and increase
operational efficiency through its advanced configuration audit and
control solutions which detect and analyze all configuration events
across the IT infrastructure.
Our
client provides an application which enables configuration auditing
and control by detecting all changes, including file systems,
network devices (switches, routers, firewalls), and directory
servers (Active Directory, Lightweight Directory Access Protocol).
The
application for database version 6.0.1 is capable of detecting all
changes to database structures, reporting change details and
supporting Oracle 9i, Oracle 10g and Microsoft SQL Server 2000/2005,
MySQL Server.
Requirements
Our
client required us to test the application product quality on 6
databases (Oracle 9i, Oracle 10g, MySQL Embedded, MySQL Distributed,
SQL Server 2000, SQL Server 2005)
Challenges
Testing is a core area and even the best conceived and designed
product, if inadequately tested, can easily fail. Realizing this
fully, we committed to ensure that it thoroughly met the
requirements of the client which included the following:
-
Testing is a costly part of any operation, but the client was also
keen on cutting costs which meant that a way had to be found.
-
The
client has a system that can provide a single point of configuration
control for ensuring that all changes are visible, all changes are
planned and verified, and that all unauthorized changes are
investigated.
-
Needs
tend to vary while testing because it’s such a dynamic activity,
Calling for a thorough ability to handle fluctuating resource
requirements.
Duration: 15 months
Solutions
We set up an Offshore Development Center (OSDC) exclusively
for the client’s project. Besides lowering the total cost of
ownership, the OSDC also delivered high-quality testing facilities
for the client. Some of the testing methodologies adopted include:
-
Test:
Web User Interface (WebUI), Network Driver Interface (NDI),
Reporting, File System Interface (FSI), Directory Services Interface
(DSI), Agent Installation, Server Installation following Test Plan
provided by Tripwire.
-
Regression testing: This is the most intricate testing procedure.
Once a change has been made to fix problems with the software, it
should be tested again to ensure that no new bugs have been
accidentally introduced while fixing old bugs.
-
Ad hoc
testing: This test was used as a complement to regression testing.
The testers sought to find bugs with any means that seemed
appropriate.
-
Migration testing: The application has passed through a lot of
versions and many customers are still using older versions. This
test is to verify that old and new functions work correctly on the
upgrade version.
-
We
delivered all weekly test reports on time, saving client
frustration.
Technologies used:
FPT Software tools; Report Data Generator; Mock Station; MS Project 2003;
SubVersion; SecureCRT5.0.5; TestTrack Pro 7.0; ElementGeneratorRules;
Router Simulators; Tera Term Version4.28; MS Windows 2000, 2003, XP;
MySWL Server; SQL Server; Oracle.
Benefits to Customer
-
The
most important thing from the vendor point of view was that the
costs were cut down dramatically.
-
Major
bugs in the system were removed to migrate seamlessly with all
required databases.
-
The
complete testing platforms were handed over to the client to ensure
that it has access to the world class testing paradigms we adopted.
|
