2 Replies Latest reply on Mar 7, 2011 12:59 PM by RobertHouben

    Extending FileMaker's Reach

    RobertHouben

      Title

      Extending FileMaker's Reach

      Your post

      Does anyone have any examples, or any info on extending FileMaker to work with a third party database provider?  I'm particularly interested in what types of strategies it supports, including ODBC, JDBC, Custom Java, ADO.NET Managed Providers, OLE DB, Web Services, or whatever.

      I'm also interested in knowing how critical it is that the third party provider be to a full relational source.

      Thank you,

        • 1. Re: Extending FileMaker's Reach

          Robert Houben:

          Thanks for posting!

          You can connect to a third party database system from FileMaker using ODBC. Also, if you're hosting the file with FileMaker Pro, FileMaker Pro Advanced or FileMaker Server Advanced, you can connect to and use a FileMaker database as the data source for third party systems via ODBC or JDBC.

          It's not necessary for the third party application have full relational capabilities for this connection to work, only that they have ODBC or JDBC support. So, as an example, you can make a connection from Excel despite it just being a flat file database.

          For more information on ODBC and JDBC functionality, you may want to take a look at the ODBC/JDBC guide, available here:

          http://www.filemaker.com/support/product/docs/fms/fm11_odbc_jdbc_guide_en.pdf

          TSBear

          FileMaker, Inc.

          • 2. Re: Extending FileMaker's Reach
            RobertHouben

            We've done the ODBC connection before.  We have newer technology based on ADO.NET and Java that let you retrieve data without requiring support for "SELECT" syntax.  ODBC generally assumes a certain level of ANSI SQL conformance, and the systems we're connecting to won't support that (correctly) without performance issues.

            I was hoping to use it with the FileMaker GO for iPhone, but the pricing model won't work for my customer.

            Thank you for the quick response.