Manualshelf

ODBC and JDBC Guide

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 14
11121314151617181920
Table Of Contents
Chapter 2 | Accessing external SQL data sources 11
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 14
As an ODBC client application, FileMaker supports the following external SQL data sources as
ODBC tables in the relationships graph:
1 Oracle
1 Microsoft SQL Server
1 MySQL Community Edition (free)
For information about the supported versions of these ODBC data sources, search the FileMaker
Knowledge Base available at
http://help.filemaker.com.
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 Data Source Name
(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.