Easysoft ODBC-ODBC Bridge

How do I access ODBC Databases such as Microsoft SQL Server, Microsoft Access, and Microsoft Excel from FileMaker Pro?

Article:
00943
Last Reviewed:
4th January 2006
Revision:
1

You can use the Easysoft ODBC-ODBC Bridge (OOB) to access ODBC databases such as Microsoft SQL Server, Microsoft Access and Microsoft Excel from FileMaker Pro. For example, import data from SQL Server to FileMaker Pro on Mac OS X. Do this by using the OOB to access the Windows SQL Server ODBC driver.

Download the OOB Client for the platform on which FileMaker Pro is installed and install the OOB Client. Then download the OOB Server for the platform on which the ODBC driver for your database is installed and install the OOB Server. Set up and test an OOB Client data source that points to a System data source for the target ODBC driver.

The following example illustrates this process for FileMaker Pro on Mac OS X and SQL Server.

  1. Download the Mac OS X OOB Client and the Windows OOB Server.
  2. Install the OOB Client on the Mac OS X computer where FileMaker Pro is installed. Install the OOB Server on the Windows computer where the SQL Server ODBC driver is installed.

    For installation instructions, see the OOB documentation.

  3. If you have not already done so, in the Windows ODBC Data Source Administrator, create a SQL Server System data source that connects to the SQL Server database you want to access from FileMaker Pro.
  4. In the Mac OS X ODBC Administrator, use the OOB DSN dialog box to create an OOB Client data source.

    The following table shows some sample values for an example data source named OOBsqlserver. The example data source points to an OOB Server on a host named mywindowsserver where there is a SQL Server System data source called sqlserversystemdsn. The LogonUser and LogonAuth values are a valid Windows username and password that can be used to log in to mywindowsserver. The TargetUser and TargetAuth values are a valid SQL Server database login.

    SettingValue
    Name (DSN tab)OOBsqlserver
    Servers (Servers tab)mywindowsserver:8888
    Username (Servers tab)mywindowsusername
    Password (Servers tab)mywindowspassword
    TargetDSN (TargetDSN tab)sqlserversystemdsn
    TargetUser (TargetDSN tab)sqlserverusername
    TargetAuth (TargetDSN tab)sqlserverpassword

    For more information about OOB Client data source configuration, see the OOB documentation.

  5. In Terminal, use iodbctest to test the OOB Client data source. For example:
    iodbctest "DSN=OOBsqlserver"
    SELECT 1 AS test_column

After you have created and tested the OOB Client data source, use it from FileMaker Pro to query the remote database, import data or create a new FileMaker Pro database file. The FileMaker Pro documentation contains information about how to do this.

As an example of using an OOB Client data source in FileMaker Pro, the following steps show how to create a new FileMaker file on Mac OS X by using data imported from a SQL Server database.

  1. In FileMaker Pro, on the File menu, choose Open. In the Open dialog box, choose Show, and then choose ODBC Data Source from the list.
  2. Choose the OOB Client data source, and then choose Continue.
  3. When prompted, type the SQL Server database login username and password that you supplied when configuring the OOB Client. Then choose OK.
  4. In the SQL Query Builder, use the SELECT, WHERE and ORDER BY tabs to generate a query that will retrieve the records you want to import. Then click Execute.
  5. Save the new FileMaker file.
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.