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
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.
Where to find FileMaker documentation
To learn about, view, or download 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 Advanced
1 FileMaker Server
1 FileMaker Cloud
1 This guide, chapter 2
1 FileMaker Pro Advanced
Help
1 FileMaker Cloud Getting
Started Guide
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 Advanced
1 FileMaker Server
1 FileMaker Cloud
1 This guide, chapters 3 to
6
1 FileMaker SQL
Reference
1 FileMaker Cloud Getting
Started Guide