Survey of Rule Engines
- Chris Moffatt (Deactivated)
Owned by Chris Moffatt (Deactivated)
Inventory of Open Source Rules Engines
| Candidate | URL | Slogan | Category | Technology Stack | Scheduling Functionality | Initial Thoughts | Licensing |
|---|---|---|---|---|---|---|---|
| Open Refine | http://openrefine.org/ | A free, open source, powerful tool for working with messy data | Big Data | Requires JAVA JRE | none found | More focused on unstructured data, sound-ex and fuzzy matching features could play in for more advanced validation later on. Could play well with pre-submitted cleanup | A permissive license similar to the BSD 2-Clause License, but with a 3rd clause that prohibits others from using the name of the project or its contributors to promote derived products without written consent. |
| Griffin | https://griffin.apache.org/ | Big Data Quality Solution For Batch and Streaming | Reporting tool with scheduling | JDK/ Hadoop/Spark | No | big data focus does not seem like the right fit. More about measuring data quality then identifying specific instances of bad data | Open Source (apache 2) |
| Seal Report | https://sealreport.org/ | The ultimate open database reporting tool | ETL tool | Has GUI task scheduler | Could work well, especially if the LEA was interested in the visualization features | Open Source (apache 2) | |
| Talend | https://www.talend.com | Rules Engine | not sure | No | More about validating data during ETL then after it is already in the ODS perhaps? | Commercial w/ an Open source version | |
| Open Rules | https://openrules.com/ | Business Rules and Decision Management System | Rules Engine | Excel + Java + Eclipse | not sure | Like Drools with the Excel tie in | GPL |
| Drools | https://www.drools.org/ | DB unit test infrastructure | Java / browser / eclipse | not sure | Would handle complex if/then flows | GPL | |
| dbfit | http://dbfit.github.io/dbfit/ | Test-driven database development | DB testing infrastructure | .NET or JAVA xUnit test framework | No | Focused on database development in a CI environmet | GPL |
| DB Test Driven | http://www.dbtestdriven.com/ | Database test driven development for everyone | DB testing infrastructure | installs natively on MS SQL Server database | not directly | focused on database development in a test-driven development environment | freely available for download. Could not find mention of license |
| tSQLt | https://tsqlt.org/ | THE OPEN SOURCE DATABASE UNIT TESTING FRAMEWORK FOR SQL SERVER | BI unit testing infrastucture | SQL Server / tSQL | not directly | More focused on testing database code then actual data but could be leveraged | Open Source (apache 2) |
| NBi | http://www.nbi.io/ | open-source framework to test your Business Intelligence solutions | Scheduling App | XML config files that feed into NUnit (.NET flavor of xUNIT) | not directly | More focused on testing database code then actual data but could be leveraged | Open Source (apache 2) |
| Quartz Scheduler | http://www.quartz-scheduler.org | open source job scheduling library that can be integrated within virtually any Java application | Organizational process automation infrastructure | JAVA | Yes | Open Source (apache 2) | |
| Run Deck | https://www.rundeck.com/ | The Platform for Self-Service Operations | Scheduling App | JAVA | Yes | Site Reliability Engineering (SRE) focus. Could potentially automate or facilitate organizational processes outside of data validation | Commercial w/ an Open source version |
| SOS Berin Job Scheduler | https://www.sos-berlin.com/jobscheduler | Open Source solution for enterprise level workload automation. | Scheduling App | runs as Linux or Windows Service, GUI / database configuration | Yes | Open sourcer or commercial (supported) | |
| ScheduleX | http://www.schedulix.org/en | The Open Source Enterprise Job Scheduling System | Native Linux with a windows port | Yes | AGPL licence |
Inventory of Rules Engines in the Ed-Fi Ecosystem
| Ed-Fi Implementation | Type | Rule Engine | Status | Links | Notes |
|---|---|---|---|---|---|
| Wisconsin DPI | SEA | WI Rules engine (Home grown) | In production | Summit presentation (2016) | |
| Arizona DOE | SEA | InRule (Commercial) | In production | ||
| TN DOE | SEA | InRule (commercial) | In production | ||
| Michigan Data Hub | Collaborative | Michigan Rules Engine (DLP) | In production | Summit presentation (2016) | |
| Indiana DOE | SEA | InRule (Commercial) | In development | ||
| Minnesota DOE | SEA | Michigan-derived (DLP) | In development? | ||
| New Mexico DOE | SEA | Data Validation and Rules Engine (DVRE) | On the shelf | Available in Ed-Fi Exchange | |
| West Ada | LEA | Evaluating options | Eval | Need identified; Evaluating options | |
| YESPrep | LEA | Evaluating options | |||
| SFUSD | LEA | Evaluating options | |||
| Oregon Nexus | Collaborative | Evaluating options | Requirement: Comparing ODS w/ source systems | ||
| Certify product (Certica) | Product vendor |