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.
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.
The JDBC Plugin supports more than just reading from an SQL database. You can call
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.
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.
Subscribe to our RSS feed for product update news!
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 (PowerPC and Intel) as well as on Windows.
Our plugins take advantage of the plugin features of FileMaker 7 and later, such as attaching styles to text, and are compatible with the most recent version, FileMaker 13. In addition, the Mac versions of all of our plugins ship as universal binaries, and will run at full speed on both PowerPC and Intel Macs.
|Mac OS X 10.5 or
later on PPC
|Mac OS X 10.5 or
later on Intel
|Windows XP or later|
|FileMaker 4-6||FileMaker Pro 7 or later required|
|FileMaker Pro 7||X||Won't run in Rosetta||X|
|FileMaker Pro 8||X||Won't run in Rosetta||X|
|FileMaker Pro 8.5||X||X||X|
|FileMaker Pro 9||X||X||X|
|FileMaker Pro 10||X||X||X|
|FileMaker Pro 11||X||X||X|
|FileMaker Pro 12||X||X||X|
|FileMaker Pro 13||X||X||X|
|FileMaker Server 7 Advanced||X||X||X|
|FileMaker Server 8.0v4 Advanced||See note below||See note below||X|
|FileMaker Server 9 Advanced||X||X||X|
|FileMaker Server 9||X||X||X|
|FileMaker Server 10||X||X||X|
|FileMaker Server 10 Advanced||X||X||X|
|FileMaker Server 11||X||X||X|
|FileMaker Server 11 Advanced||X||X||X|
|FileMaker Server 12||X||X||X|
|FileMaker Server 12 Advanced||X||X||X|
|FileMaker Server 13||X||X||See note below|
FileMaker Server 13 and Windows: Windows 8 and Server 2012 are not compatible at this time with server side scheduled scripts and the Perform Script on Server feature of FileMaker 13.
FileMaker Server Advanced 8.0v4: Unfortunately, a bug in FileMaker Server Advanced 8.0v4 disables all plugins in the Web Publishing Engine on OS X. This affects all plugins, not just ones from 360Works. FileMaker, Inc. is aware of this bug.
Rosetta: Rosetta is not supported. If you are running FileMaker 7 or 8 on an Intel Macintosh, we strongly recommend upgrading to FileMaker 8.5 or later; the speed and stability improvements are very significant.
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). 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.
If you're using FileMaker Server 9 or later, our plugins are compatible with the FileMaker Server scheduled script feature.
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