Open Database Connectivity Standard (ODBC) is an open standard application programming interface (API) that uses SQL to access one or more databases from a single application. 4D and 4D Server both provide a native SQL server that enables this functionality.

Note: Starting from 4D v19, the 4D ODBC Driver is only available on the Windows platform. 

In order to set up a connection between an application and a 4D database using ODBC, you need to download 4D's ODBC Driver. The native 4D SQL server must also be started (see Configuration of 4D SQL Server). 

You can use the 4D ODBC driver to retrieve data from ODBC clients such as Word, Excel, Crystal Reports®, or using a Python script, a JDBC-ODBC bridge, or any other possible ODBC clients.

4D's ODBC Driver is available on our web site:

http://www.4d.com/downloads/products.html