Share this page

# Connect with JDBC

PulseUno uses a JDBC driver to connect to the database. This topic describes the format of the JDBC URL for Oracle, PostgreSQL, and Microsoft SQL Server databases.

In this topic:

## JDBC URL for Oracle

We recommend using database service names when connecting with JDBC. The common convention is for the net service name defined in tnsnames.ora to have the same value as the database service name.

If you have named it differently, connect to an Oracle database using SQL*Plus as the system user and run the following SQL query to discover it:

Copy code

    SELECT SYS_CONTEXT('USERENV', 'SERVICE_NAME') AS database_service_name FROM DUAL;

To set the JDBC URL for the Oracle database:

1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

   Default locations:

   Operating system | Location
   --- | ---
   Windows | C:\ProgramData\OpenText\PulseUno\pulse_data\conf
   Linux | /opt/opentext/pulseuno/data/pulse_data/conf

2. Set the database.jdbcurl property to the following URL:

   jdbc:oracle:thin:@//<database-server-hostname>:<port>/<database-service-name>

   The default port is 1521, for example:

   Copy code

       database.jdbcurl=jdbc:oracle:thin:@//dbserver.example.org:1521/dim14

Back to top

## JDBC URL for PostgreSQL

For the PostgreSQL database, the port parameter in the JDBC URL is optional, and the default port is 5432.

To set the JDBC URL for the PostgreSQL database:

1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

   Default locations:

   Operating system | Location
   --- | ---
   Windows | C:\ProgramData\OpenText\PulseUno\pulse_data\conf
   Linux | /opt/opentext/pulseuno/data/pulse_data/conf

2. Set the database.jdbcurl property to the following URL:

   jdbc:postgresql://<database-server-hostname>:<optional-port-number>/<database-name>

   For example:

   Copy code

       database.jdbcurl=jdbc:postgresql://dbserver.example.org:5432/dim14

Back to top

## JDBC URL for MS SQL Server

To connect to MS SQL Server, first ensure that TCP is enabled on a fixed TCP port in SQL Server Configuration Manager.

To set the JDBC URL for MS SQL Server:

1. Open the startup.properties file in the <pulse_data>\conf directory on the PulseUno server.

   Default locations:

   Operating system | Location
   --- | ---
   Windows | C:\ProgramData\OpenText\PulseUno\pulse_data\conf
   Linux | /opt/opentext/pulseuno/data/pulse_data/conf

2. Set the database.jdbcurl property to the following URL:

   jdbc:sqlserver://<database-server-hostname>:<optional-port>;databaseName=<database-name>

   The port parameter is optional, and the default port is 1433.

   For example:

   Copy code

       database.jdbcurl=jdbc:sqlserver://dbserver.example.org:1433;databaseName=dim14

Back to top

See also:

- Configuration settings
- Secure your installation
- Basics

https://admhelp.microfocus.com PulseUno 8942
Tips to improve your search results... PulseUno Help Center PulseUno Help 24.2 - 25.2 All View Local Help Center View Online Help Center Version: