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.