Integrating Existing Databases into Rollbase External Tables
Rollbase helps you create apps with speed and efficiency. Learn how easy it is to develop applications in Rollbase that can reuse your existing data.
Join the DZone community and get the full member experience.Join For Free
In this tutorial, you'll learn how to easily integrate data from your existing database tables into your Rollbase application.
In this blog, we will look at how we can integrate an existing database into Progress Rollbase applications. Rollbase is a low-code platform that helps create all sorts of applications at unprecedented speed and efficiency. In most cases, you probably intend to modernize your existing applications to an all new user interface and experience. This can be easily achieved with Rollbase external database support. This feature is only available on the private cloud.
Purpose and Prerequisites
We will build an Application in Rollbase that will have:
- Employee and Department as objects.
- 1:M relationship between Department and Employee.
As a prerequisite, we need to have a database schema with two tables (Employee and Department) as:
- Employee table with employee ID, name, and department ID columns.
- Department table with department ID, and name column.
- Both these tables have some data.
Setting up Rollbase on the Existing Database Schema
Rollbase installation comes with SQL files for four databases:
- Oracle (
- MySQL (
- MSSQL (
- OpenEdge (
For the purpose of this blog, we will use the MySQL version and MySQL workbench. We will now run 'create_mysql.sql' script to install Rollbase tables on the existing schema.
Your database schema (
rb_dbo) will now have existing tables (Department, Employee) and Rollbase tables (tables that start with
Let's take a quick look at the data from the Employee and Department tables.
Configuring a Database in Rollbase
Creating Applications in Rollbase
Let's start building our application in Rollbase with objects accessing data from the existing tables.
As a first step, we will create an application from External Table Demo in Rollbase by launching the Application create wizard and clicking on Let me build it my way.
Creating External Objects in Rollbase
We will now create the Department object that points to the Department table in the schema. In order to this, we should choose the A new Object (with Tab) from an External Metadata option from the object create popup.
Choose the External Tables option on the Import Object Metadata page and click Next.
Choose the department table from the dropdown and a name column. Now, provide a name for the Rollbase object that will point to this database table and click Create Object.
Choose a primary key for the Department table viz. id and click Create Fields. This will now create fields in the Department object and associate them with the respective database columns. In this page, you can set Rollbase field details such as their label, field type, uniqueness constraints, etc.
In the Adjust SQL page, you will see options to configure your SQL queries for the CRUD operations on the Department object:
Follow the same steps to create the Employee object that points to the Employee table in the schema. During this configuration, make sure you select the
department_id column as a foreign key in the Create Fields page. This will automatically create a 1:M relationship in Rollbase between Employee and Department objects.
The Department and Employee tabs in the application now show the data from their respective database tables:
Let's now create an Employee for the Finance Department. This will also create an entry in the Employee table.
Let's now query the Employee table and verify the new Employee entry.
To conclude, we learned how easy it is to develop applications in Rollbase that can reuse your existing data. There is comprehensive documentation on this subject here.
Published at DZone with permission of Manooj Murali, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.