A standalone ASP.NET Core web application — not a Creatio configuration package — that reports on Creatio business-process execution by reading the platform's log directly from its Oracle database.
Exposes a statistics endpoint (/Statistics/Processes) that queries the process log and returns each entry with its name, start date, status and duration expressed in minutes, hours and days. The intent is operational visibility: spotting processes that hang, run long, or fail, without going through the Creatio UI.
| Project | Role |
|---|---|
SystemNotifier |
ASP.NET Core web app (.NET 9) — controllers, models, static assets, Dockerfile |
SystemNotifier.DB |
data-access library — Oracle connector, ProcessLog model, ProcessOperator queries |
Data access uses Oracle.EntityFrameworkCore and Oracle.ManagedDataAccess.Core. The solution ships a Dockerfile, so it was built to run as a container alongside the Creatio instance.
The Oracle connection string lives in appsettings.json. Its host, service name, user id and password have been blanked in this copy — supply your own before running:
"ConnectionStrings": { "OracleContext": "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ) (SERVER = DEDICATED)));User Id=;Password=" }
Written from my own work on Creatio integrations; published as a reference implementation, no client data included.