8 Replies Latest reply on Feb 3, 2017 10:38 AM by wimdecorte

    Real-time Reporting from ODBC External Data Source

    edwilson

      Please provide instructions or point me in the right direction on reporting or retrieving data from ODBC external data sources.

       

      I am trying to develop a real-time or live report from an Oracle external data source in FileMaker Pro 14 on a Mac. The Actual ODBC Oracle driver is installed, but I am not able to successfully run scripts from a simple SELECT SQL query to dynamically retrieve data. The below query runs flawlessly on Toad or other DB tools.

       

      Select LAST_NAME, FIRST_NAME

      from OUWB_PROD.SR_V_ENROLL

      group by LAST_NAME, FIRST_NAME

      order by LAST_NAME