How to import data from a SQL server in real time ?

[muhamed_gabeljic]

[ FlexSim 21.0.10 ]

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 !

[Jeanette_Fullmer]

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.

[Tim31]

Hello, I would like to know is there a solution to this problem?

[logan_gold]

@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.

[Tim31]

@Logan Gold ，Thank you, Logan Gold. I saw the user manual today about linking to the database, and I tried it. But I would like to know that in practical use, if I want data to be imported and exported from SQL in real time, I can't always refresh the data through the "import" and "export" buttons. It makes the experience very poor. I wonder if I can achieve my idea in some way?

[logan_gold]

You will need to use the FlexScript database commands to do what you want to do.

[Tim31]

I checked the user manual. Maybe it's my understanding, I didn't find the command to update the data. What you're trying to say is that I can click this button with the flexcript command? And put this command into any entity's drawing trigger to update the data?

[Tim31]

@Logan Gold Sorry, I can't find the right command, can you help me? I want to be able to export data in real time from a database connection.

[joerg_vogel_HsH]

@Tim, hmm, there is the command reference. There is a search tool within. or you can open a search mask by key combination of ctrl and f, where f stands for find. A command for a database gets typically a prefix of "db". So if you would simply use methods, programmers did in the past, you may find an answer for yourself.

[Tim31]

Thanks. I'll give it a try

[Tim31]

@Joerg Vogel I see two commands, "dbexportnode" and "dbexporttable," and I try to add a command to the user event that refreshes every second, but I can't find the right way to use this command. I will attach my model for reference.ddddd.fsm

[joerg_vogel_HsH]

@Tim, now your question is different to your question here. Please ask a new question about using this command in your context correctly.

[Tim31]

I'm sorry. Maybe that was a mistake. I would like to use your prompt to refresh the data exported to the database with the command "db". So I used "dbexportnode" and "dbexporttable." Is there any other way?

[jason_lightfootVL7B4]

Take a look at Prepared statements.