KB181002606: Automation Engine - How to configure a database connection to Filemaker Pro

Description

How to configure a database connection from external database to Filemaker Pro with JDBC?

Procedure

Follow the steps given below to configure the connection:

1. Download the Filemaker Pro JDBC driver and documentation for your version using the following link:

   http://help.filemaker.com/app/answers/detail/a_id/12921/~/software-update%3A-filemaker-xdbc-client-drivers-for-filemaker

2. Copy the jar file to bg_data_custom_v010:[dat.dbase].

3. Open Automation Engine Pilot and go to Tools > Configure.

4. Select External Databases and go to File > New.

   

5. Select Other in DBMS Type.

6. Enter com.filemaker.jdbc.Driver in Driver.

7. In Driver File, select the path where jar file is copied, it must be in a container! If there are spaces in the filename, represent them with %20

   file://computername/bg_data_custom_v010/dat/dbase/fmjdbc.jar

8. Enter jdbc:filemaker://192.168.1.1/databasename in Database URL, including the file extension

9. you can specify a username and a password if needed.

   URL: jdbc:filemaker://192.168.1.1/databasename?user=admin&password=1234

10. Click Test Connection to see if connection is successful.

    1. Port 2399 must be in the firewall exception list on the Filemaker Server or you may receive an error "Failed to connect to listener".