This discussion is archived
6 Replies Latest reply: Nov 20, 2005 8:56 AM by 470354 RSS

anyone using FileMaker as oracle frontend ?

RonaldRood Oracle ACE
Currently Being Moderated
Hi,
just wondering, who is doing this, how does it work, and what are the experiences ?
Filemaker is a great tool to quickly build an application, it would be nice if it could also do this in an oracle database environment.

regards,
Ronald
http://homepage.mac.com/ik_zelf/oracle
  • 1. Re: anyone using FileMaker as oracle frontend ?
    439480 Newbie
    Currently Being Moderated
    Ronald,

    Not using FileMaker, but 4th Dimension.
    4D is maybe a bit more expensive than FileMaker and has certainly a steeper learning curve, but it is much more powerful and flexible. The language is extensible trough plugins and you can create standalone single user double clickable applications or client server apps.
    4D has a plugin called 4D for OCI which works on MacOSX and Windows. The MacOSX version works with OCI v 8 and v10.

    Koen Van Hooreweghe
  • 2. Re: anyone using FileMaker as oracle frontend ?
    RonaldRood Oracle ACE
    Currently Being Moderated
    Hi Koen,
    thanks for your reply. Omnis studio and 4D both have those options, I know and also about the learning curves, which is exactly why I am curious for solutions with FM since it's very easy to learn. It would be great if one could generate an oracle schema from FM and use the oracle database as a backend. FM is easy to learn and powerfull. Maybe even I could create a nice little app with it ;-)

    regards,
    Ronald.
  • 3. Re: anyone using FileMaker as oracle frontend ?
    445248 Newbie
    Currently Being Moderated
    We have several customers using FileMaker as a front end for Oracle with our ODBC drivers. As far as I know, they use FMP two different ways.

    First, they use it as a report generator. They lay out a report with no records, and then use "File -> Import Records -> ODBC Data Source" to connect to Oracle and enter a query for importing the data to be reported into the FMP database. Every time they want to re-run the report, they delete the FMP records and run the query again. This can be automated through scripting.

    Second, they use FMP as a front end application to Oracle data. This requires using the "Execute SQL" and possibly the "Import Records" script steps. There are a few design patterns out there for inserting and updating data from the FMP database to corresponding Oracle records.

    Jonathan Monroe
    Actual Technologies - ODBC for OS X
    http://www.actualtechnologies.com
    monroej@actualtechnologies.com
  • 4. Re: anyone using FileMaker as oracle frontend ?
    457284 Newbie
    Currently Being Moderated
    Second, they use FMP as a front end application to Oracle data. This requires using the "Execute SQL" and possibly the "Import Records" script steps. There are a few design patterns out there for inserting and updating data from the FMP database to corresponding Oracle records.

    Does anyone know where I can find more information about these "design patterns" for using FMP as a front-end to Oracle?

    Thanks,

    Isaac Vetter
  • 5. Re: anyone using FileMaker as oracle frontend ?
    445248 Newbie
    Currently Being Moderated
    Does anyone know where I can find more information
    about these "design patterns" for using FMP as a
    front-end to Oracle?
    An example would be to use the built-in features of FileMaker Pro to create a FMP database based on the schema of the Oracle database:

    1. Select File -> Open..., then "ODBC Data Source" from the "Show:" popup menu. Select your Oracle DSN and specify a SQL query. A new FMP database will be created with the data from your query.

    2. Periodically refresh your FMP database with data from your Oracle database by first selecting Records -> Delete All Records, and then selecting File -> Import Records -> ODBC Data Source and specifying the same query as step #1 (this can be automated using the Import Records script step)

    3. Update data in your Oracle database with data from your FMP database by writing a script similar to this:

    Go to Record/Request/Page [First]
    Loop
         Execute SQL [No dialog; DSN: myDSN;
                   Calculated SQL Text: "UPDATE products_description
                          SET products_viewed=" & myFMPDatabase::Products_Viewed
                          & " WHERE products_id=" & myFMPDatabase::Products_ID]
         Go to Record/Request/Page [Next; Exit after last]
    End Loop

    The script traverses the records in your FMP database and builds a SQL statement for updating a corresponding record in the Oracle database. A similar script could insert new records into the Oracle database.

    Best regards,

    Jonathan Monroe
    Actual Technologies - ODBC for Mac OS X
    http://www.actualtechnologies.com
    monroej@actualtechnologies.com
  • 6. Re: anyone using FileMaker as oracle frontend ?
    470354 Newbie
    Currently Being Moderated
    Recently I have been creating a couple of FileMaker 8 front-ends to our OSX 10g install.

    We use the Actual drivers. It's pretty easy to create the apps and connect with either "Execute SQL" or "ODBC Import".

    The downside is to do anything in FileMaker you need to have the data in FileMaker's tables first. That means importing into them and "Execute SQL" to insert/update/delete data in the 10g table(s). The decision to source your data in FileMaker then needs to be made judiciously.

    FileMaker's strength is in the user interface and printing which can mean its a good solution but it can still be a hard sell to the 10g IT staff ;-)

    Mark