ODBC and JDBC Guide

Contents
Chapter 1
Introduction 6
About this guide 6
About ODBC and JDBC 6
Using FileMaker software as an ODBC client application 7
Importing ODBC data 7
Adding ODBC tables to the relationships graph 7
Using a FileMaker database as a data source 8
Accessing a hosted FileMaker Pro database 8
Limitations with third-party tools 9
Networking requirements 9
Updating files from previous versions 9
Installing current drivers 9
Chapter 2
Accessing external SQL data sources 10
Importing ODBC data 10
Executing SQL to interact with data sources via ODBC 11
Working with ODBC tables in the relationships graph 11
Data sources supported in FileMaker 12 12
Adding ODBC tables to the relationships graph 12
Chapter 3
Installing FileMaker ODBC client drivers 13
Hardware and software requirements 13
ODBC client driver requirements (Windows) 13
ODBC client driver requirements (Mac OS) 13
Networking requirements 13
ODBC client driver architecture overview 13
ODBC client driver installation (Windows) 14
Configuring client drivers (Windows) 15
Opening the ODBC administrator (Windows) 15
Configuring the DSN (Windows) 15
ODBC client driver installation (Mac OS) 17
Configuring client drivers (Mac OS) 17
Where to go from here 19