Versions Compared

Old Version 2

changes.mady.by.user Amal Ellouze

Saved on

compared with

New Version Current

changes.mady.by.user Wajdi Abdmoulah

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1 – Supported database versions

The following Database version versions are supported (We use the same driver used by The Jira Server. Please see https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html )

  • PostgreSQL

  • PostgreSQL 11

  • PostgreSQL 10

    • PostgreSQL 9.6

    Postgres based on driver version 42.7.1:  support of PostgreSQL Server 8.2 till 16

  • Oracle 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:

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 2014

yes

2 – Database connections

The 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 a read and /or /and write access to the databases.
Under the menu point: Manage apps > VIP.LEAN DATABASES 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:
ORACLE
POSTGRES
SQLSERVER

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.
Oracle URL:
jdbc:oracle:thin@<host>:<post>:<sid> or
jdbc:oracle:thin:@//<host>:<port>/<service name>

Postgres URL:
jdbc:postgresql://<host>:<post>/<database>

Please ask your

DB

ETL admin for the correct URL.

Username

String

Database

user name

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

Data Warehouse

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 any 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 …).

Once the connection is saved, it can be used by the app for further actions.

Please note: in In the case where you use the DB connection actively for read or write actions, any subsequent change of to the database parameters could lead to major errors. If you want to migrate your Data Warehouse ETL for Reporting App to another DB ETL connection, please create first a second DB connection and migrate the Data Warehouse ETL Rules to this connection.