ODBC Overview

Exchange data with open ODBC standards

FileMaker Pro Advanced is used to create and manage custom apps regardless of whether the data is stored in FileMaker Pro Advanced or in another data source.  FileMaker Pro Advanced can also be a data source for other applications.  Choose the product and feature that is right for what you want to do.

What do you want to do? Feature Name Product required

Using FileMaker Pro Advanced, I want to submit SQL queries or statements to an ODBC data source.

Execute SQL Script Step

FileMaker Pro Advanced

Using FileMaker Pro Advanced, I want to execute SQL SELECT queries or statements for a specified table occurrence within FileMaker Pro Advanced.

ExecuteSQL Calculation Function

FileMaker Pro Advanced

Using FileMaker Pro Advanced, I want to import data from an ODBC data source on an ad hoc basis.

ODBC Data Source Import

FileMaker Pro Advanced

Using FileMaker Pro Advanced, I want to import data from an ODBC data source on a regular basis.

Import Records Script Step

FileMaker Pro Advanced

Using FileMaker Pro Advanced, I want to create a live connection to a MS SQL Server, Oracle or MySQL data source.

External SQL Data Source

FileMaker Pro Advanced or FileMaker Server

Using a local ODBC client, I want to submit SQL queries or statements to a FileMaker app.

FileMaker Pro Advanced as a Data Source

FileMaker Pro Advanced

Using a remote ODBC or JDBC client, I want to submit SQL queries or statements to a FileMaker app.

FileMaker Pro Advanced as a Data Source

FileMaker Cloud/FileMaker Server

Before you get started

  • Install the appropriate ODBC driver.
  • Know the IP address or domain name of the ODBC data source or FileMaker custom app.
  • Know the user name and password for the ODBC data source as supplied by the database administrator.  The access that the database administrator provides will determine if you will be allowed to read/write or if you will have read only access.

Resources

ODBC Drivers

On Windows, most ODBC capable applications provide their own ODBC client drivers either as part of the install routine, or via their bundled software. Please check with the application provider (Microsoft, Oracle, etc) for these drivers.

On the Mac, ODBC client drivers are typically provided via 3rd-party providers.

On Linux, ODBC drivers are available through the FileMaker Cloud Admin Console.

Documentation and Notes

Get more from FileMaker!

View our web seminars.

Learn more