O'Reilly logo

FileMaker by Jesse Feiler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21. Connecting to External SQL Data Sources

ODBC Basics

Initially developed by Microsoft in 1991 as Open Database Connectivity interface, ODBC provides a way of accessing ODBC-compliant databases without your 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 convert internal FileMaker concepts to SQL both when sending and receiving data. You never see the SQL, but it is there, making the connections work. SQL is sometimes considered ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required