Home

Extract the information you receive

& Transform it into the data you need

UNIVERSAL DATA EXCHANGE

Play Video
What is ETL?
Data Normalization
ETL & ARM
Data for ARM

Seamless. Powerful. Secure.

There are a wide array of data-centric challenges facing businesses today. RoboDX™ is a B2B data exchange solution which enables businesses to securely manage the transport of critical data in any required format. Its interoperable data exchange engine can be configured with various platforms, and integrated with an enterprise application to enable a seamless data exchange.

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”.

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.

Download Our Brochure

Much more than an ETL

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.

  • 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
  • Meta Data 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
  • Much more...

Leverage the power of BIG Data

It's the most essential resource your business has.

Use Cases

ANSI 835

ANSI 835 payment file is required by a health system client to receive our customer’s remittance information.

Missing Account IDs

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.

Data Lake Gathering

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

Multiple Epic Files

The data needed to be compared with the collection agency’s inventory, then payment, cancellation, and new business files need 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.

Simple Excel File Import

Our client’s customer often changed the layout 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.

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.

Data Scrubbing

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.

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.

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.

We'd like to hear from you

Get In Touch!

Operations / Development

400 International Way, Ste 380
Springfield, OR 97477

Executive / Corporate

222 NE Park Plaza Drive, Ste 125
Vancouver, WA 98684

Call Us

(888) 861-6739

Email Us

contact@kghawes.com

Privacy Policy
© 2022 RoboDX™ — All Rights Reserved
Linkedin Youtube
Close

WHat is ETL?

ETL is a term for the data integration process consisting of three steps; extract, transform, and load.

Extract: Extracting is the act of pulling data out of its original source. Once extracted the data, in its various formats, is held in a staging area.

Transform: The transformation of data happens in the staging area prior to the data being moved to its intended location. Transforming is the process of converting the data into a format that can be analyzed and merged. Many processes can take place in this phase, from cleaning to sorting. This step prepares the data for future use.

Load: Loading is the operation of storing the extracted and converted data in its new location (otherwise known as a data warehouse).

‘When’ Basics

ETL is typically used when constructing a data warehouse but can be an essential operation for importing new data in general. The ETL process is used when you need to migrate and merge large quantities of data from one system to another.

‘Why’ Basics

ETL is important for establishing and maintaining clean usable data. ETL can improve the data integration process, removing the likelihood of human error and redundancy which can slow processing efforts. It also can improve data accuracy, making it easier to create historical views and deep analysis. For any modern business, it is essential to be able to capture data for continuous analysis. A good ETL tool simplifies this process making it easier to develop data-driven strategies that can keep you competitive.

Close

Data for ARM

Pairing the Right Tools With the Right Partners —

Normalization is a necessity for usable data. Standardizing data and eliminating duplicates helps to create a well-maintained store of information for access and analysis. There are many tools on the market that boast normalization capabilities, so many in fact, that it can be difficult to know which one is right for your organization. In today’s post, we are going to identify the critical functions of a normalization tool for ARM and why when you chose a technology solution you should also be expecting a reliable technology partner.

The core of any agency’s operations is consumer data. The ability to quickly import consumer data from a client’s system and integrate it for use in your own system can be challenging. Few businesses are likely to employ the same formatting, making the ease of file conversion a must-have function. When choosing a data solution, you want a comprehensive Extract Transform Load (ETL) functionality. The ability to convert from any format to your desired format (and back again) is not too much to ask for. Ideally, transferring accounts should be as quick and painless as possible for your clients; that means the dirty work of data normalization falls on you.

In this same vein, you need to be able to access and load the data from a variety of sources. A quality data solution should be able to access data directly from a database as easily as it could a file or API— and securely. Nothing is more important when handling sensitive consumer information than data security. Make certain the solution you chose utilizes auditing and security controls that support the high-level security needs of the business subject to government regulation. Your vending partner should be familiar with the unique needs of the industry and have a proven track record for supporting compliance. Additional security features, such as unique encryption algorithms are a plus.

When combining data from various sources, the solution should have the ability to perform specific actions to ensure the data is clean and integrates with the organizational elements of your own system. Basic operations such as programming conditional decisions, formatting and comparing dates, handling decimal places, and performing mathematical functions should be commonplace. The solution should also allow for a wide variety of string functions, from concatenating to splitting using delimiters or fixed-width analysis. The idea is that the single solution you chose will be comprehensive enough to allow for performing multiple jobs, eliminating the need to dedicate FTE hours to the task.

Once you have found a quality tool, you need to be certain it comes with quality vendor support. We already touched on the importance of industry expertise; understanding the function of the solution for your unique operational circumstances is critical for a productive vendor relationship but also for a real partnership. You need to know your vendor can be relied on for ongoing support. As your organization grows and operational needs evolve, not just the solution but the vendor must be able to adapt as well. That’s why it’s important to look for more than the right tool for today, but the right partners for tomorrow.

Close

ETL & ARM

The Critical Role of Data Solutions —

There is little more that is valuable to a business than its data. In accounts receivable, proper data management is essential to nearly all internal processes and plays a large role in staying competitive. Without good data, there would be no trend analysis, no method for data-driven process improvements, and the work of tracking consumer activity would be catapulted back into the collection of dark ages.

Like anything else of value, your business data must be taken care of. This means giving it regular attention, performing routine maintenance, and cleaning. Many businesses dedicate a good percentage of their FTE hours to tasks like these, unaware that a quality ETL tool can do the job for them more efficiently and with fewer errors. In an uncertain economy with staffing shortages from furloughs or illness, potential FTE savings are critically important.

ETL tools allow you to compile, process, and migrate large amounts of data from various sources and assemble it inside your own system for access and analysis. These tools also put a variety of processing tasks, such as merging, reformatting, or sorting, into a simple user-friendly dashboard. The ease of use and automated processing of ETL tools are what make them such time savers. A single user can tackle numerous jobs at once and review past executions, effectively managing data input and output within a single solution.

Without an ETL tool, organizing and accessing your data for analysis becomes an insurmountable task. An ETL tool serves as the gateway to any data processing strategy, providing a workable foundation for applying deep analysis to data stores down the road. These high-level analyses allow for process improvement and insights which can give your agency a competitive edge. In a nutshell, an ETL tool is the first step in creating routine procedures for making data-driven decisions — and fast.

For the ARM industry, ETL tools have a critical role to play in maintaining continuity and staying competitive.

If your agency is not already employing a data solution that offers these benefits or is not reaping these benefits from your current solution, contact us today for an obligation-free consultation. One of our solution experts, familiar with the unique needs of the ARM industry, is ready to help.