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.
What version of FileMaker is required? Will it run on Windows/Mac?
360Works plugins are compatible with the FileMaker 14 platform and higher.
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. Please reference the FileMaker Pro operating system requirements for all versions.
Are 360Works plugins compatible with FileMaker Cloud?
Yes, but only for the most recent version of the plugin. For non-plugin products such as MirrorSync and Zulu, MirrorSync is compatible with FileMaker Cloud, but Zulu is not.
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 runtime 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.