


Here is the example for source block that allows to use a database table as arrival table.Īlso, there is a possibility to write the query code. Most objects support the graphical interface, from usual parameter to flowchart blocks. E.g., if you need to feed a population from a database or define arrival table at Source block, just use the graphical interface of object properties. We provide an intuitive interface for most common use cases, so the modeler dows not have to write SQL queries.

So, the database may be accessed by SQL commands or Query DSL Java code. If the "Update data." checkbox is selected, then all changes to the source will be applied to the database.īefore starting to explore the database capabilities, let's look how we may interact with the database from the model canvas. Also, data can be simply copy-pasted from Excel to the table (and vice-versa). The database allows to import data from Excel file, Access or SQL database - just click "Create or import a table." text at database properties or the right-click context menu.

The filling process is clear and simple no need for coding. Import of initial data to the built-in database is an easy task. Also, at the end of this post you may find some tips for work with the database, and a brief description of further enhancements.Ĭonvenient access to database and one-click automatic import of data
