Product
Use Cases
Mapper Studio covers real integration scenarios: from file and API transfers to partner and customer connections as well as recurring, automated data flows across multiple protocols.
1. Platform Overview
Mapper Studio is built for integration scenarios in which structured data must not only be converted, but also received in a controlled way, transformed, tested, logged and delivered again.
The platform is aimed at organisations and integration partners that want to build and operate data flows without classic custom development. Visual mapping, combinable transport channels, structured testing and persistent configurations form the practical foundation.
2. Partners Manage Multiple Customers
A partner manages multiple tenants, maintains their mappings centrally and operates different data routes within one shared platform.
- Tenant-capable structure
- Roles for customer, partner and administrator
- Separate configurations, runs and logs
3. File to File Without Development
Incoming CSV, Excel, XML or JSON files are automatically parsed, mapped and output in the required target format.
- Custom delimiter for CSV
- Sheet, header and start-row selection for Excel
- Direct target generation in CSV, Excel, XML or JSON
4. Webhook to SFTP / AS2 / OFTP
Data enters the system via HTTP/S webhooks, is transformed and then automatically delivered to file-based or certificate-based target systems.
- Multipart uploads
- Direct data or attachment return channel
- Combinable outbound routes
5. SFTP Polling with Mapping and Delivery
Regular pickup of files from directories, parsing and structured forwarding to target systems – without manual intermediate steps.
- Password-based or key-based authentication
- File patterns and directory logic
- Cron-based processing
6. Excel and CSV Onboarding
Particularly suitable for business teams and partners that need to convert structured incoming data from spreadsheets or exports into standardised target structures.
- Fast setup without code
- Visual field mapping
- Reusable mapping structures
7. API, File and EDI-Related Transfers in One Platform
Mapper Studio is suited for hybrid integration landscapes in which modern HTTP/S interfaces coexist with classic file-based and certificate-based protocols. This makes it possible to run API-related, file-based and B2B-oriented transfers within one consistent model.
- Webhook, SFTP, AS2 and OFTP in any combination
- Inbound and outbound can be configured multiple times per mapper
- Unified processing across parser, mapping and delivery layers
8. Testing Before Go-Live
Mappings can be tested directly before productive activation. Previews, structured results and separate test windows support clean sign-off.
- Inline test execution
- File preview for CSV, XML and JSON
- Detailed test results and logs
9. Debugging and Operational Stability
Every run is logged in a technically traceable way. This reduces coordination loops and simplifies operations in case of errors or exceptional cases.
- Inbound source
- Mapping result
- Output format, errors and delivery status
10. Technical End-to-End Data Flow
The platform consists of a web frontend, backend API, mapping engine, ingestion connectors, delivery connectors, scheduler, parsers, generators and central data storage for mappings, schemas, runs, configurations and logs.
- Ingestion layer: webhook, SFTP, AS2 or OFTP
- Parser layer: CSV, Excel, XML, JSON into internal structure
- Mapping engine: rules, functions, extensions, constants
- Target generator: output in CSV, Excel, XML or JSON
- Delivery layer: transfer to configured target channels
- Logging layer: complete logging of all steps
- Scheduler layer: scheduled processing and polling
11. Mapping Use Case: Extend Structure Instead of Building Workarounds
The mapping engine supports automatic schema creation, editable structures, custom fields and attributes as well as function chaining. This allows even more complex transfers to be modelled cleanly without rigid dependency on developers.
- Visual drag-and-drop mapping
- Multiple functions in sequence
- Individual removal of functions without losing the mapping
- Reduced XPath dependencies
- Constant values and structure extensions
12. Security Model
Mapper Studio is designed for controlled data processing in professional environments.
- TLS across all transport paths
- Certificate management for AS2 and OFTP
- API key authentication for webhooks
- Tenant isolation and validation
13. Scheduling in Practice
Recurring inputs can be picked up, processed and forwarded automatically. This also makes the platform suitable for periodic integration runs without manual triggering.
- Predefined intervals
- Freely definable intervals
- Persistent storage of all configurations
14. AS2 and OFTP-Related Scenarios
AS2 is fully integrated for inbound and outbound, including signature-based and certificate-based processing. OFTP is fully present in the user interface and supports configuration of certificates, signing, encryption, compression, target directories and scheduling.
Current status: Excel-related encryption in AS2 is still limited. Functional backend validation for OFTP is still being finalised due to the lack of publicly accessible test infrastructure.
15. Summary
Mapper Studio is suitable for companies and partners that want to build, test, operate and scale structured data flows without cumbersome custom development. The platform combines visual mapping, multi-protocol capability, operational proximity and traceable technical processing in one consistent solution.