Production Database Restrictions – Make Way for SQL Script Creation

Ever get stuck using a GUI that only allows manually editing data one record at a time? I know that feeling. At the end of it, I’m left with a sinking feeling about the potential errors that may have been introduced. Have no fear, FME is here! Our GIS Team can now utilize FME to generate SQL scripts so that records can be inserted, updated or deleted, live. But, why was a script created vs updating the database directly with FME? Due to the critical nature of the dispatch database, there is limited access to modifying records. No problem. With some additional transformers, FME can generate a text file that can be given to IT to run and apply the changes. Voila!