


To streamline this solution, use the CData ODBC driver, as FileMaker Pro supports ODBC natively, but it does not support JDBC. There are two data access modes in FileMaker Pro:ĭata Import: Google Analytics data is copied into a FileMaker Pro database and can be refreshed on demand. The CData JDBC Driver for Google Analytics implements both the JDBC and MySQL standards to integrate with applications like FileMaker Pro that support connections to traditional databases like MySQL but not generic JDBC connections. You will use the MySQL Remoting feature to access Google Analytics as a remote MySQL database. This article shows how to use the CData JDBC Driver for Google Analytics to integrate with the External SQL Sources (ESS) feature in FileMaker Pro, which allows you to link records in FileMaker Pro with related records in your other operational data stores.
