Kozz has asked for the wisdom of the Perl Monks concerning the following question:

My esteemed monks:
I've been researching a way to interact with a Filemaker Pro relational database system (Mac platform) from the web, using any means possible. I don't know much of anything about Filemaker, aside from the fact that it's a database system. Does anyone know of any modules or snippets that would allow me to interact with a Filemaker database?

Even worse (and maybe off-topic) any PHP tools?

Thanks much.

Replies are listed 'Best First'.
(Coyote) Re: Database Question: Filemaker?
by Coyote (Deacon) on Feb 03, 2001 at 01:34 UTC
    Filemaker Pro on the Mac side doesn't have either an odbc or DBD driver, but you can use Chris Nandor's Mac::Glue to script Filemaker via Apple Events. You can find it on CPAN or at I've seen examples that use Filemaker on some of the MacPerl mailing lists. You might want to check the archives for example code.

    Update: I cranked up my Powerbook and looked at the Mac::Glue distribution and an example for extracting FileMaker data is included.


Re: Database Question: Filemaker?
by PsychoSpunk (Hermit) on Feb 03, 2001 at 00:50 UTC
    Simple answer: Does this FileMaker Pro have ODBC? DBD::ODBC and an ODBC bridge like the Easysoft Bridge would be useful (if they have one for the Mac).

    Update: This was of course just a guess. I have no Macs immediately at my disposal. Looks like Coyote gets the prize for this one.


Re: Database Question: Filemaker?
by sierrathedog04 (Hermit) on Feb 03, 2001 at 17:25 UTC
    It looks to me as if Filemaker Pro on the MAC does have an ODBC interface. You can find out more about it here.

    At that point your Filemaker Pro has become an ODBC datasource. Perl won't care very much that it is Filemaker Pro and should treat it like any other ODBC source.

    I am not sure what the best way is to access ODBC from Perl. However, CPAN has some modules. DBD::ODBC available here looks like a promising candidate, but there may be better ways.