Chapter 13. ODBC/JDBC Import and Export
ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) are application interfaces that give all databases that support itwhich is most of the databases in use todaya common "language" for record sharing. FileMaker users with access to large corporate databases like Oracle can use ODBC or JDBC to access data. ODBC is also the method for importing database information from Microsoft Access. If you are using the Windows platform, information can go in the other direction, too. With ODBC as the translator, you can send FileMaker information directly to Microsoft Office applications, or make your FileMaker databases available to corporate and Web databases.That's a good thing, because setting up most ODBC-compliant databases is considerably more difficult than setting up a FileMaker database, and often requires the services of a specialized programmer. It would be next to useless if it also required a programmer to mine information from the database once it's up and running. Fortunately, there's SQL (Structured Query Language)a language designed to make that task a lot easier. FileMaker supports SQL, and helps you set up queries designed to extract very specific pieces of information from complex database files.
