Using ODBC and JDBC with FileMaker Pro
• a data source, sharing your database files with other applications on the same computer 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. See “FileMaker Pro as a data source,” below.
• an ODBC client application, interacting with data sources on the same computer or over a network. For example, you can import data from an Oracle data source into FileMaker Pro, or you can work with an Oracle data source interactively in the relationships graph and in layouts. See “FileMaker Pro as an ODBC client application,” below.FileMaker Pro includes all the software you need to share your database as a data source via ODBC and JDBC, including the client drivers you use to access your database from other applications. To share your FileMaker database file as a data source over a network, use FileMaker Server.See Sharing FileMaker Pro data via ODBC or JDBC for information about enabling a database file for sharing.For instructions on installing FileMaker ODBC client drivers, see FileMaker ODBC and JDBC Guide. For details about supported SQL statements, expressions, and Catalog functions, see FileMaker SQL Reference and FileMaker ODBC and JDBC Guide.When you use FileMaker Pro as a client application, you must install and configure drivers for the ODBC data source you’re accessing. For example, to access data from an Oracle database using ODBC, you must install and configure an Oracle ODBC client driver. Third-party drivers are available from a number of vendors. For more information, see Configuring an ODBC client driver.See Accessing external data sources for information about:
•
•
FileMaker ODBC and JDBC Guide and FileMaker SQL Reference 2. One-time, static via ODBC import (or File menu > Open), also Import Records script step and Execute SQL script step
A collection of data, similar to a table in a FileMaker Pro database file An attribute in a table, similar to a field in a FileMaker Pro database file A set of cells in a table, similar to a record in a FileMaker Pro database file
•