Access Keys:
Skip to content (Access Key - 0)

Accessing the Data Warehouse with FileMaker - Configuring ODBC for Windows

This page contains a subset of instructions on configuring FileMaker to access the Data Warehouse. For details on the overall process, see: Accessing the Data Warehouse with FileMaker - Configuration Instructions

Important: The ODBC connection is set up on the machine where the FileMaker database lives. If the database is hosted with FileMaker Server (strongly recommended), this is the server machine; if it's a local single-user file, this is the user's machine. These instructions are for Windows; instructions for Macintosh systems may be found at Accessing the Data Warehouse with FileMaker - Configuring ODBC for Macinsoth.

Install the Oracle Driver

Download and install the Oracle 11gR2 Client for Windows.

Note: Choose the 64-bit version of the Oracle Client. The only exception to this is if the FileMaker database will live on the client machine, and the user is running a 32-bit version of FileMaker Pro (only applies to versions 14 and earlier).

Set Up ODBC Data Source (DSN)

  1. Go to Control Panel > Administrative Tools > ODBC Data Sources (64-bit).
  2. Click the System DSN tab.
  3. Click the Add button.
    System DSN tab

  4. From the list of available drivers, select Oracle in OraClient11g_home1 and click Finish.
    List of Drivers

  5. In the Oracle ODBC Driver Configuration window, fill in the following fields:
    • Data Source Name: warehouse.
    • Description: a short description of the data source (optional)
    • TNS Service Name: warehouse
    • UserID: leave blank
      ODBC Driver Configuration

  6. Click Test Connection.
  7. Enter your Data Warehouse username and password and click OK.
    Driver Connect Window

    The test results are displayed.
    Click OK to return to the Oracle ODBC Driver Configuration screen.
    Test Results

  8. If the test fails, check your settings for typographical errors.
    ODBC Driver Configuration

  9. Click OK.
  10. The new connection appears in the list of System Data Sources.
    Click OK to close the ODBC Data Source Administrator.
    System DSN tab with new connection

Configure FileMaker Database

Now we are ready to create a connection to the Data Warehouse in the FileMaker database. Return to Accessing the Data Warehouse with FileMaker - Configuration Instructions and proceed to Step C: Configure FileMaker ODBC Connectivity.

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

August 18, 2016

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
data data Delete
m-hermes m-hermes Delete
warehouse warehouse Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki