https://my.oditech.com/downloads/FileMaker/11/fm11_odbc_jdbc_guide_en.pdf
Chapter 1 - Introduction
- About this guide
- About ODBC and JDBC
- Using FileMaker software as an ODBC client application
- Importing ODBC data
- Adding ODBC tables to the relationships graph
- Using a FileMaker database as a data source
- Accessing a hosted FileMaker Pro database
- Limitations with third-party tools
- Networking requirements
- Updating files from previous versions
- Installing current drivers
Chapter 2 - Accessing external SQL data sources
- Importing ODBC data
- Executing SQL to interact with data sources via ODBC
- Working with ODBC tables in the relationships graph
- Data sources supported in FileMaker 11
- Adding ODBC tables to the relationships graph
Chapter 3 - Installing FileMaker ODBC client drivers
- Hardware and software requirements
- ODBC client driver requirements (Windows)
- ODBC client driver requirements (Mac OS)
- Networking requirements
- ODBC client driver installation (Windows)
- Configuring client drivers (Windows)
- ODBC client driver installation (Mac OS)
- Configuring client drivers (Mac OS)
- Where to go from here
Chapter 4 - Using ODBC to share FileMaker data
- About ODBC
- Using the ODBC client driver
- Overview of accessing a FileMaker database file
- Accessing a FileMaker database file from a Windows application
- Specifying ODBC client driver properties for a FileMaker DSN (Windows)
- Verifying access via ODBC (Windows)
- Accessing a FileMaker database file from a Mac OS application
- Specifying ODBC client driver properties for a FileMaker DSN (Mac OS)
- Verifying access via ODBC (Mac OS)
Chapter 5 - Installing FileMaker JDBC client drivers
- Software requirements
- Networking requirements
- JDBC client driver installation
- Using the JDBC client driver
Chapter 6 - Using JDBC to share FileMaker data
- About JDBC
- Using the JDBC client driver
- About the JDBC client driver
- Using a JDBC URL to connect to your database
- Specifying driver properties in the URL subname
- Solutions with multiple FileMaker database files
- Verifying access via JDBC
Chapter 7 - Supported standards
- Support for Unicode characters
- SQL statements
- SELECT statement
- SQL clauses
- FROM clause
- WHERE clause
- GROUP BY clause HAVING clause
- UNION operator
- ORDER BY clause
- FOR UPDATE clause
- DELETE statement
- INSERT statement
- UPDATE statement
- CREATE TABLE statement
- ALTER TABLE statement
- CREATE INDEX statement
- DROP INDEX statement
- SQL aggregate functions
- SQL expressions
- Field names
- Constants
- Exponential/scientific notation
- Numeric operators
- Character operators
- Date operators
- Relational operators
- Logical operators
- Functions
- Functions that return character strings
- Functions that return numbers
- Functions that return dates
- Operator precedence
- ODBC Catalog functions
- JDBC Meta Data functions
- Reserved SQL keywords
Chapter 8 - Reference Information
- Mapping FileMaker fields to ODBC data types
- Mapping FileMaker fields to JDBC data types
- ODBC and JDBC error messages
- ODBC error messages
- JDBC error messages
