Steps
1. enable ODBC/JDBC on the filemaker server
1.1 open port 2399 on FileMaker Server
2. enable ODBC/JDBC in the file [filename], extended privilege Access via ODBC/JDBC (fmxdbc) – for user [username] / [password]
3. download filemaker pro dmg / zip – jdbc / odbc driver – https://support.claris.com/s/article/Software-Update-FileMaker-xDBC-client-drivers-for-FileMaker-1503692806454?language=en_US
3.1 manual – https://help.claris.com/en/odbc-jdbc-guide.pdf
3.2 move JDBC Client Driver to /Library/JDBC Client Driver/fmjdbc.jar
4. download dbeaver – https://dbeaver.io/download/
5. configure dbeaver driver
5.1 database / driver manager / new
5.2 driver name : filemaker
5.3 class name : com.filemaker.jdbc.Driver
5.4 driver type : Generic
5.5 libraries / add file : where you put fmjdbc.jar ie: /Library/JDBC Client Driver/fmjdbc.jar
5.6 Find Class button = com.filemaker.jdbc.Driver
6. configure dbeaver connection
6.1 new connection – filemaker
6.2 enter jdbc url – jdbc:filemaker://[hostname]/[filename].fmp12, example jdbc:filemaker://marion.neocodesoftware.com/nc_contacts.fmp12
6.3 enter [username] / [password]
6.4 test connection
6.5 finish
