Skip to main content
Version: 2025.1

AliasSubDbOracleThin

This page provides generated reference documentation for the AliasSubDbOracleThin data model.

Overview

PropertySummary
autoOrderByIDIf yes/true, each frame is automatically sorted by the ID column of the respective database table. If no/false, no automatic sorting will be executed.
hostThe host under which the the Oracle Thin server is reachable.
includeSynonymsSpecifies whether to support synonyms when using Oracle.
passwordThe password of the user to be used to log on to the Oracle Thin server.
portThe port under which the Oracle Thin server is reachable.
schemaThe database schema to which this alias is to be connected.
service
sidFor Oracle, specifies the SID (Oracle System ID) of the database.
timezoneThe timezone of the alias definition.
userThe user to be used to log on to the Oracle Thin server.

autoOrderByID

Type: Boolean
Default: true

If yes/true, each frame is automatically sorted by the ID column of the respective database table. If no/false, no automatic sorting will be executed.


host

Type: String

The host under which the the Oracle Thin server is reachable.


includeSynonyms

Type: Boolean
Default: false

Specifies whether to support synonyms when using Oracle.


password

Type: String

The password of the user to be used to log on to the Oracle Thin server.


port

Type: Integer
Default: 1521
Constraints: Minimum: 0, Maximum: 65536

The port under which the Oracle Thin server is reachable.


schema

Type: String

The database schema to which this alias is to be connected.


service

Type: String


sid

Type: String

For Oracle, specifies the SID (Oracle System ID) of the database.


timezone

Type: String

The timezone of the alias definition.


user

Type: String

The user to be used to log on to the Oracle Thin server.