19.8. ODBC Previous topic Parent topic Child topic Next topic

To use ODBC, you must first create the database and tables in a way that depends on the type of database to which you are going to connect. See your vendor's documentation. You need to install and configure your ODBC manager. The way to do this also depends on your ODBC data manager.
For example, on Linux, macOS and other Unix systems, ODBC configuration typically is done with odbcinst.ini and odbc.ini files in /etc, /usr/local/etc, $HOME or other directory that depends on the system. For Windows, use the ODBC administration tools and add a System DSN (data source name).
Configure your SQL clause like this:
DBSource    dbi:ODBC:datasourcename
DBUsername  user
DBAuth      password