Data Integration
Data integration is the foundation of every successful data-driven strategy. Today, organizations operate across a wide range of systems, data formats, and platforms — from classic on-premises databases and cloud services to complex XML structures. An effective integration approach ensures that information is delivered reliably, consistently, and with the required performance to the right places.
As integration technology specialists, we support you in modernizing data flows, connecting systems, and building sustainable architectures — on-premises, in the cloud, and in hybrid scenarios.
We support you across all phases of your integration projects:
- Concept and architecture for modern integration solutions
- Implementation of ETL/ELT processes in MapForce, SSIS, or MS Fabric
- Development of scalable data pipelines for on-premises, cloud, or hybrid
- Modeling and optimization of XML data structures
- Creation of XSLT and XSL-FO transformation pipelines
- Migration of existing ETL landscapes to the cloud
- Integration of complex data sources such as XML, JSON, Excel, and web APIs
- Training and coaching for MapForce, SSIS, Fabric pipelines, XML/XSLT
MS Fabric Data Integration
Microsoft Fabric provides a fully integrated, cloud-based platform for data integration, data engineering, and real-time analytics.
Benefits in Fabric
- Well suited for modern, scalable cloud data platforms
- Pipelines based on Data Factory
- Native support for Delta Lake and lakehouse architectures
- Automated data loading into OneLake
- Notebook-based integration with PySpark
- Real-time processing via event streams
Altova MapForce
Altova MapForce is a powerful graphical ETL tool that can transform and integrate structured data from almost any source. MapForce maps any combination of XML, databases, flat files, EDI, Excel 2007+, XBRL, and/or web service data, converts data instantly, or generates code to execute recurring conversions.
Altova MapForce Server enables automation of integration tasks and supports high-throughput execution.
Use Cases
- Mapping between XML, JSON, CSV, Excel, and relational databases
- Automation of recurring data flows
- Generation of XSLT, XQuery, and Java/.NET code
- Fast implementation of complex XML transformations
- Integration into existing ETL pipelines
XML Development
Especially in highly regulated or structured data domains (banking, industry, logistics), XML technologies continue to play an important role.
Our XML Capabilities
- Validation and transformation pipelines for business processes
- Professional modeling of XML schemas (XSD)
- Development of XSLT transformations (1.0 / 2.0 / 3.0)
- Document generation using XSL-FO
- Serialization and integration of XML data into SQL or Oracle databases
MS SQL Server Integration Services
For clients operating on-premises data warehouse solutions — existing or new — we provide SSIS as a robust, scalable, and cost-effective ETL platform.
Strengths of SSIS
- Well suited for classic DWH architectures and ETL jobs
- High performance for large data volumes
- Tight integration with SQL Server
- Wide range of transformation components
- Support for custom tasks in C# or VB.NET
References
Since 2000, Comeli has been working with XML and related technologies. Our integration projects include components such as XML, text files, and databases.
“
XML data integration using Altova MapForce / MapForce Server between different applications for planning and building power plants.
Power plant engineering
“
Integration using Altova MapForce / MapForce Server of various EDIFACT standards in the European logistics industry, including processing of CSV and MS Excel as well as XML modeling.
Logistics
“
Development and implementation of configurable data integration solutions in e-commerce using MS SQL Server Integration Services and T-SQL for MS Navision on MS SQL Server — for partner billing and for the data warehouse.
E-commerce
“
Automated generation of 500+ PDF documents and reports from a data warehouse with customer and service data, plus XML interfaces using Oracle DB, PL/SQL, XSLT, and XML Schema; Altova StyleVision for presentation; and Talend for data integration in the insurance sector.
Insurance
Frequently Asked Questions on Data Integration
This FAQ addresses the topics most frequently discussed in consulting engagements and training sessions. Each answer is concise and refers to additional material where appropriate. If your question is not listed, please feel free to contact us.
When does modernization make sense?
Modernization is particularly relevant when existing ETL processes are hard to maintain, cloud strategies are being implemented, or new data sources need to be integrated.
What role do ETL and ELT processes play?
ETL (Extract, Transform, Load) and ELT structure the data flow from source systems into the target architecture. They define extraction, transformation, validation, and delivery of data.
Is MS Fabric suitable for every data integration strategy?
Microsoft Fabric is particularly suited for cloud-centric architectures. In purely on-premises environments, classic platforms such as SSIS may be more appropriate.
How important are XML technologies today?
In regulated industries and standardized exchange formats (e.g., EDIFACT or industry-specific XML standards), XML technologies remain a key component of structured integration architectures.