Requirements: Polarion 2015 SR1 and above
Polarion stores all the data in the version control management repository that has xml documents. There is an embedded database that provides an ability to perform SQL-like join queries when you need to search the data. The database can be open for external access if you need to connect 3rd party reporting tools.
This extension provides possibility to connect and populate an external MySQL database. This external database may be useful, e.g. when you want to execute reports on top of Polarion data via an external reporting engine (such as BIRT). In many cases, the external database will provide better performance than connecting the reporting engine to the internal Polarion H2 database for high complex reports.
Connection to the external database can be specified by setting several Polarion properties (URL, username, password). The external database is then asynchronously updated by Polarion so that it is always kept in sync with the internal H2 (prior to version 2015 SR2) or PostgreSQL (starting with version 2015-SR2) database. Users can limit the number of tables that are stored in the external database and also create custom indexes to optimize the database structure for the purpose of their reports.