ODBC Plug-in
Connection Options for ODBC Drivers
ODBC drivers primarily require the connection string; the appropriate ODBC driver must be installed and active.
info
OPC Router does not include ODBC drivers.
Providing and configuring the required ODBC drivers is the responsibility of the user. This applies to both Windows and Docker installations.
| Name | Any name under which this database server appears in the connection configuration. Choose a name that is unique for you during connection setup. |
| ODBC Entry | Connection strings differ depending on the database system and version. If you do not know the connection string, check if you can establish the connection using the OLE-DB driver type. Select Microsoft OLE-DB Provider for ODBC Drivers as the provider if no specific OLE-DB provider is available for your database system. |
| User | Username for the ODBC driver |
| Password | Password for the ODBC driver |
Advanced Settings
| Polling Interval | Interval at which the database is queried. |
| BracketsEncloseBehaviour | This property determines when and how quotation marks are used in your ODBC plugin. More information |
| IBMDb2Type | Property to enable if the connected system is a DB2 Linux Unix Windows (LUW) system or DB2 for iSeries system. More information below. |
| QuerySpParameterDefaultValues | This property is used to query the default values of stored procedure parameters. When enabled, OPC Router retrieves and stores the default value of the parameter. |
BracketsEncloseBehaviour
- Include with Dot: This mode is for backward compatibility. If a dot (.) is present in the identifier, quotation marks are added. This is useful if you have database objects with dots in their names, e.g.,
database.schema."table.name". - Disable: In this mode, no quotation marks are added, regardless of the identifier. This can be useful if you are sure your identifiers do not contain special characters or spaces and you want to improve the readability of the generated SQL.
- Always: In this mode, quotation marks are always added. This is useful if your identifiers may contain special characters, spaces, or reserved words.
IBMDb2Type
- None (default): The connected system is not IBMDb2.
- Db2ForLUW: The connected system is a DB2 Linux Unix Windows (LUW) system.
- Db2ForI: The connected system is a DB2 for iSeries system.