Search

FileMaker Pro

FileMaker Pro

This page outlines the steps to connect FileMaker Pro to CData Connect Cloud.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect Cloud account. See Sources for more information.

  • Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connect from Mac

  1. Download and install the Actual ODBC Driver for SQL Server.

  2. Configure a DSN using the Actual ODBC driver by setting the following:

    • URL: https://tds.cdata.com/
    • Port: Change the port from 1433 to 14333
    • Username: your Connect Cloud email
    • Password: the PAT you created earlier

The FileMaker Pro SQL Query Builder requires customization to connect to CData Connect Cloud. Auto-generated queries do not work in FileMaker Pro. We recommend the following additional steps:

  1. In the SQL Query Builder SELECT tab, select the columns to include as part of the query.

  2. Open the WHERE tab of the SQL Query Builder and select Show only selected columns.

  3. In Table.Column, select a table and a column name.

  4. Set the Operator to =.

  5. Select Column, and then select the same table and column name as Table.Column.

  6. Click Insert into SQL Query.

  7. If no other modifications to the SQL query are required, click Execute.

Connect from Windows

To establish a connection from FileMaker Pro to CData Connect Cloud, follow these steps.

  1. Download and install the CData Connect Cloud ODBC driver.

    1. Open the Integrations page of CData Connect Cloud.
    2. Search for ODBC.
    3. Click Download and select your operating system.
    4. When the download is complete, run the setup file.
    5. When the installation is complete, the ConfigureODBC file can be found in the installation directory.

  2. Open the ConfigureODBC file.

  3. In the Basic tab, make sure the Auth Scheme is OAuth.

  4. In the Advanced tab, in Miscellaneous > Default Catalog, enter the name of the connection set up in the prerequisites.

  5. Click Test Connection. Click OK when you have a successful connection.

  6. Launch FileMaker Pro. A startup screen appears.

  7. Start a blank app or use a template. Name your app.

  8. Select File > Import Records > ODBC Data Source. A Select ODBC Data Source dialog appears.

  9. Select Connect Source and click Continue.

  10. Enter your user credentials in the dialog. The User name is your User Id in CData Connect Cloud, and the Password is the PAT obtained in the prerequisites.

  11. When the CData Connect Cloud data is finished importing, a SQL Query Builder dialog appears.

  12. Select the tables and columns to insert into your SQL query and click Execute.

  13. A Specify Import Order dialog appears, where you can customize how and into which table you want to import the CData Connect Cloud data into FileMaker Pro.

  14. Click Import to import the data into the target FileMaker Pro file.

  15. You can now work with the data in FileMaker Pro.