Attaching to Filemaker databases?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Attaching to Filemaker databases?

Postby Drue » Sat Dec 29, 2007 9:06 pm

I need a flexible method to report and query the information contained in Filemaker 8 files. Is there a way Base can attach to Filemaker data? If so, can you also point me to available drivers and any information. Btw, the databases are on macs, using Leopard and Tiger.

Thanks,
Drue
Drue
 
Posts: 2
Joined: Sat Dec 29, 2007 8:55 pm

Re: Attaching to Filemaker databases?

Postby Villeroy » Sun Dec 30, 2007 8:31 pm

I'm not a database expert, but in general it should be the same procedure as connecting to mySQL via odbc or via jdbc. http://wiki.services.openoffice.org/wik ... SQLandBase
Install a odbc/jdbc-driver for Filemaker, register your database and create a new Base-document connecting to the o/jdbc-source.
The database tables appear in the tables container of the Base document.
Simple select-queries can be done in the query designer, more complex select-queries can be done in text view and "native mode". Native mode passes the sql over to the engine.
Forms and reports are special writer documents, embedded in the Base document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27610
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Attaching to Filemaker databases?

Postby Drue » Wed Jan 02, 2008 6:13 pm

Villeroy, thanks for your quick response. I'm looking for some kind of ODBC driver for BASE for Filemaker (like you use the odbc/jdbc driver to hook into your sql db.)

So, briefly, I'm looking for some kind of driver to attach to Filemaker.
Drue
 
Posts: 2
Joined: Sat Dec 29, 2007 8:55 pm

Re: Attaching to Filemaker databases?

Postby DrewJensen » Wed Jan 02, 2008 6:34 pm

The ODBC and JDBC drivers are supplied by FileMaker - you will find information at the Filemaker site regarding installation and configuration.

I am not sure but I believe that under Filemaker 8 the supplied drivers are for data loading / export only - don't quote me on that, go check - and it was in the Version 9 release that they supplied 2 way live connections.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest