.jpg)
A DB Connection is a pointer to a database. Flow has drivers for the major SQL databases that provides direct high-speed access through the databases client library. ODBC and ADO connections are also available for databases that do not have specific connections.
DB Connections are used on all Data Definitions. For File and Web Definitions this allows you to reference data from a database against the information in the File or Web Definition, although commonly you do not need to reference data in this way and instead use bespoke SQL command in the Map. However since you need to assign a DB Connection to a File and Web Definition it is recommended that you create a default DB Connection that points to your Flow configuration database and use this on the File and Web Definitions.
| Field Name | Description |
|---|---|
| Connection Name | A friendly name for the DB Connection. |
| Tab Name | Description |
|---|---|
| General | General options you need to fill in for all DB Connections |
| Advanced | Advanced options that you can leave at their default setting if desired. |
| Button Name | Description |
|---|---|
| Save | Click to save any changes you have made. All changes will be lost if you do not click the Save button. |
| Cancel | Click to cancel any changes you have made |
| Delete | Click to delete this module. You will be asked to confirm your choice. |
| Test | Click to test the connection to the database. This will save the current settings before performing the test. |