The FileMaker client can accept xDBC connections only from client applications running locally (on the same computer). FileMaker Server Advanced permits xDBC connections from remote computers.The client version of FileMaker can support no more than 5. FileMaker Server Advanced can support up to 50 simultaneous xDBC connections.There are two differences between these methods:
Filemaker database for mac pro#
An individual copy of FileMaker Pro or FileMaker Pro Advanced can also be configured to provide local xDBC access to any files hosted by the client. FileMaker Server Advanced can be configured to provide xDBC access to hosted files. Its possible to grant xDBC access to FileMaker data in a couple of ways. Well refer to the two technologies together as xDBC from time to time for convenience.įor more information on importing data into FileMaker via ODBC, see "Importing from an ODBC Data Source," 584. JDBC (often taken to stand for Java Database Connectivity) provides standardized database access for Java-based applications. ODBC (Open Database Connectivity) is an open standard for accessing databases from various client applications. Its also possible to pull data out of FileMaker from the outside, using the ODBC or JDBC technologies. So far, the techniques detailed in this chapter have involved pushing data out of FileMaker into static export files.
Filemaker database for mac mac#
Configuration of ODBC/JDBC connectivity is similar on the Mac OS. Configuring ODBC/JDBC connectivity is a matter of clicking a single check box. Its necessary to use FileMaker Server Advanced to provide ODBC/JDBC connectivity to remote computers. Configuring FileMaker Server Advanced for xDBC Access.After youve specified a query, the Microsoft Query Wizard lets you decide where to put the resulting data. The Microsoft Excel Query Wizard may (temporarily) spare you from having to write any SQL. To access FileMaker data via ODBC, youll need to choose an appropriate data source. Using Microsoft Excel as a Local Access ODBC Client.The iODBC Data Source Administrator gives you a useful Test button.
Filemaker database for mac driver#
Youll need to set several driver keywords manually when creating a DSN for the Mac OS. Youll need to do a little extra driver configuration on the Mac OS.
The new DSN will need several settings configured. Its necessary to create a DSN to access data via ODBC. On Windows, ODBC settings are configured via the ODBC Data Source Administrator.