AW-10865990051
How IOblend works · Engineering overview

From pipeline intent to production Spark.

Design the dataflow. Keep the logic portable. Let IOblend handle the execution plumbing. IOblend separates pipeline design, business rules and metadata from the infrastructure underneath—then turns that intent into production Apache Spark jobs inside the environment you control.

Visual DAG development SQL + Python logic Portable JSON playbooks Managed Spark execution
IOBLEND · PIPELINE EXECUTION MODEL Design → metadata → engine → runtime
01
IOblend Designer Build, test and inspect the pipeline DAG before deployment.
visual
{ }
Portable JSON playbook Store configuration, parameters and repeatable pipeline intent.
versionable
IO
IOblend Engine Interpret metadata and manage how the production pipeline executes.
runtime
SP
Apache Spark Run distributed batch and streaming workloads on infrastructure you control.
your infra
DataOps Lineage · quality · schema · state
Delivery Batch · streaming · CDC · AI
Deployment Cloud · on-prem · hybrid · edge
Metadata-drivenPipeline intent stored separately from runtime infrastructure
Standards-based logicSQL, Python and JSON instead of proprietary transformation languages
Apache Spark runtimeDistributed execution without making every developer a Spark specialist
Customer-controlledRun where your data and security model already live
The architecture in one sentence

The logic is yours. The execution complexity is not.

IOblend is a metadata-driven production data layer. Engineers describe what a pipeline should do in Designer, store that intent as reusable JSON metadata, and let IOblend Engine convert it into the Spark processing required to run across enterprise systems.

For live data, IOblend supports database CDC and can also connect to Kafka to read streaming messages.

Designer JSON playbooks IOblend Engine Apache Spark SQL / Python CDC + streaming
Sources

Your enterprise systems

Keep the technologies the organisation already depends on and bring batch, change data and live message streams into the same production layer.

ERP / CRM SAP · Salesforce · Dynamics 365
Databases + CDC Oracle · SQL databases · PostgreSQL · changed records
Kafka + event streams Read live messages and process the stream in flight.
IoT / telemetry Operational events · machine and device data
Files / APIs Structured and unstructured enterprise inputs
Independent production layer

IOblend

Pipeline design, DataOps and execution management in one operating model.

Visual pipeline DAG Build and inspect flows in Designer
Portable pipeline intent Reusable JSON metadata and playbooks
SQL + Python rules Transformation and business logic
Streaming + state CDC · batch · live event processing
Managed execution Apache Spark on customer-controlled infrastructure
Consumers

Where data is needed next

Serve the destination without rebuilding your architecture around IOblend.

Lakehouse / warehouse Fabric · Databricks · Snowflake · analytics
Operational applications Real-time synchronisation and activation
AI / agents Fresh, governed enterprise context
Downstream systems Trusted data delivered where operations need it
Incremental change Capture inserts and updates through CDC instead of repeatedly rebuilding full copies.
Live event processing Process streaming data continuously alongside slower-moving enterprise sources.
One downstream operating model Apply transformation, quality, lineage and routing regardless of whether data arrived by batch, CDC or stream.
01 · Metadata-driven development

Describe the pipeline once. Keep the intent portable.

IOblend playbooks store pipeline configuration, run parameters and business logic as JSON metadata. The Engine interprets that metadata at runtime instead of hard-wiring pipeline behaviour to a proprietary execution environment.

PORTABILITY

Your business logic is not trapped in a visual canvas.

Pipeline definitions are files. Transformations can remain in standard SQL and Python, making the important logic visible and reusable.

VERSIONING

Treat pipelines like software, not configuration folklore.

JSON playbooks can sit in normal code repositories and participate in source-control, review and release workflows.

REUSE

Turn working patterns into repeatable building blocks.

Components, configuration and logic can be reused rather than reconstructed every time a similar integration appears.

DECOUPLING

Change infrastructure without rewriting the business idea.

Storage, compute and pipeline intent are separated, reducing dependence on one destination, cloud or processing location.

02 · Build + validate

Visual development without black-box engineering.

Designer accelerates how teams compose a DAG, but engineers still retain SQL and Python for specialised transformations, quality policies and business rules.

01

Build one component at a time

Add sources, transforms and sinks to the DAG and validate them as the pipeline takes shape.

02

Inspect schemas, metadata and run behaviour

Use development mode to see what each component is doing instead of debugging an opaque distributed job after deployment.

03

Prevent invalid logic from moving forward

IOblend's development workflow checks pipeline logic and SQL/Python execution before production deployment.

04

Retain revisions and move through CI/CD

Successful development runs validate the completed pipeline while revisions remain available for comparison and rollback.

playbook.customer_sync.json revision 24 · validated
{ "pipeline": "customer_360_sync", "mode": "streaming", "source": "oracle_erp", "transform": { "language": "sql_python", "quality_gate": true, "deduplicate": true }, "sink": "lakehouse", "lineage": "record_level" }
✓ LOGIC Component execution valid
✓ SCHEMA Contract checks passed
✓ REVISION Retained for comparison
Visual where it helps Compose and inspect the flow without hiding the engineering logic.
Code where it matters Keep SQL and Python available for specialised business and transformation logic.
Validation before production Catch invalid pipeline logic earlier instead of discovering it after deployment.
IOblend Designer showing a modular data pipeline DAG with sources, transforms and sinks
03 · Runtime execution

The Engine turns metadata into distributed processing.

IOblend Engine is the runtime heart of the product. It reads the playbook, constructs the required Spark processing and executes the pipeline on compatible Spark infrastructure—without requiring teams to hand-code the orchestration layer for every job.

Managed Spark abstractionKeep the scale and parallelism; remove much of the repetitive implementation burden.
Standard transformation languagesUse SQL and Python where bespoke rules are needed.
Infrastructure independenceExecute on customer-controlled cloud, on-premises or hybrid infrastructure.
Production behaviour built inData management features travel with the pipeline instead of being separate projects.

IOblend's execution layer uses Apache Spark™ ↗, the open-source engine for large-scale batch and streaming data processing.

04 · One operating model

Batch, streaming and CDC belong in the same conversation.

IOblend is designed around a Kappa-style model so teams do not need completely different development approaches for historical loads, live event streams and ongoing system synchronisation.

01 · Input
Source Database · API · file · events
02 · Movement
Ingest Batch · streaming · CDC
03 · Processing
Transform SQL · Python · joins · aggregates
04 · Control
Govern Quality · lineage · schema · state
05 · Outcome
Deliver Warehouse · applications · AI · source systems
One development model Historical and continuous flows can use the same product concepts and production controls.
Transform in flight Apply business logic while data is already moving instead of creating another processing tier later.
State stays governed CDC, history, schema, quality and lineage remain part of the operating model around the flow.
05 · DataOps in the dataflow

Production controls travel with the record.

The important production behaviour should not arrive as an afterthought. IOblend embeds lineage, CDC state, schema handling, deduplication, SCD/MDM patterns, metadata and exception management into the pipeline operating model itself.

Record-level context

Know what happened to the data—not just whether the job was green.

Trace and manage the lifecycle of records through ingestion, transformation and delivery.

RECORD
One record, with production context attached source → transformation → validation → destination
Lineage Where the record came from and how it moved.
Schema Which structure and contract applied at that point.
CDC state What changed and where the pipeline has progressed.
Quality Which validation rules passed or failed.
Deduplication How duplicate or repeated records were handled.
Audit context Operational evidence for investigation and replay.
Non-breaking quality

Keep bad records from becoming everybody else's problem.

Apply rules in flight, isolate exceptions, preserve context and continue processing records that are fit for use.

Incoming enterprise data Live events + historical records
Contract + quality checks Schema · business rules · completeness · validation
✓ Valid records Continue through the production flow.
! Exceptions Quarantine with lineage and error context.
Trusted destination Analytics · operations · AI · applications
Repair + replay Correct only what failed, then re-enter the governed flow.
Controls stay close to the flow Quality and governance are part of processing rather than a separate clean-up stage.
Good data keeps moving An exception does not have to force the entire pipeline to stop.
Failures remain explainable Lineage and error context make repair and replay easier to operate.
06 · Deploy where the data lives

Your environment stays the centre of gravity.

IOblend can be used locally for development and deployed into cloud or on-premises Spark infrastructure for production. The Engine runs inside the customer's environment and can work across hybrid and multi-cloud estates.

Local developmentLinux containerOn-prem SparkCloud SparkHybridMulti-cloud
IOblend cloud deployment architecture showing local Designer, IOblend Engine and Spark running inside customer cloud infrastructure
07 · AI in the pipeline

Put intelligence where enterprise context is already moving.

AI does not need to sit beside the integration architecture as another disconnected subsystem. IOblend can invoke Python-based AI logic inside the pipeline so unstructured content and model output can be validated and combined with normal enterprise data processing.

Agentic processing

Unstructured data becomes another governed pipeline input.

Bring documents, messages or other unstructured content into the same production flow as structured enterprise data.

01
Document or event PDF · email · text · message · operational input
02
Python AI agent Extract · classify · reason · enrich
03
Validate model output Schema · quality · business rules · exceptions
04
Join enterprise context Combine AI output with trusted structured data
Architecture effect

Less plumbing between AI and the data it needs.

Keep model-enabled processing inside the production dataflow, with quality, lineage and exception-management concepts surrounding it.

01
Freshness AI receives current enterprise context rather than stale exports.
02
Governance Validate outputs before they move into downstream operational use.
03
Interoperability Use Python-based AI frameworks alongside normal enterprise processing.
04
Operationalisation Make AI one governed stage of the production pipeline rather than a separate island.

IOblend documents integration with LangChain ↗ for Python-based agent workflows.

Structured + unstructured Use enterprise records, documents and model-generated outputs inside one governed flow.
Validation around AI Treat model output as data that still needs contracts, rules and exception handling.
Context stays close Bring AI to the dataflow instead of copying enterprise context into another disconnected subsystem.
Illustrative engineering example

Twelve similar source tables do not need twelve bespoke integration projects.

Metadata-driven execution is most valuable when the next pipeline can reuse the structure of the first one. This example shows the operating model rather than a customer benchmark.

Reusable domain pattern
12 → 1

One playbook family for a source domain.

Tables that share extraction, transformation, quality and destination patterns can be parameterised through reusable metadata and macros rather than maintained as twelve unrelated codebases.

Build-time control
Before deploy

Test components while you construct the flow.

IOblend can block invalid pipeline logic and SQL/Python errors during development, reducing the amount of separate test harness and deployment troubleshooting required later.

Execution model
Scale-out

The pipeline logic stays separate from cluster plumbing.

The same portable definition can move from development into distributed Spark execution without rewriting business logic around a different orchestration framework.

Illustrative architecture / delivery pattern. Exact implementation effort, throughput and latency depend on source systems, data volumes, infrastructure and business rules.

Technical FAQ

Answers before the architecture conversation.

The questions enterprise architects and data engineering teams usually ask first.

How does IOblend work?

Teams build and test a pipeline DAG in IOblend Designer. Configuration, run parameters and business logic are stored in JSON playbooks. IOblend Engine interprets those playbooks and creates the Apache Spark processing needed to execute the pipeline on customer-controlled infrastructure.

Do we need to write Spark code?

No Spark coding is required for standard pipeline development. IOblend abstracts much of the Spark orchestration while allowing SQL and Python for transformations, quality rules and specialised business logic.

Can one pipeline mix batch, streaming and CDC?

Yes. IOblend is built to work with historical and live data within the same operating model, including Change Data Capture and real-time synchronisation use cases.

How does testing and CI/CD work?

Components are executable and testable during development. Invalid logic or SQL/Python can be prevented from executing, successful development runs validate the completed pipeline, revisions are retained, and JSON playbooks can be managed in normal source-control workflows.

Where does the Engine run?

IOblend can run locally for development and can deploy into on-premises or cloud Spark infrastructure. It is designed for cloud, on-premises, edge, hybrid and multi-cloud estates.

Does IOblend lock the business logic into the product?

The architecture is deliberately designed around portable metadata plus SQL and Python. If infrastructure changes, the core business intent does not have to be rewritten around a proprietary transformation language.

See it on a real pipeline

Bring us the integration your current stack makes painful.

We will map the sources, business logic, quality controls and target architecture—and show how the same requirement is expressed and executed with IOblend.

Scroll to Top

Attention Data Developers

FREE DEVELOPER EDITION

Download your FREE copy and see how easy it is to start building production grade Spark data pipelines with IOblend