|
Customer Login |
|
|
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 360 Works' 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!
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 (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 12. 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.4 or later on PPC |
Mac OS X 10.4 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 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 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.
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-2013 Prometheus Systems Consulting d/b/a 360Works. All rights reserved.
Toll Free (866) 662-9185
