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.
For installation instructions, see the OOB documentation.
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.
|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|
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.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.