EMK3 Cloud

Data Exchange

EMK3 Cloud Data Exchange

The Data Exchange application is a modern bi-directional service for transferring data between applications, data formats, and internal or external stakeholders. It includes powerful data transformation tools, and combined with Data Storage, delivers a single solution for cross-company data distribution and consumption.

Highlights

  • A non-technical solution designed for end-users means no IT, no custom programming, and no complicated APIs
  • Easy setup and configuration of data sources which includes the following file formats: PDF, Excel, CSV, XML or HTML Web Page
  • Sophisticated data transformation using custom Data Mappings to transform the data into a format that can be easily consumed by other systems
  • Configurable routing rules so data files can be routed to one or many recipients
  • Versioning and re-call features for data tracking
  • Create Mapping Sets for more complex data transformations that require merging the results into one result set
Data Exchange

Key Features

  • Easy Setup and Configuration of Data Sources

    Data files are sent to the Data Exchange as attachments to an email or manually uploaded. No custom programming or APIs are needed. Minimal setup requirements mean you can immediately begin use. The following file formats are supported: PDF, Excel, CSV, XML or HTML Web Page.

  • Sophisticated Data Transformation

    Data is extracted from files using custom “Data Mappings” to transform the data into a format that can be easily consumed by other systems. The Data Mappings include sophisticated rules for data transformation. Data Exchange supports outputting the data as a file in Excel or CSV or can send the data directly into a SQL Server database.

  • Configurable Routing Rules

    Data files can be routed to one or many recipients based on custom routing rules. Data Files can also be routed back to one’s self for internal use. The system automatically generates notifications of receipt to both the sender and receiver.

  • Versioning and Re-call

    Data files are versioned for easy historical tracking and review. They can also be recalled if accidentally sent or incorrect. In addition, the built-in controls allows you to know if the file was received or generate an alert if the file failed delivery.

  • Mapping Sets

    For complex data transformations, a “Mapping Set” can be created to automatically merge the results of multiple mappings into one result set.

  • Auto Conversion and Delivery

    When the data file is received, one or more “Data Mappings” can be automatically applied and the results automatically emailed to one or more users. This allows for synchronous integration with other systems.

Data Exchange

How It Works

1. Receipt
A file is sent to the EMK3 Cloud as an attachment on an email or manually uploaded. The Data Exchange service will auto-detect the document and route it to the correct transformation process. Supported file formats include PDF, Excel, CSV, XML or HTML Web Page.
2. Conversion
If the document is a PDF, Data Exchange will send it to DocParser to convert it from PDF to Excel. This happens seamlessly behind the scenes, so no user interaction is required (aside from initial setup).
3. Parsing
As part of the conversion from PDF to Excel, DocParser provides functionality for parsing just the relevant information that is desired from the PDF. Transformation: The raw source data requires additional cleanup and processing. Data Exchange performs multiple functions like 1) converting data types, 2) cleaning up parsing errors, 3) performing data validation, and 4) transforming the data into desired format.
4. Storage
Data Exchange can send the cleaned and transformed data into Data Storage where it will be saved for later use.
5. Delivery
The final step is to send the cleaned and transformed data to the appropriate person or application. Data Exchange supports outputting the data as a file in Excel or CSV or can send the data directly into a SQL Server database.