Create live connections to Microsoft® SQL Server, Oracle and MySQL with ease!
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.
Learn more about this feature, including case examples and technical information.
Learn about the advantages of using External SQL Data Sources with FileMaker Server 9.
1Must be connected to the SQL database via a LAN/WAN.
Great New Features
Quick Start Screen Conditional Formatting External SQL Data Script Grouping & Editing Enhanced Layout Objects Get Started Quickly Gather Your Information Instantly Access Information Report & Communicate Powerful Development Tools Network Security & Sharing Connect with the Web
FileMaker Pro 9 is a
Universal Application
FileMaker Pro 9 works
with
Windows Vista
