OLE DB Plug-in
Connection Options for OLE DB Drivers
warning
Caution: OLE DB is not supported in Docker.
OLE DB connections essentially require the connection string. The OLE DB provider for your database system must be installed and active.
| 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. |
| Connection string | Select a connection string from the drop-down menu. |
| Command Timeout | Time (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 you must also increase this value for individual connections that trigger long queries. |
| Simultaneous Connections | Number of connections that the router is allowed to establish in parallel. The more connections, the faster the router, but the slower the database may be. Ask your database administrator how many connections he allows the router. This also depends on the scope of the project, of course. |
| Polling Interval | Interval at which the database is queried. |