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 2 | Accessing external SQL data sources 11
Working with ODBC tables in the relationships graph
When you add an ODBC table to the relationships graph, you can connect to and work with data
in external SQL data sources in much the same way that you work with data in the current, active
FileMaker Pro database file.
When you use FileMaker Pro, FileMaker Server, or a FileMaker Cloud product as the host for a
solution that includes ODBC tables in the relationships graph, you configure the ODBC client
driver for the external SQL data source on the host machine.
Data sources supported
As an ODBC client application, FileMaker Pro supports external SQL data sources such as
Oracle, Microsoft SQL Server, and MySQL Community Edition as ODBC tables in the
relationships graph. For information about the supported external SQL data sources, search the
K
nowledge Base.
Adding ODBC tables to the relationships graph
To set up a FileMaker Pro database to access data in supported ODBC data sources:
1. Install and configure specific ODBC drivers for the external data sources you want to access.
2. On the computer that hosts the current FileMaker Pro file, define a system DSN for each ODBC
data source you want to access.
3. Determine any additional considerations for ODBC data sources you want to access (for
example, whether users are prompted for a user name and password).
4. Add one or more tables from the ODBC data source to the relationships graph in the current
FileMaker Pro file.
5. Add fields to layouts in the FileMaker Pro file to display external data.
6. Optionally, add supplemental fields to external tables and layouts to display calculation and
summary results based on data stored in external ODBC data sources.
See FileMaker Pro Help for detailed steps and additional information on configuring an ODBC
client driver, connecting to ODBC data sources, editing ODBC data sources, and setting up an
ODBC table in the relationships graph.
SQL data
source
Driver
manager
FileMaker Pro
user
Client
driver
FileMaker Pro
user
FileMaker Pro
user
FileMaker Pro
, Server, or
Cloud product
host