Govt. of West Bengal uses AXPERT for Online Single Window Portal

The Government of West Bengal is creating a revamped Online Single Window Portal (OSWP) to improve the Ease of Doing Business in the State.

Investors and businesses may need multiple approvals from multiple departments before starting or operating a business. The online single window will have to provide the following functionalities:
a)    Single dynamic composite application form (CAF) for multiple services allowing an investor or a business to fill out one form for multiple clearances and approvals;
b)    Single Online Payment for multiple services through an integrated payment gateway with all modes of payment, viz., debit card, credit card, and net banking, enabled;
c)    Breaking the Composite Application Forms electronically into individual forms and sending the forms to the backend systems of various Departments electronically along with the corresponding proof of payment;
d)    Online tracking of the status of applications while they are being processed by various Departments;
e)    Online communication of approval; and
f) Downloading of approvals, NoCs, permits, clearances, etc. online.


The proposed Online Single Window Portal (OSWP) is intended to provide a Common Application Form (CAF) to the investor.

Investors can sign up for this portal and be verified using an OTP that is sent to their email and mobile. Every investor is uniquely identified through their email address and password. All user information is encrypted and stored in the database.

Each application form that is required to get approval for services provided by departments will be created as a form within the portal.

The forms are created using a meta-driven model. The data descriptors, validation rules, and computation rules about every element in the form and the form layout are stored as part of metadata within the database in an encrypted format.

The CAF is a dynamic aggregation of forms related to getting approvals for multiple services that may be required to set up the desired business. The CAF is generated by dynamically aggregating the metadata of each selected form.

On submission of data in CAF, the data related to each department will be sent to the respective departments and updated in their applications.

Subsequent processing for approvals will happen within applications in that department. Periodic status updates will be provided by the respective applications to the online single window portal (OSWP). The portal will in turn provide status updates to the investor through emails and SMS.

Integration requires the creation of a seamless flow of data from the OSWP to a Department and from a Department to the OSWP. The traditional method of writing a bunch of web services on the OSWP side (to be consumed by the Department’s systems) and on the Department’s side (to be consumed by the OSWP system) can always be done but is not recommended under the circumstances where stringent timelines have been prescribed and the single window system needs to be created by May 2017. The reasons for this are twofold: firstly, writing web services correctly in a short time requires a certain level of skills for developers and vendors, which may not be available with SIs and IT vendors of all departments; and secondly, integration testing of web services typically requires a lot of time because of the time taken in designing and developing the exception handling process. That is why integration through the traditional method of writing web services typically requires 9 to 12 months. Integration is, therefore, proposed through the use of Axpert Data Exchange (ADE) and Axpert Data Router (ADR) which would achieve integration at the data layer without web services.

For the purposes of integration, the departments are classified as below based on the sophistication of IT systems within a Department and its readiness for integration:

Type A departments – Some departments that already have applications (online systems) and that would be integrated with the OSWP are classified as Type A Departments.

Type B departments – The departments that do not have applications (currently manual) but which need to be integrated with OSWP by providing workflows on the OSWP are classified as Type B Departments.

Type C departments: Departments that offer stand-alone online services but are not integrated with OSWP are classified as Type C departments.

The workflow for a Type B Department will be built on OSWP and the services related to that Department will be naturally integrated with OSWP.

The OSWP will be implemented on a Rapid Application Development platform named Axpert.


Axpert is a RAD platform on which apps can be developed with 50% of the time, effort, and skill required to build an app using traditional programming languages. Apps are developed on Axpert by only defining the data structures, workflow, and business rules on the fly using a simple and intuitive Axpert IDE. There is no need to write code in the business or presentation layer.

Axpert architecture is completely SOA-based and works on a Microsoft Dot net framework on a Windows server. There is no need to write web services or REST services to create apps. Axpert also comes with a data router and exchange apps that enable seamless and secure data exchange with other apps at the database level.

Axpert comes with features for on-the-fly form, report, and workflow definition and rendering. There is no need to code any of these. The data of forms is stored in standard RDBMS (Oracle, MySQL, and MS SQL).

The security standards that are followed for any distributed RDBMS-based application can be applied to Axpert applications to ensure maximum data security. A robust access control layer that comes with Axpert ensures maximum data safety. This gives complete control to the app administrator to restrict access to data for relevant user groups.

Axpert is now used by more than 20,000 users across 10 countries. The users include Government, defense, and large corporations. There are 100+ mission-critical apps running on Axpert. Its lean architecture makes it robust and reliable.


This project has to be completed within 5 weeks. Nearly 130 services have to be either newly created or integrated with the online portal.

Such a project cannot be done in a short time by writing code in high-level programming languages. It can be done only on metadata-driven platforms. Further, the platform should have the capability to integrate with other apps both on the web services layer and the data layer.

Axpert provides the capability

  • To create services for citizens along with the backend workflow within a very short time. A service could be made online within a couple of weeks.
  • To aggregate the forms dynamically and create one single common access form based on user selection. This can be achieved only if the apps are defined on a full metadata-driven model.
  • To integrate with apps that do not have web services capability at a data layer.
  • To integrate with apps that offer web services at the service layer.
  • Create wizard kind of facilities.

The architecture also should conform to the CERT-IN security recommendations to ensure data security and access control. This proposed architecture based on Axpert rules out any danger from site scripting, SQL injection, identity theft, network eavesdropping& unauthorized access.

Hence, Axpert was found to be a suitable platform that met all the customer expectations which was proved by doing a proof of concept by Agile Labs.


OSWPOnline single window portal
ADRAxpert data router – Windows app that will read encrypted data packets and write them into a database.
ADEAxpert data exchange – Windows app that will exchange encrypted data over HTTPS
STSStaging server – A file server in the data center that is hosted in the OSWP data center.
DAppDepartment application.
OSWPOnline single window portal
DServerDepartment server
CAFCommon Application Form
RADRapid application development

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest Photos
Get notified of the best deals on Formonix
Follow us
What they say

Related Posts

Akshaya Rangarajan

The Tech Revolution -Axpert’s Role in Digital Transformation

In a world driven by technological advancements, digital transformation has become the cornerstone of sustainable business growth. At the forefront of this revolution stands Axpert, our award-winning low-code application development platform, ready to redefine how businesses operate in the digital age. Unveiling the Essence of Digital Transformation: Digital transformation is not just about adopting new

Read More
Akshaya Rangarajan

LCNC Versatility Redefined – Axpert’s Impact on Your Tech Armor

In the ever-evolving landscape of technology, versatility stands as a cornerstone for success. Our Agile Labs, nestled in the bustling tech hub of Bangalore, takes pride in introducing Axpert—a revolutionary low-code platform that redefines versatility in application development. Adapting to Diverse Business Needs: At the heart of Axpert’s success lies its remarkable ability to adapt

Read More
Akshaya Rangarajan

Transforming People Management with Axpert – Empowering Organizations for Success

In today’s dynamic business landscape, effective people management stands as a cornerstone for organizational success. Axpert, a leading Low-Code/No-Code (LCNC) platform, emerges as a transformative tool empowering businesses to streamline and elevate their people management processes. Streamlined Talent Acquisition and Onboarding : Efficient Recruitment Workflows Axpert simplifies and automates recruitment processes. Customizable workflows enable HR

Read More