Allows execution of arbitrary SQL statements on one or more JDBC databases, iterating result sets, and importing from any database which supports the JDBC protocol.
Access JDBC-compatible databases from FileMaker
If you have an external SQL database which you need to integrate with your FileMaker solution, try out our JDBC plugin. It even works with Filemaker runtime solutions. You do not need to know anything about Java to use JDBC with FileMaker - we do all of that in the plugin.
More SQL Database Integration in FileMaker
The JDBC Plugin supports more than just reading from an SQL database. You can call INSERT, UPDATE, and DELETE commands as well. An interesting idea for using the JDBC plugin is to create a calculation field which calls an UPDATE statement, passing in several fields from your FileMaker table. Any time these fields are triggered, the calculation will be fired, and the executeSQL function will be invoked, passing in your new value to the database! No scripts are required for this to work.
Advantages Over ODBC
|Supports reading and writing container/BLOB data to other databases|
|Does not require the initial setup on a per-client basis that ODBC necessitates, all you need is the location of a JDBC driver|
|Embed the JDBC driver .jar directly into a container field, or load it from a URL|
|Access result data directly from scripting engine, or via data import (ODBC only supports import)|
All of our plugins are designed to run on Mac and on Windows.
All system requirements are the same as those of FileMaker.
As long as you meet FileMaker's minimum requirements, you can run our plugins in your Mac or