This site has been archived. Please visit help.fulcrumapp.com for our new support documentation and contact information.

API vs. ODBC to access Filemaker database

Mark B.'s Avatar

Mark B.

29 Apr, 2014 07:00 PM

Any idea if it would be possible to integrate Fulcrum with an existing FileMaker database? Fulcrum looks like a tool we could possibly use, but we have an extensive FileMaker database which we would like to integrate with.

Ideally our users would collect the data in the field using Fulcrum, and have the results logged/stored in FileMaker. Is this possible?

  1. 1 Posted by Bryan McBride on 29 Apr, 2014 07:24 PM

    Bryan McBride's Avatar

    Mark,

    It looks like there are 2 potential solutions to accomplish integrating Fulcrum with FileMaker:

    1. Collect your data with Fulcrum, export out to CSV or Excel, and import that file into your FileMaker database for manual updates.
    2. Configure your own custom webhook scripts to push Fulcrum updates to one of FileMaker's supported SQL data sources for live updates.

    This looks like it could be a powerful combination, so keep us posted on your progress and let us know if you have any additional questions or suggestions.

    Bryan

  2. 2 Posted by Mark B. on 29 Apr, 2014 07:41 PM

    Mark B.'s Avatar

    Thanks for the quick update Bryan.

    Ingesting data into FileMaker via CSV or Excel is clunky at best, but I like the sound of the SQL data source.

    If I'm understanding correctly, we'd need to create a new SQL database to 'hold' the data coming out of Fulcrum (and drive the contents of that database using a webhook script), and then link to that SQL database from within FileMaker?

  3. 3 Posted by Bryan McBride on 29 Apr, 2014 07:46 PM

    Bryan McBride's Avatar

    That is correct. You might want to see if you can get your SQL database working with FileMaker first, and then build the webhook scripts to process the record create, update, and delete events in Fulcrum.

  4. Bryan McBride closed this discussion on 13 Aug, 2014 03:00 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac