Help

Using ODBC and JDBC with FileMaker Server
F
ILEMAKER SERVER 9 HELP 101
Using ODBC and JDBC with FileMaker Server
You can use FileMaker Server as:
• a data source
, if you have a FileMaker Server Advanced license. You can share hosted
FileMaker Pro database files with other applications on the same computer or over a
network using ODBC
(Open Database Connectivity) and JDBC (Java Database
Connectivity). For example, you can create charts, analyze numbers, and generate reports
using FileMaker Pro data in other applications.
• an ODBC client application
. Hosted FileMaker Pro databases can interact with data sources
on the same computer or over a network. For example, hosted FileMaker Pro databases
can work with an Oracle data source interactively as defined in the FileMaker Pro
relationships graph
and in layouts.
FileMaker Server Advanced as a data source
FileMaker Server Advanced includes the software you need to share databases as data sources via
ODBC and JDBC, including the FileMaker client drivers
you use to access your databases from
other ODBC- or JDBC-compliant applications. See Sharing FileMaker databases via ODBC and
JDBC (page 103) for information about enabling a database file for sharing.
For details about supported SQL
statements, expressions, Catalog functions, and client drivers, see
the F
ILEMAKER ODBC AND JDBC GUIDE on the Start Page.
FileMaker Server as an ODBC client application
When you use FileMaker Server or FileMaker Server Advanced as a client application, you must
install and configure drivers for the ODBC data sources to access and set up the data source names
(DSNs) that hosted FileMaker Pro databases are designed to use. For example, to access data from
an Oracle database using ODBC, you must install and configure an Oracle ODBC client driver and
set up exactly the same DSNs that the FileMaker Pro database was designed to use. FileMaker
Server supports several third-party drivers. For more information, see Accessing external ODBC
data sources (page 105).
See FileMaker Pro Help for information about:
• working with ODBC data sources interactively, in real-time, in the relationships graph and in
layouts.
• importing ODBC data in batch operations with SQL queries.
What you need to work with ODBC in FileMaker Server
What do you want to do? See Product
Host a FileMaker Pro database
as a data source
Sharing FileMaker databases
via ODBC and JDBC (page
103)
F
ILEMAKER ODBC AND JDBC
G
UIDE on the Start Page
FileMaker Server Advanced
license required
Host a FileMaker Pro database
that accesses an external
ODBC data source
Accessing external ODBC data
sources (page 105)
FileMaker Pro Help
FileMaker Server or FileMaker
Server Advanced