ODBC and JDBC Guide

Contents
Chapter 1
Introduction 5
About this guide 5
Where to find FileMaker documentation 5
About ODBC and JDBC 5
Using FileMaker software as an ODBC client application 6
Importing ODBC data 6
Adding ODBC tables to the relationships graph 6
Using a FileMaker database as a data source 7
Accessing a hosted FileMaker Pro database 7
Limitations with third-party tools 8
Networking requirements 8
Updating files from previous versions 8
Installing current drivers 8
Chapter 2
Accessing external SQL data sources 9
Importing ODBC data 9
Executing SQL to interact with data sources via ODBC 10
Working with ODBC tables in the relationships graph 10
Data sources supported in FileMaker 14 11
Adding ODBC tables to the relationships graph 11
Chapter 3
Installing FileMaker ODBC client drivers 12
Hardware and software requirements 12
Networking requirements 12
ODBC client driver architecture overview 12
ODBC client driver installation (Windows) 12
Configuring client drivers (Windows) 13
Opening the ODBC administrator (Windows) 13
Configuring the DSN (Windows) 14
ODBC client driver installation (OS X) 15
Configuring client drivers (OS X) 16
Where to go from here 18
Chapter 4
Using ODBC to share FileMaker data 19
About ODBC 19
Using the ODBC client driver 20
Overview of accessing a FileMaker database file 20
Accessing a FileMaker database file from a Windows application 21
Specifying ODBC client driver properties for a FileMaker DSN (Windows) 21
Verifying access via ODBC (Windows) 21
Accessing a FileMaker database file from an OS X application 22