RoboDX™ – Much More than a Traditional ETL

ROBODX™ – MUCH MORE THAN A TRADITIONAL ETL

RoboDX is one of the best programs that I have used to automate/import/export data from ARTrail [A/R software]. KG Hawes has done a great job in the functionality to help with automated letters, reports, doc attachment, and payment processing.  We have cut our finance department posting time for direct payments to minutes instead of hours. There’s not too much you can’t automate with RoboDX.

Gilbert L. Fisher
Chief Operating Officer
GB Collects

There are a wide array of data-centric challenges facing businesses today. “EDI” has earned a special berth in the sea of loathed three-letter-acronyms. The movement of information from one system to another may seem trivial on the surface but quickly becomes a complicated and expensive exercise often requiring custom development. If you’ve ever spent several thousands of dollars on an import program just for a simple Excel file, you will want to read further. Imagine having a tool that essentially acts as a rosetta stone between your system and those of your customers and partners.

RoboDX™ enables you to quickly adapt to new or changing data requirements when sending and receiving data. Its convenient job configuration, with drag-and-drop mapping, coupled with powerful validation and translation capabilities, will allow you to remain cool when someone mentions “EDI”.

RoboDX™ is much more than a traditional ETL (Extract, Transform, Load) solution. Though RoboDX’s most basic feature enables you to import that simple Excel file and map its fields to the target of your choosing, it can do a lot more than knocking the corners off the square peg. Your data target may be another file format your existing system already understands, any of a myriad of supported SQL and NoSQL databases, or even a web-service API. Where you source your data from is equally as flexible.

Watch Video

Merging & Splitting of Datasets

RoboDX™ can facilitate the merging and splitting of datasets for circumstances where the one-file-fits-all format your client just sent you…doesn’t fit. Alternatively, perhaps you need their three files converted into a single dataset. When coupled with RoboDX’s integrated Reconciliation Engine you now have a powerful tool to align and compare your data with theirs. 

That’s right! RoboDX™ includes a powerful feature where you can perform simple or complex comparisons of datasets with tailorable tests and output formats, all built on top of the same flexible input/output engine. RoboDX™ is a powerful solution that can extend the life of your legacy system, allow you to leverage new information services and technologies, and help you achieve your automation objectives. 

A Selection of RoboDX™ Use Cases

Simple Excel File Import

Our client’s customer often changed the layout of data submissions, and our client needed a reliable mechanism to catch this as well as validate the contents of each field so it didn’t damage their import process.

Multi Epic Files from a Large Healthcare Provider

Data needed to be compared with the collection agency’s inventory; then, payment, cancellation, and new business files needed to be produced from that result. In this case, the target of these outputs were web-service APIs for their payment, new business, and workflow modules.

Commercial Data Vendor

This client uses RoboDX™ as their “black box” to process batched and single-information requests via files or RoboDX’s API listener. RoboDX™ then processes those inquiries through a battery of web-service vendors, each with its own API format. The “hits” are then processed back to this vendor’s customers.

Letter Vendor XML

After converting to a new platform, our client didn’t want to disrupt the existing letter process. RoboDX™ replicated a custom export from their legacy platform which included complex packaging logic and AES256 encryption of specific data elements.

Scrubbing of Data

The scrubbing of data facilitated via RoboDX’s reconciliation feature pushes a dataset to an information vendor, then updates that dataset with the results before progressing the file into the customer’s ARM system.

Secure File Transfer

A municipal client sought an affordable alternative to more expensive solutions like Dropbox and Sharefile. RoboDX’s secure file transfer module provided exactly what they were looking for.

Missing Account ID’s

The payment file received from our client’s customer didn’t possess the correct identifiers to associate that payment with our client’s data. RoboDX’s reconciliation engine enabled the implementation of custom logic to find and add the missing identifier to the payment file which enabled automated posting.

ANSI 835

An ANSI 835 payment file was required by a healthcare system’s client to receive our client’s remittance information.

Data Lake

RoboDX provides for Data Lake gathering and consolidation of disparate data sources to create and manage a data lake for Business Intelligence tools.

Features & Benefits

  • Seamless Integration
  • On-Premise or Cloud Installation
  • Four-Step Configuration
  • Create any Destination Format
  • Program Conditional Decisions
  • Build Cross-Reference Tables
  • Reconciliation Engine
  • String Functions
  • Metadata Management Support
  • Data Quality & Cleansing Functionality
  • Versatile Cryptography
  • Built-In Secure Email
  • Team-Based Development Capabilities
  • Built-In Data Profiling Software
  • Map & Normalize Data Fields
  • Reports
  • Security & Auditing Controls
  • Bandwidth Friendly
  • Job Scheduler, and…
  • More!

Special Offer

For a limited time, RoboDX™ is offering three (3) months free of usage charges and licensing fees with a one (1) year contract.

Schedule a Free Trial of RoboDX

Extract the information you receive, & transform it into the data you need.

Media Inquiries

If you have a press request or inquiry, please fill out our Media Inquiry form.

Looking for a Trusted Partner?