ODBC and JDBC Guide

Contents
Chapter 1
Introduction 5
About this guide 5
Where to find FileMaker product documentation 5
Overview of 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 Pro 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
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 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 access to FileMaker Cloud for AWS 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 18
Chapter 4
Using ODBC to share FileMaker data
19
About ODBC 19
Using the ODBC client driver 20
Overview of accessing a FileMaker Pro database file 20