We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Software Reviews
15,669 Reviews

FileMaker Pro 9.0

£219 inc VAT

Manufacturer: FileMaker

Our Rating: We rate this 4 out of 5

Serious FileMaker developers, database and network admins, and managers who worry about tying different piles of company data together are going to be the big beneficiaries of major improvements in the latest update to the FileMaker family of products.

Serious FileMaker developers, database and network admins, and managers who worry about tying different piles of company data together are going to be the big beneficiaries of major improvements in the latest update to the FileMaker family of products.

If you don't fall into that category - and a lot of FileMaker users do not -don't feel neglected. There are a number of nice things in FileMaker Pro 9.0 itself for solitary or small-workgroup users, too.

Here's an overview of the major features and enhancements introduced in the FileMaker Pro 9.0 overhaul announced last week.

Se habla SQL

The big news with this release of the venerable database program is that FileMaker Pro 9.0 now supports live two-way connections to SQL databases. For years, it has been possible to use FileMaker to query an SQL database and get a copy of the resulting data set (say, customers in a certain zip code). But this old support for access to SQL databases was hard to use, didn't provide live access to data, and - as a practical matter - just didn't work very well, especially on a Mac. That's all changed with FileMaker Pro 9.0.

There are many specific implementations such as Oracle and MySQL, but generically speaking, SQL (pronounced ess-kew-ell or sequel, depending on who you ask) is a standard for heavy-duty databases used in big corporations, universities, research, and on the web - anywhere there is a lot of data to store and many people need to access it.

The medical records database in a hospital is almost certainly powered by SQL; so are your company's human resources and payroll databases, the databases used by your bank and credit card companies, the inventory system used by the grocery store down the street, and your local library's holdings catalogue, just to offer a few examples. Until now, your little FileMaker database was almost completely locked out of these data collections. To that end, using FileMaker was a bit like having mobile phone service with a great company that made easy-to-use phones and offered low prices, but wouldn't let you have a conversation with anybody whose service was provided by a different company.

Of course, you could have used SQL to build your database in the first place. But gosh, who wants to do that? Developing SQL databases usually involves dealing with a lot of nasty technicalities - or to put it plainly, SQL is pretty geeky. That makes it almost the antithesis of FileMaker Pro, whose geekiness-to-power ratio is the lowest in the database industry.

FileMaker Pro 9.0 hasn't made SQL itself any less geeky; it just makes it possible for FileMaker developers not to give a damn. You can now add a major dimension to your FileMaker projects by connecting to SQL databases that were developed and set up by somebody else, so you don't need to know much about SQL at all.

The key to this trick is the data source reference. One of the revolutionary features that appeared in FileMaker 7.0 was the ability to create in one FileMaker database file a reference to another file, and then to use the referenced data as if it were actually stored in the current file. Every FileMaker solution we've built since FileMaker 7.0 appeared consists of two files: a data file that contains nothing but a client's data and a user-interface file, which contains all of the layouts and scripts, the stuff that users actually see. The user-interface file doesn't actually store any data at all.

Well, with FileMaker Pro 9.0, you can now reference and use an SQL data source in the very same way that you might reference and use another FileMaker file. If you can see the SQL data source in the simple find data source dialog, all you have to do is select it, authenticate, and you're in. After that, although the data is actually stored in the SQL database, you can interact with it in your FileMaker Pro 9.0 database - seeing live data that updates automatically, editing data and having it written back to the SQL database so that other users accessing the same data with other interfaces will see the changes you've made. If you have the correct access privileges, you will even be able to create or delete records.

FileMaker Pro 9.0 Expert Verdict »

Windows XP Professional, Home Edition (SP 2): Pentium III 500MHz or higher
256MB of RAM
CD-ROM drive
SVGA (800 x 600) or higher resolution video adapter and display. Windows Vista Ultimate, Business, Home: 800MHz 32bit (x86) or higher
512MB of RAM
SVGA (800x600) or higher resolution video adaptor and display
CD-ROM drive. Mac OS X 10.4.8: PowerPC G3, G4, G5 or Intel-based Mac
256MB of RAM
CD-ROM drive
  • Ease of Use: We give this item 9 of 10 for ease of use
  • Features: We give this item 8 of 10 for features
  • Value for Money: We give this item 8 of 10 for value for money
  • Overall: We give this item 8 of 10 overall

FileMaker Pro 9.0 looks like an impressive upgrade. The product is moving in the direction that power users have been hoping for, and in the long run, this is going to benefit everybody who uses the application.

  • FileMaker Pro 8.5

    FileMaker Pro 8.5

    Pro's ease of use and cross-platform nature seem to have put its rivals out of the running. A new version would need some seriously useful tools to make upgrading worthwhile.

  • FileMaker Pro 11 review

    FileMaker Pro 11

    FileMaker Pro 11, the latest update of the venerable database software, improves on version 10 with several more features such as charting, "recurring import" to automatically update a database from an Excel or text file and a "Quick Find" search box.

  • FileMaker Pro 8.0 Beta

    FileMaker Pro 8.0 Beta

    FileMaker Pro, the easiest fully fledged database program PC Advisor has seen, made a great leap forward with its last release, adding relational capabilities. So what are the developers doing for an encore with FileMaker Pro 8.0?

  • FileMaker Pro 10 review

    FileMaker Pro 10

    FileMaker Pro 10's ease of use and powerful features make it the database application of choice for home-office and small-business users.

  • OpenOffice.org 2.0 Beta

    If you're thrifty and you use an office suite, it's hard not to like OpenOffice.org. Version 1.0 does most things Microsoft Office can do. And it's free. So what's to improve?

IDG UK Sites

Windows 10 release date, price, features UK: Staggered release with PCs coming first this summer -...

IDG UK Sites

In defence of BlackBerrys

IDG UK Sites

Why we should reserve judgement on Apple ditching Helvetica in OS X/iOS for the Apple Watch's San...

IDG UK Sites

MacBook Pro 15in preview: better battery life, faster storage and a new discrete graphics chip may...