Using ODBC and JDBC with FileMaker Server
You can use FileMaker Server as:
•a
data source. 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 use FileMaker Pro data in other applications to create charts, analyze numbers, and generate reports.
•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 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 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. See
Accessing external ODBC data sources.
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 and JDBC in FileMaker Server
What do you want to do? | See |
Host a FileMaker Pro database as a data source | |
Host a FileMaker Pro database that accesses an external ODBC data source | |
Related topics