AnsweredAssumed Answered

Real-time Reporting from ODBC External Data Source

Question asked by edwilson on Jan 27, 2017
Latest reply on Feb 3, 2017 by wimdecorte

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

Outcomes