ODBC and JDBC Guide

Contents
Chapter 1
Introduction 5
About this guide 5
Where to find FileMaker documentation 5
About ODBC and JDBC 6
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 7
Networking requirements 8
Updating files from previous versions 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 11
Data sources supported in FileMaker 16 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 (Windows) 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 (macOS) 15
Configuring client drivers (macOS) 16
Where to go from here 17
Chapter 4
Using ODBC to share FileMaker data 18
About ODBC 18
Using the ODBC client driver 19
Overview of accessing a FileMaker database file 19
Accessing a FileMaker database file from a Windows application 20
Specifying ODBC client driver properties for a FileMaker DSN (Windows) 20
Verifying access via ODBC (Windows) 20