Dispec Loomer - Your low-code on-premise ETL tool for modern data integration

Dispec Loomer is a powerful low-code ETL tool that lets you combine data from up to nine different sources and load it into one of nine supported target systems. You can either keep source structures 1:1 or define a completely new target model.

Transformations are configured in a project file within Dispec Loomer Studio - without writing SQL. The runtime generates all required SQL automatically and executes the transformation in real time. A detailed log is available afterward for analysis.

On-premise means your data never leaves your infrastructure. Transformations run on your local machines.

Who Dispec Loomer is built for

• Data analysts who need to merge data from multiple sources
• Database developers who want simple and reliable migration workflows
• Business teams that need to provide data without SQL expertise
• Small companies building cost-effective reporting and data warehouse platforms

Core capabilities at a glance

• Select and combine multiple data sources
• Define the target environment
• Preview and visualize source data
• Select relevant tables for staging
• Apply filters and simple replacement rules
• Model target tables including:
  • Primary keys and relationships
  • Third normal form modeling
  • Star schema with fact and dimension tables
  • ER diagram generation
• Interactive adjustments via the target live-view editor

Flexible deployment strategy

Dispec Loomer supports separate deployment environments for source and target:

Dev - Test - Pre-Prod - Prod

This allows you to develop safely in development and execute transformations in the intended target environment.

Built-in automation

With Dispec Loomer Command, transformations can be executed automatically and on schedule - ideal for recurring production workflows.

Supported sources and targets

• MS SQL
• MySQL
• PostgreSQL
• Oracle
• CSV
• Excel
• Access
• Parquet
• SQLite

Typical use cases

• Transfer Excel data into PostgreSQL
• Migrate MySQL data 1:1 to MS SQL
• Transform Oracle data into a DWH schema on MS SQL (including SCD2 dimensions and fact tables)
• Convert CSV files into Parquet for cloud ingestion