Access Filemaker Database via Matlab (Mac OS X)

Hi,

since I'm on the mac platform I got a few problems using ODBC/JDBC data-connections and hope one of you might help me, which will be greatly appreciated!

1. I created a new database in Filemaker 11 pro, activated the sharing via JDBC function and assigned a user with write/read access to the database
2. I installed the jdbc as told by filemaker by copying the file 'fmjdbc.jar' to library/java/extensions/
3. Next I copied the file as well into the java directory to /Applications/MATLAB_R2011a.app/java/jar/
4. I added the file in the classpath file in /Applications/MATLAB_R2011a.app/toolboxes/local as well

Now I should be good to go, right? So I tried to establish the connection via the following code, but was not able to succeed:

filemaker = database('database','user','password','/Applications/MATLAB_R2011a.app/java/jar/fmjdbc.jar','/Users/leon/Documents/database.fp7')

Can somebody help me please?

Answer 1

[Theresa]

I don't know if you figured this out yet, but just in case - I was trying to figure out the same thing and ran into your question. I managed to get it working, so I thought I would post a reply.

Here's what I did:

1. Installed FMP 11 and copied the "fmjdbc.jar" file to library/java/extensions

2. Added the library/java/extensions path to classpath.txt in Matlab

3. Restart computer and Matlab.

4. Set up your data source

>> confds

In that dialog, you will define your jdbc data source create a file or use a file that is somewhere in your Matlab path

Name: is the name of your database file

Driver: com.filemaker.jdbc.Driver

URL: jdbc:filemaker://localhost/databasefilename

Test - the default user for FMP11 is Admin and the default password is blank

5. >> setdbprefs('JDBCDataSourceFile', 'nameoffilefromconfds')

6. Then you should be able to run:

>> filemaker = database('database', 'user', 'password', 'com.filemaker.jdbc.Driver', 'jdbc:filemaker://localhost/databasefilename')

Good Luck!