Tools for data integration and development.

ONECEPT combines proven Microsoft, open-source and custom-built components to integrate, store, model and make data usable across different sources.

Discuss tools

01 Tools

Data integration and development

Technologies for ingestion, transformation, modelling and business intelligence.

Data Solutions & Cloud

Azure Data Factory

Create, extend and adapt ETL and data integration jobs in Azure, including big-data workloads.

Apache Spark

Scalable framework for data processing, data science and machine learning on single machines or clusters.

Apache Airflow

Programmatically create, schedule and monitor workflows with a Python-based, scalable platform.

Azure Synapse

Integrated analytics platform for ETL/ELT, data warehousing, analytics and ML modules.

Talend

Low-code platform for data integration, data quality and data governance in one solution.

Pentaho

Business intelligence software for ETL, reporting, OLAP/analysis and data mining.

Power BI

Connectors, data modelling, visualization and publishing within the Microsoft ecosystem.

Microsoft Fabric

End-to-end SaaS for data integration, storage and analytics with OneLake as an open data store.

Data Warehousing & Business Intelligence

Microsoft Integration Services

SSIS automates data movement and transformations between different source and target systems.

Fast solution for data acquisition from diverse databases into the Microsoft SQL Server world.

LinkedServer & STAGE

Initial and incremental loads for landing zones as the foundation for data warehouses.

Power BI Semantic Models

Logic layers, analyses and dashboards on consolidated data sets.

02 Tools

Data storage

Databases and platform architectures for structured, unstructured and analytical data assets.

Data Solutions & Cloud

Microsoft SQL Server

Relational database management system for storage, administration, reporting and security.

Azure SQL Databases

Cloud-based SQL Server services with automated backups, high availability and performance optimization.

PostgreSQL

Object-relational database system with high reliability, extensibility and SQL standards support.

Big data and data platform databases

Data Lake

Central repository for structured and unstructured raw data that can be processed when needed.

Delta Lake

Open-source layer for data lakes with ACID transactions, versioning and incremental processing.

Lakehouse

Combines data lake and data warehouse concepts for unified processing, governance and analysis.