This export hook exports release data into sql database. It also exports phases, tasks, teams, permissions, team members, variables and tags of the release.

1. Install MySQL or MariaDB
2. Create new database with name will be used in JDBC URL
3. Download the latest version of MySQL connector/J and put into <XLRELEASE_SERVER_HOME>/plugins

1. Install PostgreSQL
2. Create new database with name that will be used in JDBC URL
3. Download the latest version of PostgreSQL driver and put into <XLRELEASE_SERVER_HOME>/plugins

0. Make sure that your database server uses UTF-8 as default encoding otherwise, check this mySQL link / PostgreSQL link

1. Set up database schema:

   • MySQL mysql -u<user> -p<password> -D <database> < ./myTables.sql
   • PostgreSQL psql <database> -U <user> -W <password> < ./pgTable.sql

2. Copy plugin JAR to plugins folder (<XLRELEASE_SERVER_HOME>/plugins)

3. restart XL Release server

4. in XL Release go to Setting -> Configuration -> Add Sql export hook. Fill in your username, password, JDBC url:

   • MySQL

   Description	Property
   JDBC URL	jdbc:mysql://<host>:<port>/<database>
   Driver	com.mysql.jdbc.Driver

   

   • PostgreSQL

   Description	Property
   JDBC URL	jdbc:postgresql://<host>:<port>/<database>
   Driver	org.postgresql.Driver

   

5. Check that archiving is enabled