• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Exchanging Data > Exchanging Data Using ODBC

Exchanging Data Using ODBC

Open Database Connectivity (ODBC) allows FileMaker to exchange data with giant enterprise-level databases such as those created by Oracle and Microsoft SQL Server. On Macs running OS 8.1–9.1 and Windows machines, the ODBC process is roughly the same: You turn on FileMaker’s Data Access Companions, configure the ODBC Control Panel for the particular data source, connect to the data file, and then construct a query (search) of that data. There are a lot of steps involved, but you’ll find the process pretty straightforward once you walk through it. If you’re not familiar with Structured Query Language (SQL)—the programming language that controls corporate-level database management systems—find someone within your organization to lend you a hand building those initial queries.

As with version 5.5, FileMaker 6 does not fully support ODBC on Macs running OS X. But with version 6’s new XML support this isn’t the roadblock it might seem. In fact, using FileMaker’s XML import-export features often is actually easier than working with ODBC. For more information, see Exchanging Data Using XML, on page 272.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint