Person standing inside a computer overlooking neatly positioned components

Domain-Driven Design Powered by Db2 and SQL Models

Sitemule Architect analyzes existing Db2 databases to generate Domain Model Definitions, enabling the creation of modern, unified, and data-driven applications and microservices.

Features

Sitemule Architect empowers organizations to modernize and extend IBM Db2 databases into fully relational SQL models - enabling the creation of no-code applications and workflows while maintaining complete ERP compatibility.

Model Studio

Model Studio

Visualizes data modeling, application design, and rapid deployment, enabling organizations to transition from legacy infrastructures to modern, web-based enterprise applications with minimal disruption.

Simplicity Makes Everything Possible

Simplicity Makes Everything Possible

Orchestrating advanced applications with unseen built-in, user-friendly functionality by a combination of three types of fundamental building blocks: Grid Views, Forms, and Tree Structures.

Domain Model Design

Domain Model Design

Adopt a domain-driven approach to transform rigid legacy systems into flexible, service-oriented architectures, fostering faster innovation, simpler maintenance, and long-term digital resilience.

Enrich & Extend

Enrich & Extend

Import existing Db2 definitions into the designer and enrich them with metadata for relations, constraints, validations, presentations, and accessibility. Extend Db2 files with new fields seamlessly - without downtime or disruption.

Supports Unstructured Data

Supports Unstructured Data

Store unstructured data in flexible JSON structures defined by property descriptions, enabling their presentation as dynamic fields within Db2 records - securely managed and protected by Db2 as CLOB fields.

Unified UI, Unified Architecture

Unified UI, Unified Architecture

Applications created with Architect share a consistent visual identity and functionality with those transformed in Workspace or custom-built in Enterprise. A unified architecture ensures seamless interoperability across all application types.

Intuitive Business Intelligence

Intuitive Business Intelligence

Gain comprehensive insights through data modeling, filtering, sorting, grouping, and multi-format export, supported by dynamic visualizations across diverse chart types for enhanced decision-making.

No-Code Tool

No-Code Tool

Bridge the gap between business expertise and technical development. Architect empowers teams across departments to collaborate, innovate, and accelerate digital transformation - all without writing a single line of code.

What is Architect?

Artificial head with speed motion trails

The Interface Between People and ERP Data

Sitemule Architect transforms raw IBM i ERP data into structured, usable information. It gives business users a visual, consistent way to manage and act - no technical expertise needed.

hands pointing at diagrams on printed paper on desktop

Clarity and Speed for Data-Driven Teams

Whether HR, finance, logistics, or compliance - teams instantly find what they need, apply filters, and export usable data. No bottlenecks. Architect speeds decisions and streamlines workflows from day one.

Hands moving transparent cubes around on futuristic glass table

A Modeling Engine Built for Change

With Model Studio, businesses can visually build and update ERP data structures - without coding. It supports new use cases, reduces backlog, and boosts agility.

Use Cases

person in ironed shirt sitting on desktop working on a labtop

Department-Level Salary Analysis in HR

HR departments often face delays when requesting salary breakdowns by department, seniority, or role. Even basic data like workforce distribution or compensation averages can require IT involvement or days of processing. With Sitemule Architect, HR teams can access employee data directly - filter by department, group by pay grade, and visualize trends instantly. Users work in a familiar grid or open detailed records in structured forms.

 

Accelerate decision-making by removing reporting bottlenecks.

person cross checking printet info with digital data

Reconciliation and Transaction Review in Finance

Month-end reconciliation is often slowed by scattered records, limited search tools, and manual data matching. Finance teams must validate transactions using exported spreadsheets and disconnected sources. Architect allows users to search across fields, compare forms side by side, and apply filters to isolate discrepancies. Saved views ensure consistency, while structured exports streamline audits.

 

Simplify validation and improve financial control.

Two people working late project managing moving postit notes into place on a white board

Supplier Performance Tracking for Procurement

Procurement teams often work with fragmented supplier information - spread across systems, emails, and outdated documents. Tracking contract terms, delivery issues, or order history becomes time-consuming and error-prone. With Architect’s Tree View, teams get a hierarchical, connected view of suppliers, contracts, and performance data. Drag-and-drop tools and filters make it easy to restructure and act quickly.

 

Bring clarity to complex supplier networks.

womens hand dragging element across tablet display

Application Deployment Without Code for IT Teams

IT teams face constant requests for internal tools and reports, many of which require coding, testing, and deployment - slowing delivery and increasing backlog. Architect removes that barrier. With Model Studio, IT can define data models, apply rules, and publish secure applications visually. Tools are ready in minutes, and access is role-controlled through Portfolio.

 

Deliver new tools faster - without adding to your backlog.

About Sitemule Architect

Build Modern Applications from Legacy Data

 

Sitemule Architect transforms rigid, legacy-based environments into flexible, domain-driven, service-oriented architectures. It empowers organizations to innovate more quickly and respond more dynamically to changing business demands by redefining how IBM i applications are designed, structured, and extended.

 

Domain-Driven Application Development

The platform analyzes existing Db2 databases to generate domain models serving as the foundation for modern, data-driven applications and microservices. Applications can be designed, customized, and deployed intuitively without manual coding, establishing a robust, future-proof application framework. The Domain Model Definition is published as a fully functional web application with role-based access control.

 

Model Studio Visualization

Model Studio visualizes data modeling, application design, and deployment processes. It easily imports legacy Db2 structures and enhances them with metadata for relations, constraints, validations, and presentation logic. Powered by the Blueprint Engine, Sitemule Architect supports domain segregation and the division of existing databases into smaller, manageable domains. 

 

As an extension to the existing Db2 files, organizations can even add new fields, validations, and data extensions without downtime or risk. The result is a unified, consistent data layer supporting both structured and unstructured data through secure JSON-based extensions managed directly within Db2. 

 

The Model Studio provides a complete visual overview of all connected tables, relationships, and entities. Each entity represents a table that can be enriched with metadata, and by adjusting visibility, sorting, and permissions, organizations can tailor how data is displayed and managed. Integration with external tools such as Google Maps, Microsoft Office, and PDFs further extends functionality by bridging internal systems with familiar external platforms.

 

Advanced Grid and Interface Capabilities

Sitemule Architect provides a complete data overview with search, filtering, grouping, and sorting across all columns. Users can export data in various formats for use on local PCs. The platform integrates options and screens from 5250 programs through Sitemule Workspace, using a scripting method to simulate the user journey to specific options or functions, then popping up emulated 5250 screens. The modernized interface reuses underlying business logic.

 

Consistent Application Design

Sitemule Architect is powered by the Portfolio Engine and therefore shares a consistent interface and operation with applications modernized in Sitemule Workspace or deployed via Sitemule Enterprise. Intuitive components include grids, forms, and tree structures. Workflow logic can be visually defined and tailored to meet specific business needs, resulting in cohesive, interactive user experiences.

 

No-Code Development Environment

The platform bridges the gap between business and IT, enabling domain experts to participate directly in application design and process improvement without programming knowledge. This accelerates development cycles, reduces reliance on specialized resources, and strengthens collaboration across departments.

 

Business Intelligence Integration

Sitemule Architect makes complex data easy to understand and act upon. Users can model, filter, sort, and group data, then visualize it through dynamic charts and reports. This supports data-driven decisions and provides real-time insights.

 

Organizations achieve rapid application development with complete control over IBM i data. Legacy programs are incorporated as fully integrated components. Substantial, decades-old libraries are managed into functional domains without changing underlying files, providing effective domain organization. Subfile constraints are replaced with modern grid views, offering enhanced functionality. The seamless addition of metadata and structures creates an enriched data layer. Non-technical experts can participate in development, thereby empowering businesses. Legacy data is transformed into actionable insights for better decision-making.

 

Implementation Timeline

Successful modernization transforms inflexible legacy systems into adaptable, service-oriented architectures, speeding up development, enhancing maintainability, and aligning technology with business goals, all accomplished within months without disrupting existing systems.

The Companies We Help

We provide solutions and services that support both standard and tailor-made systems for companies worldwide, serving a wide range of industries such as banking, finance, insurance, manufacturing, retail, logistics, and beyond. Let us help you - get in touch today!

Molslinjen A/S

Molslinjen A/S

Connecting people, regions, and experiences
Uno-X

Uno-X

Fueling cleaner mobility, energy access, and everyday simplicity
ABN AMRO

ABN AMRO

Empowering innovation, sustainable finance, and inclusive progress
Co-Ownership

Co-Ownership

Redefining ownership, affordability, and community living
Berry Superfoss

Berry Superfoss

Driving circular packaging, customer value, and smarter logistics
Santander Bank

Santander Bank

Enabling financial confidence, smart mobility, and personal growth
Get in Touch
Please select