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
group by LAST_NAME, FIRST_NAME
order by LAST_NAME