ODBC and JDBC Guide

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 19

Table Of Contents

Chapter 1 | Introduction 6

The following table gives an overview of how to use ODBC and JDBC with FileMaker software.

Using FileMaker software as an ODBC client application

As an ODBC client application, FileMaker software can access data in external SQL data sources.

FileMaker software connects to the external SQL data source using the client driver for the ODBC

data source, and either imports ODBC data or works with ODBC tables in the relationships graph.

Importing ODBC data

You can import ODBC data in either of these ways:

1 from the File menu, by specifying an ODBC data source and entering SQL statements in the

FileMaker Pro SQL Query builder dialog box

1 by creating a FileMaker script that uses the Import Records script step or the Execute SQL

script step

For either of these methods, you enter the SQL statements yourself, so you need to know the

supported SQL statements and their syntax for your ODBC data source. And because you write

the SQL statements, you can import ODBC data from any ODBC data source. See FileMaker SQL

Reference for information on SQL statements and syntax supported by the Claris FileMaker

Platform.

Adding ODBC tables to the relationships graph

When you add an ODBC table to the relationships graph, you can connect to and work with data

in external SQL data sources in much the same way that you work with data in the current, active

FileMaker Pro database file. For example, you can:

1 create tables in the relationships graph for ODBC data sources

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

1 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 Claris FileMaker Pro

1 Claris FileMaker Server

1 Claris FileMaker Cloud®

1 Claris FileMaker Cloud

for AWS

1 This guide, chapter 2

1 FileMaker 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 1 FileMaker Pro

1 FileMaker Server

1 FileMaker Cloud for AWS

1 This guide, chapter 3 to 6