How to use MongoDB in flexsim as database

Question

question

Aravind D asked Sep 17 2019 at 6:02 AM Jason Lightfoot commented Feb 13 2024 at 1:00 PM

How to use MongoDB in flexsim as database

HI,

1. I would like to get the input data from MongoDB to store it in the global table and store the output results to the global table and also directly in MongoDB. Please let me know how to connect to MongoDB from FlexSim.

. Thanks in advance for your help

Software Version:

FlexSim 19.2.0

database connector sql server mongodb

Answer 1 · 2019-09-17T12:16:39Z

Steven Hamoen answered Sep 17 2019 at 12:16 PM Jason Lightfoot commented Feb 13 2024 at 1:00 PM

@Aravind D Considering the fact that MongoDB is not supported in de DBConnector, there are 2 ways you can go.

1. Use the standard ODBC path. I think that MongoDB has an ODBC driver (at least a very quick google search tells me that)

2. Considering MongoDB is written in C++ it should not be to hard to use a native driver and create your own FlexSim dll that calls the database directly.

· 4

Aravind D commented · Sep 30 2019 at 5:38 AM

Hi @steven.hamoen

sorry for the late reply,

1.I installed the ODBC driver using the standard ODBC path, but in Flexsim if I select ODBC and after giving the login and username and password the DBConnector is not connecting.It says that it is not the default driver and data source is not available

2.And for the Flexsim dll part. I don't know how to create Flexsim dll that calls the database directly.Can you please help me in creating a Flexsim dll that uses MongoDB to connect in Flexsim has DBConnector

Thank you for your help in advance.

0 ·

Steven Hamoen Aravind D commented · Sep 30 2019 at 7:17 AM

@Aravind D

With 1 I can't help you. Please search the internet or this forum for situation that are similar to yours. You can also take a look at all the commands in FlexSim that start with "db" and see if those can communicate with your ODBC connection.

For point 2 also please search this forum. If you type FlexSim DLL or DLL SDK so will find a lot of posts and one of the first is where you can download the module SDK. The module SDK itself has quite a lot if information on how to create a DLL.

0 ·

Phil BoBo ♦♦ Aravind D commented · Sep 30 2019 at 3:17 PM

1. See Jordan's answer to Connecting Access database for an example of how to modify the connection string directly in the tree to access an ODBC connection.

0 ·

Jason Lightfoot ♦♦ Phil BoBo ♦♦ commented · Feb 13 2024 at 1:00 PM

Also see the MongoDB ODBC connector instructions.

0 ·

question