Versions Compared

Old Version 5

changes.mady.by.user Wajdi Abdmoulah

Saved on

compared with

New Version 6

changes.mady.by.user Wajdi Abdmoulah

Saved on

Key

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

...

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

...

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 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.

...