Data Integration ⁽¹¹⁾

Data Mappings View

Data Mappings allow you to specify different rules for parsing files from 3rd party sources and any transformations to make before importing the data into the LemonEdge system. This provides a powerful mechanism for automating manual processes around importing data ensuring that even legacy vendors that only provide rigid text files in one format for data can still be worked with to integrate into this platform. We believe in ensuring you have the power to work with data (in our system or not) the way you want to be able to.

Open Architecture - Data Integration

Data Integration is our suite of technologies designed to alleviate the typical pain points with importing, exporting, and interfacing with other systems. Our powerful and versatile tools are about giving you the capability to interface with other systems without the need to lean on technical development help. You are able to create the import routines to automate pulling/receiving data from other systems transforming it into out system. Likewise you can automate pushing data to other systems or calling their API's all from one suite of tools.

Data Mappings

Data Mappings are a part of our importing and data integration technologies. Instead of just importing a csv file as is, data mappings allow you to specify the nature of the file and how to process importing it. You can explicitly state that certain imports will be of a particular text encoding, whether or not the file has headings, the delimiter to use and many more options including formulas to run on the data itself.

This provides an extremely powerful mechanism to tailor and automate you data integration processes (along with our other technologies such as Import Definitions). Most importantly you don't need help from a technical development team in order to get data into your system in the manner you require.