Any relational database can be handled by Ontimize. The connections between the Ontimize server and the database engine can be done using a jdbc native driver or even using the jdbc:odbc bridge. Building an Ontimize application using any database is very easy; just by executing the New Ontimize Project wizard this task can be done

The database configuration can be done in this screen:

And any database type can be chosen.

In conclusion, to configure a database to work with is as easy as configuring in the Ontimize wizard the following parameters:

After executing the New Project Wizard, a package structure will be created in the project with the basic elements to execute an Ontimize application:

At this point an Ontimize server can be executed to check the database connection. The Ontimize SDK also automates this task and, in the run menu, there are preconfigured the run configurations for the project:

In case the configuration related to the server is executed, an Ontimize Server Monitor will appear, indicating the Ontimize server status, and also the database connection status:

There is only one modification that must be done to the database to allow the Ontimize Application Server to access the database and it is related to the authentication strategy. Ontimize stores the information related to the application users and its profiles in the database which means that, to configure this default authentication mode in any database this two simple steps must be followed:

1. Add to the database the authentication information, by executing the SQL scripts you can download from the Ontimize Support Download page. These tables will handle the application users and the profiles they belong to. The profiles is the standard way Ontimize have to provide authorization.
2. Executing the wizard New User Entity Wizard, that you can see in the SDK and also an example in the Ontimize Media Page.

At this point a client can be launched with the execution configuration for the client, and it is time to create new application screen (form) following the instructions contained in the New Form Wizard.