The Database Explorer Tool allows you to query multiple types of databases in order to verify database contents in your test automation projects.
The DB Explorer tool supports query requests to multiple databases however only MYSQL has native support in the tool. Other databases can also be supported via configuration using database drivers we provide.
Supported Databases:
- MySQL
- MySQL (JDBC)
- MSSQL Server
- DB2
- PostgreSQL
- Oracle
- MariaDB
- InfluxDB
If the system (machine/vm) running the Functionize DB Jar file is accessible via a public endpoint then the configuration to test the database will only require the IP Address and Port of the Functionize DB Service system.
However, in most cases access to the internal database is restricted. In such scenarios a Functionize Proxy or Tunnel configuration can be implemented.
Access
The DB Explorer Request form contains the following fields:
-
Server IP
-
Server Type (drop-down selection)
-
DB Name
-
Credentials (Username and Password)
-
Query
As noted above, only MYSQL is supported natively within the tool. If you select another Server Type, the fields below will appear. See Advanced Database Integration below.
- Functionize DB Service
- Proxy IP
- Proxy Port
Fill in all fields, then click Launch Request.

Query Result
The Response Data will load. Click the + icon to view the response details.
The Response Data will display what is returned from the database request. In this example, we can see the following data has been returned and we could proceed to perform validations on it within the test case. You may verify or store this resulting data as you would with any other site.
-
order_id
-
firstname
-
lastname
-
date_added
-
total
Advanced Database Integration
If integrating with a JDBC interfacing database such as DB2, you will need to host a basic Whitelisted Proxy or Functionize Tunnel service to facilitate the communication between the Functionize Runtime environment and your database. This service will need to be set up in an environment where it can communicate directly with the database.
When using this configuration, the service that you install exposes a single endpoint to act as a passthrough to the database.
Whitelist Proxy
For this configuration, we will provide you with a Proxy that can be whitelisted in your DMZ to allow access to the Functionize DB service host that will in turn route the database queries to the appropriate database.
Functionize Tunnel
For this configuration, we will provide you with a Proxy to the Functionize WSS Tunnel endpoint to allow access to the Functionize DB service host that will in turn route the database queries to the appropriate database. The Java JAR file to host the DB Service can be run on the same system where the Tunnel is running.
Prerequisites
A minimum of Java 1.8 must be installed
Java needs to be added in system PATH
Installation
- Download the .jar file needed for all databases here.
- Test connectivity from the server where you would like to host the service
- The service can be run temporarily with java -jar functionize_databaseConnectivity.jar from the command line.
- You can use the curl command below to test connectivity.
(NOTE: The curl command for Oracle must include the Site Identifier or "sid" parameter.)
- Once connectivity is verified, install as a service. Instructions to install as a Linux service are available upon request.
Drivers Available:
For MSSQL: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
For Oracle: "oracle.jdbc.driver.OracleDriver"
For DB2 (JDBC4 specification): "com.ibm.db2.jcc.DB2Driver"
For PostgreSQL: "org.postgresql.Driver"
For mariaDB: "org.mariadb.jdbc.Driver:
For MySQL (JDBC): "com.mysql.cj.jdbc.Driver"
For InfluxDB: "com.dbschema.influxdb.InfluxJdbcDriver"
Connectivity Test Command:
curl -H "Content-Type: application/json" -X POST -d '{"sql":"DB_QUERY", "name":"DB_USER_NAME", "password":"DB_USER_PASSWORD", "dbname":"DB_NAME","server":"DB_SERVER_ADDRESS", "dbport": "DB_SERVER_PORT" , "driver":"DB_DRIVER" , "sid": "SITEID"}' http://ADDRESS_OF_SERVICE:2511/query