FileMaker 13 ODBC and JDBC Guide Print

  • 0

A helpful guide for using ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) with FileMaker 13. Below is a summary of the contents of this document. Click the link to download.

https://my.oditech.com/downloads/FileMaker/13/fm13_odbc_jdbc_guide.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 13
  • 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 (OS X)
  • Networking requirements
  • ODBC client driver architecture overview
  • ODBC client driver installation (Windows)
  • Configuring client drivers (Windows)
  • Opening the ODBC administrator (Windows)
  • Configuring the DSN (Windows)
  • ODBC client driver installation (OS X)
  • Configuring client drivers (OS X)
  • 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)
  • Changing an existing ODBC client driver (Windows)
  • Verifying access via ODBC (Windows)
  • Accessing a FileMaker database file from an OS X application
  • Specifying ODBC client driver properties for a FileMaker DSN (OS X)
  • Changing an existing ODBC client driver (OS X)
  • Verifying access via ODBC (OS X)

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 28 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 - Reference Information

  • ODBC Catalog functions
  • JDBC Meta Data functions
  • Mapping FileMaker fields to ODBC data types
  • Mapping FileMaker fields to JDBC data types
  • Data types in 64-bit applications
  • ODBC and JDBC error messages
  • ODBC error messages
  • JDBC error messages

Was this answer helpful?

« Back