ODBC and JDBC Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Accessing external SQL data sources
- Chapter 3 Installing FileMaker ODBC client drivers
- Hardware and software requirements
- ODBC client access to FileMaker Cloud for AWS
- ODBC client driver architecture overview (Windows)
- ODBC client driver installation (Windows)
- Configuring client drivers (Windows)
- ODBC client driver installation (macOS)
- Configuring client drivers (macOS)
- Where to go from here
- Chapter 4 Using ODBC to share FileMaker data
- Chapter 5 Installing FileMaker JDBC client drivers
- Chapter 6 Using JDBC to share FileMaker data
- Chapter 7 Reference information
- Index
Chapter 1 | Introduction 7
1 add supplemental fields to ODBC tables to perform unstored calculations or to summarize data
in the ODBC tables
1 add, change, and delete external data interactively
1 create relationships between fields in FileMaker tables and fields (also called “columns”) in
ODBC tables
Because FileMaker Pro generates the SQL statements used to communicate with an ODBC table
that has been added to the relationships graph, you are limited to the specific Oracle, SQL Server,
and MySQL data sources that FileMaker Pro supports in the relationships graph.
Note You cannot modify the schema of external ODBC data sources using FileMaker Pro.
Chapter 2, “Accessing external SQL data sources,” describes how to use FileMaker software as
an ODBC client application.
Using a FileMaker Pro database as a data source
As a data source, FileMaker data is shared with ODBC- and JDBC-compliant applications. The
application connects to the FileMaker data source using the FileMaker client driver, constructs and
executes the SQL queries using ODBC or JDBC, and processes the data retrieved from the
FileMaker Pro database solution.
Note Using FileMaker Pro databases as a data source is not supported for databases hosted by
FileMaker Cloud.
Accessing a hosted FileMaker Pro database
With FileMaker Cloud for AWS, FileMaker Server, or FileMaker Pro, you can host a FileMaker Pro
database file as a data source, sharing your data with other applications using ODBC and JDBC.
The following table describes what each FileMaker product allows.
If your FileMaker Pro database solution uses more than one FileMaker Pro database file, all of the
database files must be on the same computer.
To access a hosted FileMaker Pro database file, you need to install the corresponding ODBC or
JDBC client driver. Install the client driver on the machine where the third-party application is
installed.
This guide documents how the ODBC and JDBC client drivers, when used with FileMaker Pro and
FileMaker Server, support the industry standards for ODBC and JDBC.
To learn about the SQL statements supported by ODBC and JDBC client drivers when used with
FileMaker Pro and FileMaker Server, see FileMaker SQL Reference.
This FileMaker product Allows
FileMaker Cloud for AWS Unrestricted connections and supports remote ODBC or JDBC client access.
FileMaker Server Unrestricted connections and supports local access (same computer) and remote
access (both for middleware such as web servers, and for remote client access from
desktop productivity applications).
FileMaker Pro Up to five connections and supports local access (same computer) only.