Deciding how to work with ODBC and JDBC in FileMaker Pro See the next section for an overview of using FileMaker Pro as a data source or as a client. See Querying an ODBC data source from FileMaker Pro. Importing ODBC data in batch operations by writing SQL queries. Working with ODBC data sources interactively, in real time, in the relationships graph and in layouts. See Accessing external data sources for information about: Note ODBC data sources are also referred to as external SQL sources (ESS). For more information, see Configuring an ODBC client driver. Third-party drivers are available from a number of vendors. For example, to access data from an Oracle database using ODBC, you must install and configure an Oracle ODBC client driver. When you use FileMaker Pro as a client application, you must install and configure drivers for the ODBC data source you’re accessing. FileMaker Pro as an ODBC client application For details about supported SQL statements, expressions, and Catalog functions, see FileMaker SQL Reference and FileMaker ODBC and JDBC Guide. See Sharing FileMaker Pro data via ODBC or JDBC (FileMaker Pro only) for information about enabling a database file for sharing.įor instructions on installing FileMaker ODBC client drivers, see FileMaker ODBC and JDBC Guide. To share your FileMaker database file as a data source over a network, use FileMaker Server files shared by FileMaker Pro or FileMaker Cloud cannot be accessed as data sources over a network. FileMaker Pro as a data source (FileMaker Pro only)įileMaker 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. Note You can use Claris Pro as an ODBC client application but not as an ODBC/JDBC data source. See "FileMaker Pro as an ODBC client application," below. 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 a data source," below.Īn ODBC client application, interacting with data sources on the same computer or over a network. For example, you can create charts, analyze numbers, and generate reports using FileMaker Pro data in other applications. A data source, sharing your database files with other applications on the same computer using ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity).
0 kommentar(er)
