Configuring a Data Source
- 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 when using a direct connection.
ODBC
Most databases that support Windows ODBC are supported, including
- Microsoft Access 2003 and 2007
- CSV
- Microsoft Excel 2003, 2007, and 2010
- Microsoft FoxPro
- Informix
- Pervasive
- Microsoft SQL Server
- SAP HANA
OLE
- Microsoft Access 2003 and 2007
- CSV
- Microsoft Excel 2003, 2007, and 2010
- Microsoft FoxPro
Direct
- Informix
- Oracle
- MySql
- Pervasive
- Microsoft SQL Server