ODBC (Open Database Connectivity) Actions
Create, Amend and Delete ODBC actions. An action could be triggered when a user opens a particular application, enabling access to a database containing relevant data.
ODBC connections enable a computer to access data from any application, regardless of the database management system (DBMS). Use this action to establish a connection between a computer and a database stored on another system. The following actions are available:
- Create ODBC Connection
- Amend ODBC Connection
- Delete ODBC Connection
To specify an ODBC connection for any of the three actions select the Connection Details tab and complete the following fields:
| Field | Description |
|---|---|
| Connection Name | A unique name to identify the connection. |
| Driver Type | A drop down list containing the available driver types |
| Current Connections | The list is automatically populated with all available connections on the current computer, based on the driver type selected. |
Once the connection is defined, specific programs can be told to use the connection to access information on that database.