21. Connecting to External SQL Data Sources
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 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 the ODBC database. (Sometimes the two concepts are referred to collectively as xDBC.)
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 an acronym for Structured ...