AnsweredAssumed Answered

Quering a SQL data base

Question asked by Kirk_1 on Aug 3, 2018
Latest reply on Aug 3, 2018 by beverly

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.

 

Two questions:

     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?

Outcomes