Database Access
Connect to Any SQL BackendServoy itself is not a database. Servoy allows you to connect seamlessly to all the popular SQL databases in the marketplace; Oracle, DB/2, MS SQL Server, Sybase, iAnywhere, Postgresql, MySQL, and OpenBase to name a few. Setting up a database connection takes less than one minute. And you can dynamically switch from one database to another: develop your application with MySQL and deploy it on Oracle -- all with zero code changes on your part. Servoy will even create all the necessary tables and/or alter existing tables if necessary.
Cross Database Joins
If you have a mixed back-end server environment, Servoy allows you to join data seamlessly between these different backends (even if they are from different vendors). Zero programming is required to show customer data from your Oracle database and join it with order data stored in a MS SQL Server system.
Transaction Support
Servoy can manage all your database transactions for you as well as manage the locking of data on the Servoy side. Transactions across multiple databases and multiple tables are also supported -- all without writing a single line of SQL code.
Stored Procedures
You can also execute business rules stored inside your database as stored procedures. Servoy supports stored procedures on all commonly used databases; and supports both passing multiple parameters and receiving back-end data or recordsets.
