Video Key Moments
3-Pane Data Mapper for Easy Data Transformations
In this short video, see how PilotFish’s 3-pane Data Mapper lets you build complex data transformations with simple point, click and drag & drop actions. No coding or scripting required.
Watch how Source structures (left), Target structures (right) and mapping logic (center) come together in a single view so even highly complex mappings stay organized, visual and easy to maintain.
[Try the Free 90-day Trial] [Talk to an Expert]
30-second summary
- Drag & drop mappings between any source and target format in a single 3-pane view
- Use XSLT structures and functions graphically instead of hand-writing code
- Handle iterations, conditionals, lookups and validations as you map
- Reuse mappings across interfaces, vendors and standards to accelerate delivery
Build Mappings Visually in the 3-pane Layout
The Data Mapper’s 3-pane layout keeps everything you need in view:
- Source tree (left): Browse and select elements from the inbound format.
- Target tree (right): Define the structure of the outbound message or transaction.
- Mapping pane (center): Drag from Source and Target into the center to create mapping rules, relationships and transformations.
Because all three are visible at once, you can design and understand even complex mappings quickly, without hunting through multiple windows or writing custom scripts.
XSLT Power, No Scripting Required
Behind the scenes, the Data Mapper generates clean, standards-based XSLT for you. A rich palette of XSLT structures and functions lets you do almost anything you would do programmatically using drag & drop instead of hand-coding. For example:
- Date and time formatting
- Complex iteration over repeating structures
- Conditional logic and branching
- Value lookups against code tables or reference data
- Field validation and assignment
You get all the power of XSLT with a visual, guided experience that lowers the learning curve and speeds up delivery.
Switch Instantly Between Graphical and XSLT Views
Need to see or fine-tune the underlying XSLT?
- Click the XSLT tab at the bottom of the panel to switch from the graphical view to the code view.
- Make changes visually or in XSLT, then swap back and forth as needed.
This gives both developers and analysts a comfortable way to collaborate – business-friendly visuals with full access to the underlying transformation logic when needed.
Accelerate Any-to-Any Data Transformation
Use the Data Mapper in eiConsole to transform virtually any data format to any other, including XML, JSON, flat files, databases, HL7, X12 EDI, FHIR and custom formats.
- Import vendor-specific samples to jump-start new mappings.
- Leverage built-in format readers to parse common standards.
- Reuse mapping fragments across interfaces so you never start from a blank screen.
The result: you become significantly more productive, reduce errors and deliver integrations faster with a consistent, repeatable process.
Part of the eiConsole Integration Engine
The Data Mapper is just one component of the eiConsole Integration Engine IDE. Use it alongside:
- The assembly line–style, 7-stage route configuration
- 40+ Listeners, 35+ Transports and 140+ Processors for connectivity, validation and routing
- Inline interface testing and debugging in the same environment where you configure your routes
Together, these tools let you design, map, test and deploy integrations end to end, all from a single, graphical console.
Take a Test Drive
Review the PilotFish Product Specifications or download a Free 90-Day Trial of the eiConsole – full-featured, codeless and scriptless. Then see how quickly you can build your own mappings with the 3-pane Data Mapper.
FAQ
Yes, PilotFish allows users to configure validation rules. This includes rules for data translation, data conversion or data formatting within its data mapping framework.
After the initial setup within the PilotFish Integration Engine, mapping data between similar systems typically requires only minimal customization. Subsequent integrations often necessitate slight modifications tailored to the specific requirements of each system involved.
PilotFish supports both approaches. Users can map data via a graphical drag & drop interface or use custom XSLT scripting. XSLT is the native transformation language of PilotFish’s data mapper.
PilotFish’s data mapper component, powered by XSLT, provides intuitive graphical mapping ideal for non-technical users, along with direct code editing capabilities for advanced transformations, accommodating all user proficiency levels.
PilotFish does not offer pre-configured mappings for specific transactions like HL7 or EDI as standard. However, the system includes base formats and a comprehensive suite of tools that facilitate efficient customization of mappings.
Check out our FAQ pages for more.
If you’re curious about the software features, free trial, or even a demo – we’re ready to answer any and all questions. Please call us at 813 864 8662 or click the button.
X12, chartered by the American National Standards Institute for more than 35 years, develops and maintains EDI standards and XML schemas.