question

kauan pedroso avatar image
0 Likes"
kauan pedroso asked Jeanette F commented

Emulation of a database

Hey guys

I'm wanting to do an emulation getting data from a database (SQL Serve) but I don't know where to start. If there is anyone who can help me where I should start studying and what are the steps for me to be able to do this activity, I would appreciate anyone who can help me on this journey.

FlexSim 21.2.4
emulationdatabasesql server
· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

Are you saying you want to simulate the client server database communication and network packets along with the server's database retrieval processes on a multithreaded CPU. Or do you want to emulate something else using live data that you will get from a SQL Server database?

0 Likes 0 ·
kauan pedroso avatar image kauan pedroso Jason Lightfoot ♦ commented ·

Hello @Jason Lightfoot

t would be the second option I would like to emulate live using data from a SQL database it serves. Is it possible to make this application ?

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦ kauan pedroso commented ·

Anything can be done in software if you can specify what you want and can spend the effort it will take.

Your question raises many more including why you don't use OPC and/or what coding skills you have available along with your assessment of the need to an immediate trigger-based notification when the database has an update or insert, or whether a database polling interval would suffice.

You should probably talk to your University academics in the appropriate fields and/or to FlexCon who are FlexSim emulation experts.

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel commented ·
0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

@Luciano Cavallero, @Tancredi Canonico, @Fiorenzo A, can you please take a look at this emulation-related question?

0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @kauan pedroso, was Luciano Cavallero's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 Likes 0 ·

1 Answer

Luciano Cavallero avatar image
0 Likes"
Luciano Cavallero answered

Hi,

as pointed by Jason you need to be more specific in what you need.


If you need to get data from a database for feed you model you can use the database connector available in FlexSim to retrieve the data.

If you need to get data from another source you can use one of the available protocols in the emulation module, include the industry standard OPC UA.


5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.