Data Integration
Data integration is a crucial part of our services to ensure that your data is exchanged efficiently and consistently between different systems. To achieve this, we build rule-based interfaces for your partners in the area of data import and data export.
We use MS Azure Data Factory, MS SQL Server Integration Services or Altova MapForce (Server).
MS Azure Data Factory
Microsoft Azure Data Factory (ADF) is a cloud-based data integration service that enables organizations to connect, transform, and manage data from multiple sources.
Overall, Azure Data Factory is designed to simplify the automation and management of data flows and pipelines in a modern, cloud-based architecture.
Altova MapForce
We will introduce data mapping with Altova Mapforce. This is an application for mapping, converting and integrating data. MapForce maps any combination of XML, database, flat file, EDI, Excel 2007+, XBRL and/or web service data, converts the data immediately or generates software to perform repeated conversions.
Altova MapForce Server allows you to automate data integration tasks and thus benefit from high speed.
MS Integration Services (SSIS)
We create solutions for data integration with MS SQL Server Integration Services (SSIS) and scripting techniques such as T-SQL or .NET or advise you on how to use Integration Services together with other SQL Server products such as Analysis Services for ETL processes in the area of data warehousing or data mining.
References
Data Integration is always a part of BI / DWH projects.
“
Data Integration using SSIS for MS SQL Server DWH projects
Various companies in DACH
“
Data Integration solution based on EDIFact and Altova Mapforce
Logistics Company, Paris
“
Data Integration using PL/SQL for Oracle development projects
Insurance companies and banks