In macOS, you must use a 64-bit ODBC client driver. Note In Windows, if you're using the 32-bit version of FileMaker Pro Advanced, you must use a 32-bit ODBC client driver if you're using the 64-bit version of FileMaker Pro Advanced, you must use a 64-bit ODBC client driver. For an overview of the various ways of working with ODBC data sources, see Using ODBC and JDBC with FileMaker Pro Advanced. For information about the supported external SQL data sources, search the FileMaker Knowledge Base. If you are importing ODBC data or are using the Import Records or the Execute SQL script step, you can use additional data sources. Data sources supported in FileMaker Pro AdvancedĪs an ODBC client application, FileMaker supports external SQL data sources such as Oracle, Microsoft SQL Server, and MySQL Community Edition as ODBC tables in the relationships graph. Additionally, data source configuration can vary from one ODBC driver manufacturer to another. The way you interact with the data source, provide a password, and perform and display query results varies with each application's client driver.

For example, if you will be accessing records from an Oracle database, you will configure an Oracle client driver. Whether you are importing ODBC data or working with ODBC tables in the relationships graph, as a client application, you must configure a driver for the ODBC data source you're using.

Filemaker pro windows