Ease-of-use breakthroughs include Quick Start Screen, Conditional Formatting, easy connections to SQL data.
Watch introduction movie: Click
Watch the SQL Connectivity Movie: Click
Do-it-yourself SQL reporting.
Have you ever wished that you could access information stored in MS SQL Server, Oracle and MySQL? Now you can! During a fast one-time setup, you add a SQL table or view to the FileMaker Relationship Graph and from that point on you have a live connection to the external SQL data source.1 Then, create custom reports and solutions using all your familiar FileMaker Pro tools.
Create solutions that include SQL data
No longer do you need high-end programming skills to add SQL data to FileMaker Pro solutions. Now anyone can extend FileMaker Pro solutions to include information located in SQL systems – all without needing to know any programming languages or how to write SQL queries. You can create new information by adding supplemental calculation and summary fields to the SQL table in FileMaker. Run finds, sorts, and exports on the table. Even use the values in scripts. It's easy because it is
FileMaker Pro.
FileMaker Pro gives you the tools you need to do all sorts of useful things with data from an external SQL data source, multiple external SQL data sources, or FileMaker Pro and external SQL data source(s). Use SQL information to create name badges or shipping labels. Track requisitions and purchase orders. Develop a visual catalog of inventory and assets. Everything that FileMaker Pro can do – now you can do with data from SQL.
Enable knowledge workers to use SQL data - safely
If you are an administrator for a SQL database, you know the constant demand for ad-hoc data pulls and custom solutions. Simply provide the knowledge workers in your organization with access to your SQL views or tables. FileMaker Pro utilizes standard system-level DSNs and you decide what level of access to provide (read only or read/write). Then they’ll be off reporting and creating solutions to their heart’s content and you’ll be free to work on other projects. Or use FileMaker Pro yourself and enjoy a dream environment for Rapid Application Development and deployment.
Based on future-proof open ODBC standards
FileMaker Pro’s External Data Source feature was built with future expansion in mind. The initial release is certified to work with the following popular SQL databases:
MS SQL Server 2000
MS SQL Server 2005
Oracle 9g
Oracle 10g
MySQL 5.0 Community Edition (free)
The External Data Source feature also allows you to connect to remote FileMaker Pro databases, creating a “one source” tool for bringing all your critical data together.