How to Visually Build Apps with Joget and Red Hat OpenShift Container Platform

By -
EDITOR’S NOTE October 2020: This post was originally published in January 2019 for OpenShift 3.11. Please refer to the Knowledge Base for the latest instructions to deploy Joget DX on OpenShift 4.5.



 Red Hat OpenShift is a container application platform that brings Docker and Kubernetes to the enterprise. As a cloud native computing platform, OpenShift allows teams to automate the build, deployment, and management of applications. They can focus on developing apps without worrying about the underlying infrastructure, whether on physical/virtual servers, or on public/private/hybrid cloud environments.

The move to cloud native computing is a key segment of many organization’s digital transformation strategy. However, that is only a part of the equation because a major gap that has to be addressed is in building the applications and automating business processes. A lot of application development today still utilizes traditional coding, so the inherent complexities along with the shortage of technical expertise are significant obstacles.

As an open source no-code/low-code platform to visually build enterprise web apps for coders and non-coders, Joget is an ideal complement to OpenShift to fill the gap. The Joget platform is now available as a Red Hat Certified Container, so it is trusted, secure and commercially supported on OpenShift. This article describes the steps in deploying the certified Joget container image running with the MySQL database.
   

Deploy Joget using the OpenShift Web Console

Step 1: Create OpenShift Project

Access the OpenShift Web Console and login


 Create a project using the Create Project button and key in the desired Name, Display Name and Description.



Step 2: Deploy MySQL Database

Under the selected project, select Add to Project > Browse Catalog and select the MySQL image.


Key in the appropriate settings and click on Create e.g.

Namespace
openshift
Database Service Name
jogetdb
MySQL Connection Username
joget
MySQL Connection Password
joget
MySQL Database Name
jwdb




Step 3: Deploy Joget Platform

To access the Red Hat Container Catalog, a valid username and password that is used to log in to the Red Hat Customer Portal is required.
If you do not have an account, you can acquire one by registering for one of the following options:
Under the selected project, select Add to Project > Deploy Image and click on the create an image pull secret link. In the ensuing popup, key in the Red Hat login details for the registry.

Secret Name
registry.connect.redhat.com
Authentication Type
Image Registry Credentials
Image Registry Server Address
registry.connect.redhat.com
Username
Red Hat account username
Password
Red Hat account password
Email
Red Hat account email
Link secret to a service account
Yes
Service Account
default


Once the secret has been created, select Add to Project > Deploy Image, select the Image Name option and key in registry.connect.redhat.com/joget/joget-v6-enterprise. Click on the small search icon to load the image details from the registry, key in the desired Name then click Deploy.

Image Name
registry.connect.redhat.com/joget/joget-v6-enterprise
Name
joget-v6-enterprise
Step 4: Add Persistent Storage
The next step is to add persistent storage to the container for storing configuration files and persistent file uploads. Under Applications > Deployments, select the application, then the Configuration tab. Scroll down to the Volumes section and click on the Add Storage link.

In the Add storage page, click on the small create storage link. Create the new storage with the desired values e.g.

Name
joget-data
Access Mode
Shared Access (RWX)
Size
1GB (or as required)


Back in the Add Storage page, select the newly created storage, set the Mount Path to /opt/joget/wflow, then Add.

Mount Path
/opt/joget/wflow
Step 5: Create Service Route for External Access
At this point, the service is not accessible from an external web browser so you will need to create a route, which exposes a service at a host name.

Click on Applications > Services and select joget-v6-enterprise.


Select Actions > Create Route, set the Path to /jw and click on Create.

Path
/jw


 Return to the Overview and click on the URL next to the application name to launch the Joget platform.



Deploy Joget using the OpenShift CLI

For those more inclined to use a non-graphical command line interface, it is actually faster to use the OpenShift command line interface (CLI) to deploy the Joget platform.

The following is a Linux script to accomplish a similar Joget platform deployment. Before running this script, install the CLI and login. Change the environment variables in the script accordingly, at least the four values below:

PROJECT_NAME
The desired project name
REGISTRY_USERNAME
Red Hat account username
REGISTRY_PASSWORD
Red Hat account password
REGISTRY_EMAIL
Red Hat account email


#!/bin/sh

export PROJECT_NAME=joget-openshift
export REGISTRY_USERNAME=email@domain
export REGISTRY_PASSWORD=password
export REGISTRY_EMAIL=email@domain
export REGISTRY_SERVER=registry.connect.redhat.com
export IMAGE_NAMESPACE=joget
export IMAGE_NAME=joget-v6-enterprise
export IMAGE_TAG=latest
export APP_NAME=joget-v6-enterprise
export DB_APP_NAME=joget-mysql
export STORAGE_NAME=joget-data
export MYSQL_DATABASE=jwdb
export MYSQL_USER=joget
export MYSQL_PASSWORD=joget

echo === deploy Joget on OpenShift ===
echo PROJECT_NAME: $PROJECT_NAME
echo REGISTRY_SERVER: $REGISTRY_SERVER
echo REGISTRY_USERNAME: $REGISTRY_USERNAME
echo REGISTRY_EMAIL: $REGISTRY_EMAIL
echo IMAGE_NAMESPACE: $IMAGE_NAMESPACE
echo IMAGE_NAME: $IMAGE_NAME
echo IMAGE_TAG $IMAGE_TAG
echo IMAGE_NAME: $IMAGE_NAME
echo APP_NAME: $APP_NAME
echo DB_APP_NAME: $DB_APP_NAME
echo STORAGE_NAME: $STORAGE_NAME
echo MYSQL_DATABASE: $MYSQL_DATABASE
echo MYSQL_USER: $MYSQL_USER
echo MYSQL_PASSWORD: $MYSQL_PASSWORD

echo === create project ===
oc new-project $PROJECT_NAME

echo === deploy MySQL ===
oc new-app openshift/mysql:5.7 --name $DB_APP_NAME -e MYSQL_USER=$MYSQL_USER -e MYSQL_PASSWORD=$MYSQL_PASSWORD -e MYSQL_DATABASE=$MYSQL_DATABASE

echo === create and bind secret to pull Joget image ===
oc create secret docker-registry $REGISTRY_SERVER --docker-server=$REGISTRY_SERVER --docker-username=$REGISTRY_USERNAME docker-password=$REGISTRY_PASSWORD --docker-email=$REGISTRY_EMAIL
oc secrets link default $REGISTRY_SERVER --for=pull

echo === import Joget image ===
oc import-image $PROJECT_NAME/$IMAGE_NAME --from=$REGISTRY_SERVER/$IMAGE_NAMESPACE/$IMAGE_NAME --confirm

#echo === grant pull permission if from different project ===
#oc policy add-role-to-user system:image-puller system:serviceaccount:$PROJECT_NAME:default -n $IMAGE_NAMESPACE

echo === deploy Joget ===
oc new-app $PROJECT_NAME/$IMAGE_NAME:$IMAGE_TAG -e GC_MAX_METASPACE_SIZE=300 --name $APP_NAME

echo === create persistent storage claim ===
cat <<EOF > pvc.yaml
apiVersion: "v1"
kind: "PersistentVolumeClaim"
metadata:
 name: "$STORAGE_NAME"
spec:
 accessModes:
   - "ReadWriteMany"
 resources:
   requests:
     storage: "1Gi"
EOF
oc create -f pvc.yaml
rm pvc.yaml

echo === mount storage ===
oc set volume dc/$APP_NAME --add --type=persistentVolumeClaim --claim-name=$STORAGE_NAME --mount-path=/opt/joget/wflow

echo === expose service route for external excess ===
oc expose svc $APP_NAME --path=/jw
oc annotate route $APP_NAME --overwrite haproxy.router.openshift.io/timeout=60s
oc get route
echo URL: http://$(oc get route $APP_NAME --template='{{ .spec.host }}')/jw

Setup Database

The first time the Joget platform is accessed, the Database Setup page will be displayed. Configure the database settings using the values defined when deploying the MySQL database previously e.g.

Database Host
jogetdb
Database Port
3306
Database Name
jwdb
Database User
joget
Database Password
joget


 Upon successful configuration, the Joget App Center will be loaded.
NOTE: If you encounter a 504 Gateway Timeout during the database setup, it is caused by the database initialization taking longer than the default OpenShift Route timeout. You can actually ignore the error and wait a couple of minutes before accessing the Application URL from the Overview page again.

You can also increase the route timeout using the OpenShift CLI i.e.
oc annotate route $APP_NAME --overwrite haproxy.router.openshift.io/timeout=60s


Build a Complete App in 30 minutes, No Code!

With the Joget platform ready, it is now possible to build a full-fledged app with dashboards, calendar, approval workflow and data management within 30 minutes. And, it can be done without coding and you essentially drag-and-drop, point-and-click and configure your way through instead. It’s also possible to use a touch device to build it.

The 30 minute video below demonstrates an authentic, real-time example of building the app from scratch.


Users can also download the Joget Mobile App from the Apple App Store and Google Play Store to access the very same app with the UI automatically tailored for mobile devices.

Get Started with Joget

To get started with the Joget platform:



Comments

Post a Comment

Popular Posts

No-Code, Low-Code and Pro-Code: Why Flexibility is Essential for Digital Transformation

By -
Image
Introducing Business Reporting and API Management Addons for Joget DX The COVID-19 coronavirus pandemic will be viewed in history as a significant point in human history. In the post-pandemic world, digital transformation can no longer be delayed and organizations need to adapt quickly, or perish, as the old ways of working no longer apply in the new normal. Based on Forrester’s Q1 2020 Digital Process Automation Survey , over 70% Of organizations still have paper-based process dependencies, as shown in the figure below. With a modern open source no-code/low-code platform like Joget DX , organizations can rapidly build, deploy and adapt applications to cater to ever changing needs. In this article, we will talk about the need for flexibility in application platforms to meet digitalization needs, and how the extensibility of Joget DX enabled the introduction of new add-ons for business reporting and API management . No-Code, Low-Code and Pro-Code: Flexibility and Extensibility There mi...
Read more

Security in Low-Code Applications: Cybersecurity Features and Best Practices for the Joget Open Source Platform

By -
Image
Introduction to Security Benefits and Risks in Low-Code Platforms As digitalization becomes increasingly prevalent, low-code platforms are rapidly gaining adoption across industries. Employing visual techniques to programming, they enable the development and delivery of applications in a fraction of the time required by traditional coding. According to Forrester’s Now Tech: General-Purpose Low-Code Development Platforms, Q1 2021 , low-code platforms are “vital to digital business” and “proven in even the most mission-critical use cases”. However, the proliferation of apps and digital solutions bring with it increased cybersecurity risks like phishing attempts and ransomware attacks. As the SolarWinds hack in 2020 and Microsoft Exchange hack in 2021 demonstrated, the cost of security lapses can be monumental. Security considerations are therefore paramount, so how would they apply to low-code platforms? Source:  Don’t Ignore Security In Low-Code Development, Forrester Research Inc...
Read more

Transforming Customer Onboarding: How Allied Benefit Systems Achieved Reporting Accuracy and Streamlined Business Processes with No-code/Low-code.

By -
Image
To optimize business operations and ensure accurate reporting, Allied Benefit Systems empowered business users and delivered a Customer Onboarding Platform built on no-code/low-code within three months. Effective onboarding processes play a crucial role in creating a positive impression on new customers. Yet, many businesses still need to rely on manual methods that can be time-consuming, error-prone, and inefficient. Allied Benefit Systems (Allied) , a US-based healthcare solutions company that prioritizes people, understands the importance of streamlined onboarding. As the largest independent third-party administrator in the US, Allied designs tailored self-insurance benefits solutions that integrate innovative medical management and cost-control strategies.   The company collaborates with clients and benefits consultants to institute plans that support the best options for employees and their families. However, Allied's existing onboarding process was managed through spreadsheet...
Read more

DISINI™ Vehicle Inspection & Insurance App

By -
Image
The DISINI™ Vehicle Inspection & Insurance App is an application that can be used standalone or in a composable application environment on the Joget DX low-code platform. Enterprises will be able to use the application to manage their fleet of vehicles, track insurance policies expiry and conduct regular vehicle inspections. Summary of the App features are: Track your vehicles' insurance policies and set email reminders of the renewals. Assign inspectors to conduct scheduled vehicle inspections. Supervisors will be able to set reminder notifications for the inspectors of upcoming vehicle inspections. Inspectors will be able to check their calendars for scheduled inspections that have been assigned to them. Create and manage inspection checklists templates for the many vehicle types. Inspectors will be able to update and check their Dashboard for inspection tasks. Supervisors will be able to keep track of all assigned inspection tasks and follow up accordingly. The following ar...
Read more

Superapps in the Enterprise: Up, Up and Away!

By -
Image
 “We think these applications are so compelling that we don’t just call them apps, we call them super apps… Super apps are applications that once you start using them, you’ll wonder just how you lived without them” - BlackBerry founder Mike Lazaridis. What is a Superapp?  In the early days of the smartphone revolution, BlackBerry founder Mike Lazaridis first coined the term “super app” (or “superapp”) in a MWC 2010 keynote speech . He defined them as “a closed ecosystem of many apps that people would use every day because they offer such a seamless, integrated, contextualized and efficient experience.” According to Gartner®, “a superapp is like a Swiss army knife with a range of component tools (miniapps) that the user can use and remove as needed”.  We consider superapps to be a single platform where miniapps are integrated, thus providing a seamless experience to its users. Here are some statistics and predictions from 2022 Gartner Top Strategic Technology Trends for 2...
Read more