Your data platform, on your own servers
Pipelines, warehouse, dashboards and access control in one product that your team installs and runs.
The problem
Most data teams juggle five to ten tools every day
Each tool brings its own login and its own upgrade cycle. Wiring them together is the hard part.
- Ingestion
- Change capture
- Scheduler
- Warehouse
- Transformation
- Dashboards
70%
of senior data professionals manage 5 to 10 tools daily
85%
rank integration among their top three challenges
Source: The Modern Data Company / Modern Data 101, “2024–2025 Modern Data Report”, 21 Aug 2025.
Architecture
Solenoid runs every engine in your stack and carries context across them
Change streams from core systems, file pickup, SQL models, dashboards, lineage and sign-in come in one package. You install it once, on hardware you choose, and staff sign in once.
Your systems
-
SQL Server -
Files and PDFs
- Change capture
Debezium - Event stream
Apache Kafka - File flows
Apache NiFi - Orchestration
Apache Airflow - Transformation
dbt
- Warehouse
ClickHouse - Object storage
RustFS - Dashboards
Apache Superset - Sign-in
Keycloak - Secrets
OpenBao
Context shared across every engine
- Catalog and lineage
- Schedules and runs
- Access and secrets
- Data tests
adapter →Each capability sits behind an adapter. Use the engine shown, or connect one your team already runs.
A local AI assistant, running inside the platform
Solenoid now includes an AI assistant that runs on your own servers, next to the engines above. Ask a question in plain language and get the query behind the answer, while prompts and data stay inside your network.
-
Catalog and lineage
Every table shows where its data came from and which dashboards, APIs and notebooks read it.
-
Schedules and runs
Steps dragged onto a canvas run as a scheduled pipeline, with retries, an on-failure action and full run history.
-
Access and secrets
Staff sign in with their company account and get a role from Viewer to Admin. Connection passwords sit in a vault.
-
Data tests
When a test fails, the dashboard keeps its last good data until someone fixes the rows.
Solenoid with AI
Ask Solenoid in plain language, about your data or your pipelines
The assistant runs on a local model inside your network, so prompts and data stay on your servers.
One platform
Every data task starts from one sign-in and one catalog
- 01
Connect
Data from core systems and file drops, as it changes.
-
Change streams
Each committed change in your core lending system is read from the database log and streamed into the warehouse as it is written.
-
Files and PDFs
Point Solenoid at a folder. It picks up each new file, reads PDF text too, and tracks each file until it loads.
-
- 02
Build
Turn raw data into tables people can trust.
-
Job editor
Write SQL or fill in a form, then preview the first rows against real tables before the job goes live.
-
Pipeline builder
Drag steps onto a canvas and Solenoid runs them as a scheduled pipeline.
-
- 03
Use
One set of tables for every reader, from SQL to dashboards.
-
SQL editor
Warehouse and raw tables sit side by side, and streamed core data joins in the same query.
-
Dashboards
Dashboards read the tables your pipelines build and show how fresh each one is.
-
Notebooks
Python cells read warehouse tables directly, under the same permissions as dashboards.
-
- 04
Trust
Know where every number came from, and who can see it.
-
Data tests
Tests catch bad data before a dashboard shows it.
-
Assistant New · local AI
Ask in plain language. Every answer names its tables and shows its SQL, so an analyst can check it first. The assistant runs on a local model inside your network.
74%
say business users usually find data issues first.
Monte Carlo / Wakefield Research, 2023.
-
Our commitments
Four commitments, starting with your data staying on your servers
Solenoid is software your team installs and runs. Matajari delivers it and supports your team.
-
Your servers
Installs on-premises or in your private cloud, so data stays in Indonesia, OJK’s default for finance.
-
Open engines
Airflow, Kafka, ClickHouse, dbt, Superset and NiFi run underneath, all open source.
-
No code for analysts
Forms and a drag-and-drop canvas for analysts. Engineers can still write code.
-
Predictable cost
A licence or subscription with no usage meter. A busy month costs what a quiet one does.
Rollout
A rollout starts with one source and one report
One report
Install Solenoid on your servers and rebuild one existing report from one live source.
More sources
Bring in further databases and file folders, with tests on every new table.
Analysts build
Analysts take over routine pipelines with forms and the canvas.
Your team runs it
Your engineers own upgrades and access, with Matajari as support.
Frequently Asked Questions
Everything you need to know about Solenoid.