Creating and modifying database stubs

You can create and modify database stubs in IBM® DevOps Test Integrations and APIs (Test Integrations and APIs).

Prerequisites for creating database stubs
Before creating any database stubs, you must complete any required software installation tasks and set up the schema that is used for stubbing a physical database.
Database stubs overview
If you want to create a test or suite of tests for an application that uses a database, you run the test (suite) in a repeatable fashion against a known set of database contents. Therefore, you must stub the database to obtain repeatable conditions. Database stubs enable you to execute tests against some parts of a system under test without affecting a live database.
Persistence
Database stubs created in IBM DevOps Test Integrations and APIs (Test Integrations and APIs) can be non-persistent or persistent.
JDBC proxy
The IBM DevOps Test Integrations and APIs (Test Integrations and APIs) JDBC proxy package is provided with IBM DevOps Test Virtualization Control Panel (Test Virtualization Control Panel). You must deploy the package on any stand-alone applications, or application servers that host applications that use JDBC to access any live databases that you want to record or virtualize.
Stored procedures
If you are using IBM DevOps Test Integrations and APIs (Test Integrations and APIs) 8.0.1 or later, you can record and virtualize most stored procedures.
Data type support
You can find information about the data types supported for database management systems in IBM DevOps Test Integrations and APIs (Test Integrations and APIs).
Synonyms
A synonym is an alias or alternate name for a table, view, sequence, or other schema object. IBM DevOps Test Integrations and APIs (Test Integrations and APIs) 8.5.1 or later supports certain synonyms for some supported database management systems.
Creating database stubs by using the Recording Studio
You use the Recording Studio perspective of the IBM DevOps Test Integrations and APIs (Test Integrations and APIs) to create a database stub while SQL events are being recorded from a database.
Modifying database stubs
You can modify database stubs in IBM DevOps Test Integrations and APIs (Test Integrations and APIs).

Parent topic: Tester Guide - Service Virtualization

Related concepts

Test Virtualization overview
Creating and modifying message-based stubs
Publishing and running stubs