Version: 5.4

ODBC Plug-in

Connection Options for ODBC Drivers

ODBC drivers essentially require the connection string. The corresponding ODBC driver must be installed and active.

info

OPC Router does not contain any ODBC drivers.

The user is responsible for providing and configuring the required ODBC drivers. This applies to both Windows and Docker installations.

Property	Description
Name	Any name under which this database server appears in the connection project. Choose a name that is unique to you during connection project planning.
ODBC entry	The connection strings differ depending on the database system and version. If you do not know the connection string, check whether you can establish the connection using the OLE DB driver type. Select Microsoft OLE DB Provider for ODBC Drivers as the provider if no special OLE DB provider is available for your database system.
User	User name for the ODBC driver
Password	Password for the ODBC driver

Property	Description
Polling Interval	Interval at which the database is queried.
BracketsEncloseBehavior	This property determines when and how quotation marks are used in your ODBC plugin. More information is available here.
IBMDb2Type	Property that must be activated if the connected system is a DB 2 Linux Unix Windows (LUW) system or DB 2 for iSeries system. More information is available here.
QuerySpParameterDefaultValues	This property is used to query the default values of stored procedure parameters. If this property is enabled, OPC Router will retrieve and store the default value of the parameter.

Enclose if dot present: This mode is intended for backward compatibility. If a period (.) is included in an identifier, quotation marks are added. This is useful if you have database objects with periods in their names, such as 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 that your identifiers do not contain any 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 could contain special characters, spaces, or reserved words.