Access any JDBC-compatible database from your FileMaker solution

 

Current Version: 1.5: What's New?

Pricing & Licensing Options	View the plugin documentation

The 360Works JDBC plugin 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.

Advantages over ODBC

• 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.

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.

We never charge for switching / cross-grading, because the plugin package that we give you includes both Windows and Mac versions, and the same license keys work on both. One less thing to worry about!

Our plugins take advantage of the new plugin features of version 7, such as attaching styles to text. In addition, the Mac versions of all of our plugins ship as universal binaries, and will run wonderfully on the new 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 Server Advanced 7	X	X	X
FileMaker Server Advanced 8.0v4	See note below	See note below	X
FileMaker Server Advanced 9	X	X	X
FileMaker Server 9	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 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, our plugins are compatible with the new FileMaker Server 9 scheduled script feature.

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.

 

Pricing & Licensing Options	View the plugin documentation