Database connection parameters
| Database | Parameters |
|---|---|
| Oracle 12c or higher | Select Connection Type: Choose between SID and Service Name. The Oracle service name is the TNS alias that you give when you remotely connect to your database and is recorded in Tnsnames.ora file. Host: Enter the host name or the IP address of the server where the database server is installed. Port: Enter the port number on which the selected database is accessible. SID / Service: Enter the Oracle SID or Service Name, depending on the connection type that you selected. Driver Name: Select the applicable Java database connectivity driver (Thin, OCI or OCI8). |
| MySQL 8 or higher | Host: Enter the host name or the IP address of the server where the selected database server is installed. Port: Enter the port number on which the selected database is accessible. Database: Enter the name of the database that you want to use for your application. |
| PostgreSQL 10 or higher | Host: Enter the host name or the IP address of the server where the selected database server is installed. Port: Enter the port number on which the selected database is accessible. Database: Enter the name of the database that you want to use for your application. |
| Microsoft SQL 2015 or higher | Host: Enter the host name or the IP address of the server where the selected database server is installed. Port: Enter the port number on which the selected database is accessible. Instance: Enter the name of the database instance that you want to use for your application. |