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

Part: IV Printing, Networking, & the Web > Exchanging Data via ODBC

Chapter 17. Exchanging Data via ODBC

Open Database Connectivity (ODBC) allows FileMaker to easily exchange data with giant enterprise-level databases such as those created by Oracle and Microsoft SQL Server. This lets you sidestep an all-too-common dilemma: either stick with FileMaker and forego connecting with corporate-level databases or give up FileMaker's simpler interface for the complications of using ODBC-based programs. Now you and your co-workers can have the best of both worlds. Those who prefer the scale and power of enterprise-level database programs can still tap your FileMaker data and you can use FileMaker to query the big databases. In either case, of course, you'll need to work with your network administrator to make sure you follow your network's procedures and guidelines. As a FileMaker user always stay on your network administrator's good side.

Unfortunately, FileMaker does not yet fully support ODBC on Macs running OS X. But as Apple smoothes out the rough spots in OS X, expect FileMaker to remedy the problem as soon as possible, so make a point of regularly checking www.filemaker.com/support/ for updates. 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 straight-forward 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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