Chapter 21. Connecting to External SQL Data Sources

In this chapter

ODBC Basics

Setting Up FileMaker Databases for ODBC

Setting Up and Administering ODBC

Importing ODBC Data into FileMaker

Using External ODBC Data Sources with the Relationships Graph

Troubleshooting

ODBC Basics

Initially developed by Microsoft in 1991 as Open Database Connectivity interface, ODBC provides a way of accessing ODBC-compliant databases without knowing anything about the internal workings of the database. ODBC is an API that you can call from a variety of programming languages on a variety of operating systems. JDBC is a set of Java classes that allows access to ODBC database. (Sometimes the two concepts are referred to as xDBC.)

SQL

FileMaker’s ODBC implementations ...

Get Special Edition Using FileMaker 9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial