The structure of the database will determine both the complexity of the statements needed to pass information back and forth with Vensim and the efficiency with which these statements can be executed. If you are passing small amounts of data then it is best to use the most convenient database structure and write very explicit queries and output statements.
If you are passing a larger amount of data you may want to emulate the simple example that comes with Vensim. You can then use Triggers or other mechanisms supported by the database you are using to do any necessary internal transformations prior to Vensim’s database reads and successive to its database writes.
