...
Almost all Servoy applications utilize a database to store user data and application metadata. Servoy can connect to any database that has a JDBC driver available. Servoy provides a database, PostgreSQL, for you if you do not already have a database bundles PostgreSQL by default, but PostgreSQL can be removed and replaced by any database management system (DBMS).
In Servoy Developer, you may create a new PostgreSQL database can be created from the Solution Explorer tree.
You may also connect to an existing database in Servoy Developer.From within Servoy Develop connections to existing databases can also be setup:
application_server/drivers
folder in your Servoy the Servoy installation folder.Create a new Database Server connection by right clicking on Database Servers node (under Resources) and selecting New Server. A submenu will provide choices of different popular database choices that will fill in some of the connection information to make setup easier, or you may choose empty.
Note | ||
---|---|---|
| ||
Even though a database is listed here, you the JDBC driver must still install a driver be installed in the drivers folder in order to connect to the database. |
Fill in the Server Name, User Name, Password, URL, and Driver for your database. You can find the the database. The correct values for the URL and Driver should be obtained from your the database documentation, or suggested values will be already entered if you selected your database in when going through the New Server menu.
Note | ||
---|---|---|
| ||
The user account should be of administrator level so you as to have full access to database objects in Servoy. |
...
It is best practice to create your data the data model (tables, primary keys, foreign keys, and fields) before you starting to create your a solution. You can create objects Objects in the database can be created with database tools built to administer the database, or you may create objects within Servoy Developer.
...
...