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. For example, if you will be accessing records from an Oracle database, you will configure an Oracle client driver.
![]()
The way you interact with the data source, provide a password, and perform and display query results varies with each applicationâs client driver. Additionally, data source configuration can vary from one ODBC driver manufacturer to another.
Data sources supported in FileMaker Pro Advanced
Please check with the application provider (Microsoft, Oracle, etc) for these drivers. On the Mac, ODBC client drivers are typically provided via 3rd-party providers. On Linux, ODBC drivers are available through the FileMaker Cloud Admin Console. Documentation and Notes. FileMaker ODBC and JDBC Guide; See all FileMaker 18 product documentation.
As 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. If you are importing ODBC data or are using the Import Records or the Execute SQL script step, you can use additional data sources. For information about the supported external SQL data sources, search the FileMaker Knowledge Base. For an overview of the various ways of working with ODBC data sources, see Using ODBC and JDBC with FileMaker Pro Advanced.
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. In macOS, you must use a 64-bit ODBC client driver.
Use the following procedure as a general guideline for configuring data sources (refer to the documentation that accompanies each data source application for details).
Windows
1. Start the ODBC Data Source Administrator.
In Control Panel, choose System and Security > Administrative Tools. Then do one of the following:
â¢32-bit Windows: Open Data Sources (ODBC).
Download full version mac os. â¢64-bit Windows:
![]()
4. Choose the driver for the data source youâll be accessing with FileMaker Pro Advanced, then click Finish.
A setup dialog box appears.
5. For Name, enter descriptive text to identify the data source.
Many drivers also offer options to customize how you access a data source, such as identifying a particular data source file. Enter descriptive text, if desired.
6. Click Finish.
7. Click OK to save your data source information.
macOS
1. Install the ODBC Manager from Actual Technologies, available at www.odbcmanager.net.
Filemaker 18 Odbc DriverNote ODBC Manager is a freeware product not supported by FileMaker.2. Launch the ODBC Manager utility.3. Click the System DSN tab (or, for ODBC imports, click either the System DSN tab or the User DSN tab).Important Only System DSNs are supported when you are working with ODBC tables in the relationships graph.If your data source appears in the list, the driver is already configured. You can skip the remaining steps and begin accessing ODBC data, or choose your data source and click Configure to modify how youâll interact with the data source.A System DSN (data source name) is available to all users who log in to your computer. A User DSN is available only when you log in.4. Click Add to configure a driver for your data source.If no driver appears for the data source you want to use, you can use a driver from a third-party vendor.
To install a new driver, use the driverâs installation program.
5. Choose the driver for the data source youâll be accessing with FileMaker Pro Advanced, then click OK.
6. In the configuration dialog box, click Continue. Eve online load fitting.
7. For Name, enter descriptive text to identify the data source.
Many drivers also offer options to customize how you access a data source, such as identifying a particular data source file. Enter descriptive text, if desired.
Filemaker Odbc Sql
8. Click Finish.
Filemaker Odbc Setup
9. Click Done to save your data source information.
After you have configured the driver, you can access records in your data source. See Connecting to external data sources and Querying an ODBC data source from FileMaker Pro Advanced.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |