OpenL Tablets 101
OpenL Tablets 101
September 3, 2024
OpenL Tablets is a powerful business rule management system (BRMS) that leverages Excel spreadsheets for defining and managing business rules. To effectively use this tool, it’s essential to grasp the following:
- https://github.com/openl-tablets/openl-tablets - Easy Business Rules
OpenL Tablets Core Concepts 📌
Rule Tables:
- Decision Tables: The most common type, used for expressing rules with multiple conditions and actions.
- Decision Trees: Visual representation of decision-making processes, often used for more complex rules.
- Spreadsheet-like Calculators: For straightforward calculations and data manipulation.
Rule Structure:
- Conditions: The criteria that must be met for a rule to fire.
- Actions: The steps taken when a rule is triggered.
- Return Values: The output or result generated by a rule.
Rule Execution:
- Rule Engine: The component responsible for interpreting and executing rules based on input data.
- Rule Evaluation: The process of determining whether a rule’s conditions are met.
- Rule Firing: The execution of a rule’s actions when its conditions are satisfied.
Rule Management:
- Rule Repository: A centralized location for storing and managing rules.
- Rule Versioning: Tracking changes to rules over time.
- Rule Deployment: The process of making rules available for use in applications.
Integration:
- API Integration: Connecting OpenL Tablets to other systems or applications through APIs.
- Data Integration: Importing and exporting data between OpenL Tablets and external sources.
Excel-based Development:
- Excel Templates: Pre-defined structures for creating rule tables.
- Excel Functions: Using Excel functions within rule expressions.
- Excel Formatting: Applying formatting to rule tables for better readability.
Business Rule Governance:
- Rule Validation: Ensuring the accuracy and consistency of rules.
- Rule Testing: Verifying that rules function as intended.
- Rule Documentation: Providing clear explanations and documentation for rules.
- SpreadSheet Tables
- Simple LookUp
- LookUp Table
- Smart Decision Tables
You can run OpenL Tablets Demo example with Docker 📌
version: '3.8' # Using version 3.8, but you can use other versions as appropriate
services:
openltablets-demo:
image: openltablets/demo # Specify the Docker image to use
container_name: openltablets-demo # Optional: Specify a custom container name
ports:
- "9088:8080" # Map port 9080 on the host to port 8080 on the container
restart: unless-stopped # Optional: Ensures the container restarts unless explicitly stopped
After a while, it will be accesible:
http://localhost:9088/webservice/
http://localhost:9088/
Run OpenL Tablets with Docker 📌
Because you dont want to download java 11, then go to openl tablets and to the current version demo 5.27.7…
Let’s do it with Docker instead - https://hub.docker.com/u/openltablets/
And the WebStudio - https://hub.docker.com/r/openltablets/webstudio
version: '3.8' # Using version 3.8, but you can use other versions as appropriate
services:
openl-webstudio:
image: openltablets/webstudio # Specify the Docker image to use
container_name: openl-webstudio # Optional: Specify a custom container name
ports:
- "9086:8080" # Map port 9080 on the host to port 8080 on the container
restart: unless-stopped # Optional: Ensures the container restarts unless explicitly stopped