Each AnyLogic model has a built-in, fully integrated database for reading input data and writing simulation output. You can use it to import data from MS Excel spreadsheets or various types of databases and store it in an easily accessible form, log all model activities and statistics, and export the database with the model.
The built-in database supports import from the following data sources:
- Microsoft Excel,
- Microsoft Access,
- Microsoft SQL Server,
- PostgreSQL,
- Oracle,
- MySQL,
- MariaDB.
If you need to access other types of databases, or interact with some external databases, you can use connectivity tools of AnyLogic, which are designed to interact with external data sources.
To access an external database, add the Database element from the Connectivity palette to your model and use it to connect to a real database.
-
How can we improve this article?
-