Using ODBC and JDBC with FileMaker Server

You can use FileMaker Server as:

•a data source. You can share hosted FileMaker Pro Advanced 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, use FileMaker Pro Advanced data in other applications to create charts, analyze numbers, and generate reports.

•an ODBC client application. Hosted FileMaker Pro Advanced databases can interact with data sources on the same computer or over a network. For example, hosted FileMaker Pro Advanced databases can work with an Oracle data source interactively as defined in the FileMaker Pro Advanced relationships graph and in layouts.

FileMaker Server as a data source

FileMaker Server 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 for information about enabling a database file for sharing.

For information about using client drivers and using SQL with a FileMaker database file as an ODBC or JDBC source, see FileMaker ODBC and JDBC Guide.

For details about supported SQL statements, expressions, and functions, see FileMaker SQL Reference.

FileMaker Server as an ODBC client application

When you use FileMaker Server 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 Advanced 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 Advanced database was designed to use. FileMaker Server supports several third-party drivers. See Accessing external ODBC data sources.

See FileMaker Pro Advanced 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 and JDBC in FileMaker Server

Related topics 

Server information settings