Skip to main content
Version: 2025 R1

Oracle database

The source allows you to retrieve data from the Oracle database.

Oracle database

1. Basic connection parameters​

  • ID – the connection identifier (if the value is smaller than "0", the connection has not been saved in the database yet).
  • Name – name of the connection entered by the user.
  • Connection type – the field allows you to specify a connection type. You can choose from: MSSQL Database, Oracle Database, Exchange Server, OneDrive, SharePoint Site Collection, REST Web Service, and SOAP Web Service.
  • Description – description of the connection entered by the user.

2. NLS_TERRITORY​

In most cases, defining the parameter is not needed. Explicitly setting the NLS_TERRITORY parameter for each session with the Oracle database server might be necessary if the locale of the WEBCON BPS server is different from the NLS_TERRITORY parameter set by the Oracle server at database or instance level.

3. Validate connection​

A connection string parameter for Oracle database. Setting the ValidateConnection parameter to "TRUE" causes the connection cache to test every connection it retrieves against the underlying database.

4. Environment​

Defines the behavior of the connection in particular environments. The Common tab sets the default parameters that are to be used across all three environments (DEV/TEST/PROD). The tabs dedicated to the individual environments can be used to enter custom parameters. In such case, it is necessary to check the Break inheritance checkbox (this will override the settings specified in the Common tab) and then enter the desired connection settings.

5. Authentication​

Used to select an authentication method for the Oracle server.

  • User Login – authentication based on the user login. Provide the login and password of the database user.
  • Windows Authentication – authentication based on a Windows user account. The Application Pool Account will be used when the connection is used in the context of Portal (e.g. a choice field on the form powered by a data source that uses this connection). The Service Account will be used when the connection is used in the context of the WEBCON BPS Service (e.g. connection used in the configuration of a cyclical action).
  • SDK – authentication based on an SDK plugin.

6. Service name​

The name of the Oracle service.

7. User​

An Oracle user. For the Windows Authentication the field is unavailable.

8. Password​

An Oracle user's password. For the Windows Authentication the field is unavailable.

9. Test​

Tests the connection to the Oracle server.