Innovative User Experience
- No-code user-friendly interface
- Link one or multiple data elements from source to target
- Wizard-driven transformations & document generation
- Organize transformations across pages
- Test transformations for consistency and accuracy
Versatile Data Source Integration Support
What you can create source and target documents from using our Document Generation Wizard include:
Data Transformations
The available types of transformations encompass:
-
Operations for string fields
append/prepend, split, concatenate, and many more
-
Math operations
add, subtract, multiply, divide, round, square root, etc.
-
Date operations
format, add or subtract time and current date/time
-
Duration
add or subtract time from a date field
-
Convert
conversion functions between field types
-
Advanced
database lookups, table looping, if-then logic, C# scripting, callouts to external .NET assemblies
-
Custom
Develop and import your own mapping transformations that can be shared across mapping projects
Complex Data Transformations
-
Decision-based Mapping
Use decisions to drive the execution of transformation logic
Chain a series of decisions to address complex scenarios Visualize the path(s) taken while testing
-
Support for simple and complex logic conditions
Leverage IF/Then/Else logic to generate target information
-
Create Structure with Table Looping
Our Innovative no-code wizard guides you through mapping flat data files into a more organized format with repeating fields
-
Simplify Data Aggregation with Database lookups
The database lookup function empowers you to pull additional data directly into your map.
-
When Nothing Else Can Get the Job Done
Add custom C# code to your transformations with our comprehensive code editor equipped with IntelliSense
Auto Mapping
Thoroughly examine both source and target documents to identify matching fields, giving you the flexibility to select which auto-mapped fields to keep or eliminate.
Data Mapper Video Library
Introduction to FlightPath
This video introduces FlightPath, your user-friendly data mapper tool. It simplifies data mapping with tools for importing and storing JSON, XML, and CSV/TXT data structures. Plus, it offers a metadata generation wizard to kick-start mapping from cloud and on-premise databases and line-of-business apps. FlightPath also provides testing tools for document and field-level testing, as well as auto mapping for similar data fields such as strings, numbers, and dates. Enjoy functions to manipulate data with ease, including data concatenation, splitting, custom scripting, database lookups, and table looping.
Mapping with JSON schemas
Utilization of JSON schemas for data mapping in Flightpath. It begins by guiding you through the creation of a foundational map. Next, it showcases diverse methods for selecting, importing, and storing a JSON schema, concluding with instructions on how to save your mappings.
Mapping with JSON documents
Explore how to employ JSON schemas for data mapping in Flightpath. We'll commence by creating a basic map and proceed to showcase multiple techniques for selecting, importing, and storing a JSON schema. Finally, we'll cover the process of saving your mappings.
Mapping with XML
Discover the efficient use of XML files for data mapping within Flightpath. Start by creating a basic map, explore different methods to select, import, and store XML files, and learn how to save your mappings
Mapping with XSD
Learn how to use XSD schemas for data mapping within Flightpath, starting with the creation of a basic map. Discover the various methods for selecting, importing, and storing XSD schemas, and understand how to save the mappings.
Mapping with CSV/TXT Files
Delve into the process of importing CSV/TXT files for data mapping within Flightpath. We begin by creating a basic map and then illustrate the various methods for selecting, importing, and storing a CSV/TXT file, along with guidance on how to save the mappings.
Mapping with WSDL
Use WSDL files for data mapping within Flightpath, beginning with the creation of a basic map. Discover various methods for selecting, importing, and storing WSDL files, along with guidance on how to save the mappings.
Mapping with Database
This video showcases the process of using databases for data mapping within Flightpath. It starts by creating a foundational map and then proceeds to illustrate different methods for selecting, importing, and storing a database schema. Finally, it provides clear instructions on how to save your mappings.
Mapping using Line of business application
Establish a connection to your line of business application and dive into data mapping within Flightpath. Begin by creating a fundamental map, explore diverse techniques for selecting, importing, and storing the schemas specific to your line of business application, and conclude with a step-by-step guide on saving your mappings.
Mapping using OpenAPI
Connect to an OpenAPI for data mapping in Flightpath. Begin with a basic map, explore methods to select, import, and store associated schemas, and conclude with instructions on saving your mappings.
Advanced Function - Concatenation
Uncover the art of crafting data mapping and optimizing data manipulation with advanced concatenation techniques in this informative video.
Advanced Function - If Conditions
Explore the creation of a data map and the effective application of the advanced IF Condition function.
Advanced Function - Custom Scripting
In this video, you'll discover the process of creating a data map and how to use the advanced Custom Script function.
Advanced Function - Table Looping
Discover how to create a data map and effectively leverage the advanced Table Looping function for advanced data manipulation.
Advanced Function - Split Function
Master the process of creating a data map and effectively utilize the advanced Split function.
Advanced Function - Database Lookup
Discover the process of creating data mappings and unlocking the full potential of the advanced Database Lookup function.
Testing Function - Within FlightPath
Learn how to utilize FlightPath's testing functions for conducting tests at both the document and field levels.
Advanced Function - Decision Function
Use decisions to drive the execution of transformation logic Chain a series of decisions to address complex scenarios Visualize the path(s) taken while testing
Read more about Peregrine Connect
-
Rabbit MQ Topics
Introduction Due to the open-source nature of RabbitMQ and constant updates, it is...
-
Port Sharing
One of Neuron ESB’s scalability features is the ability to install multiple...
-
The Integration Journey to...
The Integration Journey to Digital Transformation with Peregrine Connect
-
Saving Time and Money by...
Neuron ESB Application Integration and Web Service Platform: A Real-World Example...
-
Neo PLM
-
Loomis Case Study
Loomis Chooses Peregrine Connect as Their No/Low-Code Integration Platform:...
-
Decision Test Data Mapping
- Use decisions to drive the execution of...
-
Map Testing
Learn how to utilize FlightPath's testing functions...