Skip to content
Get Free Trial

Storing Reports in MSSQL Database

By default Sahi stores its reports in a H2 database which is bundled in Sahi. Sahi reports can now also be logged in MSSQL database. To store in a MSSQL database, do the following:

Create a database in MSSQL using any MSSQL client. Let us assume that the name of the database is sahireports

The tables will be created automatically, once Sahi is restarted after performing the following steps. There is no need to run the db script manually.

Download the MSSQL Connector, extract and copy mssql-jdbc.jar to sahi/userdata/extlib folder (create if needed).

Add the following to userdata.properties in sahi/userdata/config folder

# Specifies database type.
# The inbuilt options are "mysql", "h2" and "mssql"
# Change jdbc parameters accordingly
db.type=mssql
#JDBC parameters for mssql database
db.driver_name=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.jdbc_url=jdbc:sqlserver://localhost:1433;databaseName=sahireports
db.user_name=sa
db.password=abcd123

Change the user_name, password and database name as required.

Restart Sahi. This will create the required tables in the database.

Run a script and check!