Skip to main content
1

Platform Overview

Understanding EPA and the AUD Platform

EPA (Excel Process Automation) is powered by the AUD Platform — a comprehensive solution for developing business system interfaces. It consolidates BI tools, reporting tools, visualization tools, UI/UX tools, and development capabilities into one unified system.

Using low-code AI technologies, the platform enables structured/unstructured reports, OLAP, dashboards, and rapid web screen development — allowing non-programmers to create business applications intuitively.

All-in-One Platform

BI, Reporting, Dashboard, Visualization, and UI/UX development in a single unified platform.

No-Code / Low-Code

AI-powered SW Robots automate SQL and JAVA coding, enabling non-programmers to build systems.

Big Data Analytics

Proprietary big data processing with Hadoop, R, and Splunk integration for enterprise-scale analysis.

Multi-Device HTML5

HTML5-based with no plug-in required. Auto-sizing for mobile phones and various devices.

2

Core Technology — SW Robots

AI-powered No-Code/Low-Code development technologies

SW Robots are AI-powered technologies that significantly enhance productivity by automating SQL and JAVA coding processes. The suite includes three components, each automating repetitive, rule-based tasks for data analysis and system development.

DB Bot

Automates the generation of SQL queries (Select, Insert, Update), enabling efficient data retrieval and storage in databases without writing complex SQL code.

Auto SQL Generation CRUD Operations DB Connectivity

UI Bot

Automatically converts user-designed Excel screen layouts into HTML5 web screens. Leverages Excel features such as formatting, formulas, and fixed headers for seamless web integration.

Excel to HTML5 Web UI Automation Layout Conversion

Process Bot

Automates the implementation of events and business logic. Generates JavaScript code, handles event processing, input validation, and visualizes step-by-step process flows on a workflow interface.

Business Logic Event Handling Workflow Visualization
3

Platform Functions

Comprehensive capabilities for enterprise development

Web Interface Development

Build web interfaces effortlessly without coding by utilizing Excel-based UI design tools.

Easy CRUD Generation

DB Bot simplifies CRUD operations. Quickly generate List-style or Analysis-style input interfaces with minimal configuration.

Diverse Charting Options

Wide range of charts, graphs, and conditional formatting. Supports integration with external open-source visualization tools.

Security & Access Control

Granular permissions at user, folder, and group levels. SSO, OTP, encryption modules, and activity logging.

Export & Print

Built-in automatic generation of export and print functionalities without separate interface development.

Freeze Function

A feature typically challenging in web environments — freeze rows and columns is included as standard functionality.

4

What EPA Enables for Organizations

Why enterprises choose EPA

1

Enhanced Development Productivity

SW Robots automate SQL and JAVA coding, dramatically reducing development time. Non-IT professionals can create business applications intuitively.

2

Cost Savings

Reduced developer requirements through automation. A single platform replaces multiple separate tools (BI, reporting, visualization, UI/UX), lowering both initial investment and operational costs.

3

Enterprise Big Data Processing

Proprietary big data processing technology handles hundreds of millions of records efficiently. Server-side data aggregation and transformation avoid memory limitations.

Real-world performance: Government settlement system reduced query time from several minutes to under 10 seconds. Product analysis system delivers 160M records in 5 seconds.
4

Broad Data Source Support

Connect to virtually any database that provides a JDBC driver.

Oracle MS SQL MySQL PostgreSQL DB2 MariaDB Tibero Teradata RedShift Hadoop
5

System Requirements

Server specifications and user environment

AUD Server Requirements

Component Minimum Recommended
OS Linux (RedHat, CentOS 7.x+, Ubuntu 18.x+), Windows Server 2008+, UNIX (AIX 7.1+, Solaris 9+)
CPU 4 cores 8+ cores
Memory 16 GB 64 GB+
Storage 10 GB 50 GB+ (20GB screens + 30GB temp)
WAS JDK 1.8~11 — Weblogic, Tomcat, JBoss

Browser Compatibility

OS IE 11 Chrome 3.x+ Edge 101.x+
Windows 7/8 Limited Limited Limited
Windows 10 Limited Supported Supported
Windows 11 Limited Supported Supported

Excel Compatibility (i-MATRIX)

OS Excel 2013 Excel 2016 Excel 2019 Excel 2021 Office 365
Windows 7/8 Limited Limited Limited Limited Limited
Windows 10 Supported Supported Supported Supported Limited
Windows 11 Supported Supported Supported Supported Limited

* Supports 32/64-bit architectures. Standard virtualization and VDI environments supported.

6

Sample Reports

Explore real EPA reports in popup view

Click any sample below to open an interactive report popup and see how EPA transforms Excel data into web-based reports.

Best viewed on desktop for full interactivity.

Have Questions?

Check our comprehensive FAQ page or contact our support team for help.