OLE DB Plug-in
Connection Options for OLE DB Drivers
note
Note: OLE DB is not supported in Docker.
OLE DB connections essentially require a 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 configuration. Choose a name that is unique to you during the connection configuration. |
| Connection String | Select a connection string from the drop-down menu. |
| 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 you must also increase this value for individual connections that trigger long queries. |
| Concurrent Connections | Number of connections the router is allowed to establish simultaneously. The more connections, the faster the router, but the database may be slower under certain circumstances. Ask your database administrator how many connections they allow the router to use. This naturally also depends on the scope of the project. |
| Polling Interval | Interval at which the database is queried. |