ODBC and JDBC Guide

Chapter 2 | Accessing external SQL data sources 12
When you use FileMaker Pro or FileMaker Server 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 in FileMaker 12
As an ODBC client application, FileMaker supports the following external SQL data sources as
ODBC tables in the relationships graph:
1 Oracle 10g
1 Oracle 11g
1 SQL Server 2005
1 SQL Server 2008
1 MySQL 5.1 Community Edition (free)
For information on supported client drivers, see http://www.filemaker.com/support/technologies.
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.
1 On the computer that hosts the current FileMaker Pro file, define a system Data Source Name
(DSN) for each ODBC data source you want to access.
1 Determine any additional considerations for ODBC data sources you want to access (for
example, whether users are prompted for a user name and password).
1 Add one or more tables from the ODBC data source to the relationships graph in the current
FileMaker Pro file.
1 Add fields to layouts in the FileMaker Pro file to display external data.
1 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.
Driver
Manager
FileMaker
Pro user
Client
Driver
SQL Data
Source
FileMaker
Pro user
FileMaker
Pro user
FileMaker Pro
or
FileMaker
Server host
machine