FileMaker 12 Compatible

FileMaker plugin icon The 360Works JDBC plugin for FileMaker Pro 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.

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)

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.

JDBC being used

One of my client's solutions requires that I query for one record at a time from a PostgreSQL database. I was unable to take advantage of FileMaker's built-in ESS functionality because PostgreSQL is unsupported by ESS. My initial solution for importing the SQL data was to perform ODBC imports using FileMaker's built-in import functionality. Each import took nearly six seconds because FileMaker connects and disconnects for each import/query.

I then discovered 360Works' JDBC plugin and found that using the plugin to perform my queries cut the time down to .04 seconds each.

To be clear, processing a batch of, say, 100 records now takes about 4 seconds rather than the 9½ minutes it took using FileMaker's built-in functionality. This brings us tremendous processing power when the SQL matches can now be triggered upon data entry without the user ever even noticing.

- Regards, Howard Schlossberg

Subscribe to our If you're a FileMaker developer or FileMaker consultant, subscribe to our RSS feed for informative articles and product updates. RSS feed for product update news!


Questions and Answers

Will it run on Windows/Mac? What version of FileMaker is required?

Yes, all of our plugins are designed to run on Mac OS X (10.6+) as well as on Windows (XP+ or Server 2003+).

Mac OS X 10.6 or
earlier
Mac OS X 10.6 or
later
Windows XP or later
FileMaker 4-10 FileMaker Pro 11 or later required
FileMaker Pro 11 - 13 X X X
FileMaker Server 11-13 X X X

What about Web Publishing and FileMaker Server?

If you purchase the Enterprise License (see below), then you will be able to use the plugin with the FileMaker Web Publishing Engine. This means that when you use our plugins in your FileMaker scripts, they will work the same way with Instant Web Publishing (IWP) or WebDirect. It also means that your Custom Web Publishing applications (with XSLT, PHP, or any other web technology) can call FileMaker scripts that use our plugins.

Can I use this plugin with my FileMaker runtime solution?

Yes, all of our plugins work in FileMaker runtimes solutions, just copy the plugin to the runtime's Extensions folder.

What kind of licenses are there?

Most of our plugins are available in 3 licenses: a demo version which works for 2 hours every time you launch FileMaker, a Workgroup license for 10 or fewer users, and an Enterprise license for unlimited users within a single organization.

What about FileMaker Go?

If you'd like to add plug-in functionality to a mobile solution, there are a number of options available. Plug-ins cannot be installed directly on a iPhone or iPad, but you can trigger a script on a machine that does have the plug-in installed. Using FileMaker Server, you can have routine scripts that will process all the outstanding function calls. For an example on how to do this, see this article on accomplishing this with Plastic. Alternatively you could integrate RemoteScripter to trigger server side scripts. Finally, FMRPC is a separate product developed as a collaboration between Skeleton Key and 360Works.

There are more Questions and Answers on our product support site.


Purchase the Portfolio Bundle to obtain an Enterprise license of this product which allows for unlimited users within a single organization.

Copyright © 2006-2014 Prometheus Systems Consulting d/b/a 360Works. All rights reserved.
Toll Free (866) 662-9185

Platinum member of the FileMaker Business Alliance