Sharing FileMaker databases via ODBC and JDBC

Using ODBC and JDBC with FileMaker Server > Sharing FileMaker databases via ODBC and JDBC

Note The following information is for server administrators.

You can use FileMaker Server to host a FileMaker database file as a data source, sharing your data with other applications using ODBC and JDBC. FileMaker Server allows up to 50 connections and supports local access (same computer) and remote access (both for middleware such as web servers, and for remote client access from desktop productivity applications).

To share a hosted FileMaker Pro database via ODBC and JDBC:

1. In FileMaker Pro, open the database and edit the privilege set for the accounts that will access the database. Enable the extended privilege Access via ODBC/JDBC. See FileMaker Pro Help.

Note If your FileMaker database solution uses more than one FileMaker database file, all of the database files must use this privilege set with the extended privilege Access via ODBC/JDBC enabled.

2. In FileMaker Server Admin Console, click the General Settings > ODBC/JDBC tab and select Enable ODBC/JDBC.

3. Upload the database file. See Hosting databases.

Note If your FileMaker solution uses more than one FileMaker database file, all of the database files must be hosted on the same FileMaker Server deployment.

4. On each client computer that needs to access the hosted database, install and configure the FileMaker ODBC or JDBC client driver.

See FileMaker ODBC and JDBC Guide.