1 – Supported database versions
The following Database version versions are supported (We use the same driver as that used by The Jira Server. Please check these out: https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html )
Oracle: We use the same driver as that used by The Jira Server (Please see hereby: https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html )
Oracle 19c
Oracle 18c
Oracle 12c R2
PostgreSQL
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9.6Oracle based in driver version 23.3.0.23.09: Oracle DB Server 23c, 21c, 19c, 18c, and 12.2
SQL-Server / AzureSQL based on driver version 12.4.2.jre8:
Postgres based on driver version 42.7.1: support of PostgreSQL Server 8.2 till 16
SQL Server version | Support |
---|---|
Azure SQL-Database | yes |
Azure Synapse Analytics | yes |
Managed Azure SQL Database | yes |
SQL Server 2022 | yes |
SQL Server 2019 | yes |
SQL Server 2027 | yes |
SQL Server 2016 | yes |
SQL Server 2024 | yes |
2 – Database connections
Database connections are considered as a pool or resources, which can be used for several purposes. This core functionality will be installed with every VIP.LEAN app requiring read and /or write access to the databases.
Under the menu point: Manage apps > VIP.LEAN ETL FOR REPORTING > Database Connections you can create, edit, and delete the database connections:
...
3 – Add new database connection
...
Field | Type | Description |
---|---|---|
Database Connection Name | String | Please enter a name for your database connection. It is mandatory and should be unique. |
Driver | List | Possible values: Please select your database version. |
Connection URL | String | When you click in this field a configuration URL will be recommended. Please enter the URL without any user or password information. See attached pictures below this table. Postgres URL: Please ask your ETL admin for the correct URL. |
Username | String | Database username provided by the DB Admin. |
Password | String | Database password provided by the DB Admin. |
Max. Pool Size | Number | Number of open connections to be used by the ETL for Reporting app to accelerate the DB read and write actions. When you increase this value, please make sure the required hardware resources are available. |
Please test your connection before you save the connection. In case you receive an error message, please contact your DB admin to analyze the root cause (Network connection error, User and password are wrong, Connection URL is wrong …).
...