Configuring a Data Source
When configuring any of the lookup or verification processes involving a third party database, you will need to configure the connection to the external database. Quick Fields offers three wizards to help you with this connection, with different capabilities for automation and customization.
- Windows ODBC (Recommended): Helps configure the data source drivers by connecting to the Windows ODBC Data Sources settings for a particular Windows user or computer.
- Advanced (Direct connections): Shows all the drivers currently supported by Quick Fields. Requires knowledge of the settings expected by the data source you configure.
- Expert (Connection strings): Allows you to manually configure the connection string. Requires expert knowledge of how to connect to a data source.
Supported Databases
Below are databases supported by the lookup and verification processes.
ODBC
- Microsoft Access 2003 and 2007
- CSV
- Microsoft Excel 2003, 2007, and 2010
- Microsoft FoxPro
- Informix
- Pervasive
- Microsoft SQL Server
OLE
- Microsoft Access 2003 and 2007
- CSV
- Microsoft Excel 2003, 2007, and 2010
- Microsoft FoxPro
Direct
- Informix
- Oracle
- MySql
- Pervasive
- Microsoft SQL Server