AliasSubDbOracleThin
This page provides generated reference documentation for the AliasSubDbOracleThin data model.
Overview
| Property | Summary |
|---|---|
| host | The host under which the the Oracle Thin server is reachable. |
| port | The port under which the Oracle Thin server is reachable. |
| sid | For Oracle, specifies the SID (Oracle System ID) of the database. |
| service | — |
| schema | The database schema to which this alias is to be connected. |
| user | The user to be used to log on to the Oracle Thin server. |
| password | The password of the user to be used to log on to the Oracle Thin server. |
| timezone | The timezone of the alias definition. |
| includeSynonyms | Specifies whether to support synonyms when using Oracle. |
| autoOrderByID | 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.
port
Type: Integer
Default: 1521
Constraints: Minimum: 0, Maximum: 65536
The port under which the Oracle Thin server is reachable.
sid
Type: String
For Oracle, specifies the SID (Oracle System ID) of the database.
service
Type: String
schema
Type: String
The database schema to which this alias is to be connected.
user
Type: String
The user to be used to log on to the Oracle Thin server.
password
Type: String
The password of the user to be used to log on to the Oracle Thin server.
timezone
Type: String
The timezone of the alias definition.
includeSynonyms
Type: Boolean
Default: false
Specifies whether to support synonyms when using Oracle.
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.