Accessing a Filemaker Pro database from within a Processing sketch

Move this topic

Forum :

Sub forum :

Programming Questions

steve9000..

Accessing a Filemaker Pro database from within a Processing sketch

in Programming Questions • 2 years ago

I've read the database-related material in Ben Fry's "Visualizing Data," explored the Processing web site, and done some general googling but I haven't found any obvious way to make queries to a FileMaker Pro database from inside Processing. I'm committed for this project to using FileMaker Pro as the database, so moving to MySQL or PostgreSQL aren't available options. First hope would be an already-created library I could simply import and use, but I haven't found that.

What I'm hoping is that I could use ODBC as a bridge between a Processing sketch and the Filemaker Pro database. I don't need to add or modify any of the data, I just need to query it and extract various subsets. I'd deeply appreciate any advice on how to get started with this, or suggestions on alternative approaches I haven't considered. Thanks.

--Steve

Replies(5)

PhiLho

Re: Accessing a Filemaker Pro database from within a Processing sketch

2 years ago

With Java, you use JDBC, not ODBC (although there are bridges between the two).
A quick search leads to http://help.filemaker.com/app/answers/detail/a_id/5355/~/sharing-filemaker-pro-data-via-odbc-or-jdbc page, which might be a starting point. You have to locate a Filemaker Pro JDBC driver, and use, for example, the SQLibrary by Florian Jenett to access your data.

Re: Accessing a Filemaker Pro database from within a Processing sketch

2 years ago

Thanks, phi.iho. I'll follow those links.

-Steve

Re: Accessing a Filemaker Pro database from within a Processing sketch

2 years ago

Success! phi.lho's link led me to http://www.filemaker.com/support/product/docs/fmp/fm11_odbc_jdbc_guide_en.pdf, which, in combination with Ben Fry's MySQL example code in "Visualizing Data," worked out nicely. Thanks again to phi.lho.

-Steve

Re: Accessing a Filemaker Pro database from within a Processing sketch

2 years ago

Can you post a link to the example code in "Visualizing Data"

Re: Accessing a Filemaker Pro database from within a Processing sketch

2 years ago

owaunandrew,

This particular code snippet, which is on pp. 291-293 of Ben Fry's "Visualizing Data," O'Reilly, First Edition printed December 2007, doesn't appear to be one of the code examples that Ben Fry put online on his site ( http://benfry.com/writing/archives/3) . You can access it starting at

http://my.safaribooksonline.com/book/databases/business-intelligence/9780596514556/acquiring-data/291?bookview=search&query=Using+MySQL+With+processing#X2lud GVybmFsX0ZsYXNoUmVhZGVyP3ht bGlkPTk3ODA1OTY1MTQ1NTYvMjkx

if you have a Safari Books Online account. Copyright concerns prevent me from copying and pasting the code segment here without permission: for me it was certainly worth the price of the book for this piece of code alone. I'll check with Ben Fry and see how he feels about it.

-Steve

Statistics

5 Replies
1298 Views
0 Followers

Actions

Permalink

Correct way to test PApplet on JUni...
Cannot Destroy Context while it is ...
arrayIndexOutOfBoundsException:1
Help with creating a tree branch?
How to make irregular SVG shapes bo...

Accessing a Filemaker Pro database from within a Processing sketch

Replies(5)

Re: Accessing a Filemaker Pro database from within a Processing sketch

Re: Accessing a Filemaker Pro database from within a Processing sketch

Re: Accessing a Filemaker Pro database from within a Processing sketch

Re: Accessing a Filemaker Pro database from within a Processing sketch

Re: Accessing a Filemaker Pro database from within a Processing sketch

Statistics

Tags

Actions

Related Posts