ODBC and JDBC Guide

Chapter 2
|
Accessing external SQL data sources 13
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 11
As an ODBC client application, FileMaker supports the following external SQL data sources as ODBC
tables in the relationships graph:
1 Oracle 9i
1 Oracle 10g
1 Oracle 11g
1 SQL Server 2000
1 SQL Server 2005
1 SQL Server 2008
1 MySQL 5.0 Community Edition (free)
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.
Driver
Manager
FileMaker
Pro user
Client
Driver
SQL Data
Source
FileMaker
Pro user
FileMaker
Pro user
FileMaker Pro
or
FileMaker
Server host
machine