I'm developing a solution on FM17. One of the data sources I'll pull from is a sql data base...
I'll want to run a sever script to hit the sql data base.
The sql and FM data bases are not hosted at the same location, but could be needed.
The issue is I need to prove I can do it secruly.
What is the best/cleanest way to do the queries: memory varables & one talbe, relationship & external data source?
How do I address the security concerns?