How to schedule import records from Oracle

Discussion created by kjunker@hjf.org on Feb 19, 2015
Latest reply on Feb 20, 2015 by kjunker@hjf.org

We are currently viewing data from Oracle tables but changing records or doing a search is extremely slow.  I need to set up a script to run nightly which will import all the records (less than 5,000) from three Oracle views to FileMaker tables.  I can't figure out what the SQL Query is suppose to look like.  I've tried using the SQL Query Builder but my SQL statement is either not allowed, or keyword not found, or table/view does not exist (though I picked it from the builder) . 


An example would be most appreciated.