Oracle Plug-in
The Oracle database is a powerful database for business applications. The OPC Router supports native connectivity via the appropriate Oracle client drivers and TNS. You can find a detailed video on this topic under “Connecting Database Systems” in our Tutorial Stream.
The following properties can be configured in the Oracle plug-in:
“Connection Settings” tab
| Property | Description |
|---|---|
| Name | Name under which the Oracle database server appears in the connection configuration. Choose a name that is unique to you during the connection configuration. |
Connection Type
Three different connection types are available. Depending on the selected connection type, various properties can be configured.
- Hostname
- TNS
- Cloud Wallet
| Property | Description |
|---|---|
| Host/IP | Hostname or IP address of the server. |
| Port | Port on which the Oracle database service is accessible. |
| Database | The database to which the connection is to be established. |
This property must be set for a successful connection test. | | Schema | The Oracle schema to be used can be selected here. |
| Property | Description |
|---|---|
| TNS Name | Name of the TNS configuration to be used. |
| Port | Port on which the Oracle database service is accessible. |
| Schema | The schema to be used |
warning
Only one Cloud Wallet can be configured. Once a Cloud Wallet is in use, no other Oracle plug-in can be used
| Property | Description |
|---|---|
| Cloud Wallet | Wallet file in which the access data for the database to be connected to is stored. |
| Database | Database to be connected to |
| Property | Description |
|---|---|
| Windows Authentication | Uses the OPC Router service’s Windows account instead of a username and password. This account must have the necessary access rights to the database. For project configuration, the rights of the user under which the configuration environment is running apply. Notes on configuring Windows user accounts for the OPC Router. |
| User | Username for logging in to the Oracle database server |
| Password | Password for logging in to the Oracle database server |
“Advanced Connection Parameters” tab
| Property | Description |
|---|---|
| Command Timeout | Time in seconds that the router waits for an SQL command to complete. For long-running queries, it may be necessary to increase this value. Please note that the connection timeout must also be increased for connections in which long queries are executed. |
| Connection Timeout | Time in seconds that establishing a connection to the database is allowed to take. |
| Concurrent Connections | Number of connections the router is allowed to establish to the database simultaneously. The more concurrent connections allowed, the faster the router will be, but this may slow down the database. Ask your database administrator how many connections they allow the router to use. This naturally also depends on the size of the project. |
| Polling Interval | Interval in seconds at which the database is queried. |
“Advanced” Tab
| Property | Description |
|---|---|
| Bracket Behavior | This property determines when and how square brackets are used in your Oracle plugin. A detailed explanation of the individual options can be found here. |
| Convert Boolean Values | If this option is enabled, the values “1”, “y”, “t” are converted to true, and “0”, “n”, “f” are converted to false. |
| Oracle append schema | If this option is enabled, the schema is appended to the identifier. A brief explanation can be found here. |
| Oracle column data type source | This property determines how column data types should be handled. A more detailed explanation can be found here. |
| Oracle home | Directory where the Oracle client software is installed. |
| Include Oracle packages | If this option is enabled, stored procedures located in packages are also listed. |
Quoting Behavior
- Quote if dot is present: This mode is intended for backward compatibility. If a dot (.) is included in an identifier, quotes are added. This is useful if you have database objects with dots in their names, such as
database.schema."table.name". - Never enclose in quotes: In this mode, no double quotes are added, regardless of the identifier. This can be useful if you are certain that your identifiers do not contain special characters or spaces.
- Always enclose in quotes: In this mode, double quotes are always added. This is useful if your identifiers may contain special characters, spaces, or reserved words.
note
Please note that in Oracle, the use of quotes serves to escape identifiers that would otherwise be interpreted as reserved words. It also allows the use of special characters and spaces in identifiers.
Oracle append schema
- Legacy: Same behavior as in the previous version.
- YES: The schema is always appended to the identifier. This is useful if you are working with multiple schemas in the same database and want to ensure that the correct tables and views are used.
- No: The schema is not appended to the identifier. This can be useful if you are working with only one schema or if you want full control over the SQL statements generated by the plugin.
Oracle column data type source
- Auto: Data types are converted to the best-matching data types during reading. This can simplify the transfer of data to another system.
- Data Reader: Data types are retained during reading and are not converted. This setting is helpful when it is important to preserve the exact data types.