ODBC and JDBC Guide

Chapter 1
Introduction
This guide describes how you can use FileMaker
®
software as an ODBC client application and as
a data source for Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC)
applications.
The following table gives an overview of how to use ODBC and JDBC with FileMaker software.
About this guide
1 This guide assumes that you are familiar with the basics of using ODBC and JDBC, and
constructing SQL queries. FileMaker
SQL Reference describes the SQL statements and
standards supported by FileMaker. Refer to a third-party book on constructing SQL queries.
1 This guide uses “FileMaker Pro” to refer to both FileMaker Pro and FileMaker Pro Advanced,
unless describing specific FileMaker Pro Advanced features.
Where to find FileMaker documentation
1 In FileMaker Pro, choose Help menu > Product Documentation.
1 In FileMaker Server Admin Console, choose Help menu > FileMaker Server Product
Documentation.
1 To learn about, view, or download additional FileMaker documentation, visit the Product
Documentation Center.
What do you want to do? How do you do it? Product See
1 Use FileMaker software
as an ODBC client
application
1 Access ODBC data
stored in an external SQL
data source
1. Interactively via the
relationships graph
2. One-time, static via
ODBC import or File
menu > Open. Also, the
Import Records script
step, the Execute SQL
script step, and the
ExecuteSQL function
1 FileMaker Pro
1 FileMaker Pro Advanced
1 FileMaker Server
1. This guide, chapter 2
2. F
ileMaker Pro Help
1 Use a FileMaker
database as a
data source
1 Share FileMaker Pro data
with a third-party ODBC
client application
1. ODBC and JDBC
2. SQL queries
1 FileMaker Pro
1 FileMaker Pro Advanced
1 FileMaker Server
1. This guide, chapters 3 to 6
2. F
ileMaker SQL
Reference