Hello,
I am trying to import in real time data from a SQL database.
I can import manually but I can't find anything on how to import in real time the data.
Any help would be appreciated.
Thank you in advance !
How to import data from a SQL server in real time ?
FlexSim 21.0.10
Hi @Mumo,
Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.
If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.
@Tim, here's how to set up a database connection. Normally, you would import data once before running the model and can use the "Import Automatically On Reset" option to automatically import every time the model is reset.
If you want to have the data imported as needed during the model run, you will need to use the FlexScript functions at the bottom of the page and call them when you want to import data during the model run. This can slow down the model run significantly, though, depending on how often calls are made to the database and how big the database is.
16 People are following this question.
