Database Access in WaveMaker Studio

In order to access a database from your WaveMaker Studio application, you must first import it into the project for that application. When you import the database, you specify database connection information and then WaveMaker Studio creates a Data Model for you. Both the database connection and the Data Model itself are editable after the import.

WaveMaker Studio does not automatically synchronize the Data Model with the database on which it is based. If the database changes (for example, if you add a new table to the database) you must re-import the database if you want the Data Model to include the changes. Similarly, if you make changes to the Data Model and you want your database to include those changes, then you must export the Data Model back to the database.

What is in the Data Model

The Data Model is just a representation of the database within the project. In addition to representations of the tables and columns in the database, the Data Model can also include WaveMaker-specific objects that cannot be exported to the database itself.

The Data Model contains three types of data objects, each of which has its own editor in WaveMaker Studio:

• LiveTables: Each table that you import from the database is represented in the Data Model as a LiveTable. You can edit LiveTables in the LiveTables editor (LiveTables). If you choose, you can export your changes back to the database. If the database changes (for example, a new table is added) then you need to re-import (Importing a Database).
• LiveViews: LiveViews are collections of related tables. They are similar to views in databases. Use LiveViews when you want to display columns from related tables in a single widget, such as a LiveForm. LiveViews cannot be exported back to the database. (LiveViews)
• Queries: In WaveMaker Studio database queries are treated as objects in the Data Model. You can create, edit and delete queries in the Queries editor. (Queries)

What Databases are Supported?

Currently WaveMaker Studio supports PostgreSQL, MySQL, Oracle, DB2 and SQL Server. The installation also includes Hypersonic SQL DB (HSQLDB), as an embedded database. This database is included for demo and testing purposes. For more information on HSQLDB, see:

http://hsqldb.org/web/hsqlDocsFrame.html