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 Flow configuration. Choose a name that is unique to you during Flow 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 slow down under certain circumstances. Ask your database administrator how many connections he allows the router to use. This, of course, also depends on the scope of the project. |
| Polling Interval | The interval at which the database is queried. |