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.
VersionWhat's New?
Own a license?
Download
current version.
Learn more about our
Portfolio License bundle!
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.
Need help setting up one of our products?
We are experts in FileMaker, Java, and Amazon Web Services. If you need a customized plug-in, modifications to an existing plug-in, or full plug-in/web app integration services, we can perform these services for you. Please fill out our Quick Form and we will contact you to discuss your solution needs and create an estimate.Advantages Over ODBC
Advantages | |
---|---|
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) |
System Requirements
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
Windows environments.