MilramX Logo

How MilramX Works

MilramX extracting ifnformation

MilramX has interface adaptors that are able to translate between the complexities of reading or writing a database with multiple levels of indirection, or exchanging data with the web-services interface of a Cloud-based system, and Higher Level Data Objects (HLDOs). This translation is driven by implementer defined rules, stored as XML metadata, but imported in the form of Excel spreadsheets.

HLDOs are in a system independent format and consist of a keyword that uniquely identifies the HLDO, within the source or target system, and a set of attribute-value pairs.

MilramX uses its interface adaptors to exchange data between two or more systems in the form of these HLDOs. In the middle of this process, data translation is performed between the HLDOs using Data Translation Objects (DTOs) which are in essence subroutines that are executed under the control of MilramX.

For simple data mapping, rules can be imported in the form of Excel spreadsheets and stored in the form of XML metadata. These rules are then used by a standard DTO to do simple one-to-one mapping of source to target data attributes.

For more complex mappings, implementers can code their own DTOs in .Net using an extension to the Microsoft Visual Studio IDE. These DTOs can integrate AI algorithms and rules to do complex data interpretation, which can then be used, through the alerting mechanism, to send messages to different lists of people, depending on the issue that needs resolving.

This mechanism solves one of the major problems in implementing automated data exchange mechanisms between systems, namely that it is very difficult to find a systems implementer who knows the technical inner details of both (or more) systems involved in the transfer. MilramX breaks the problem down into three parts:

  1. Having a data analyst who knows the technical details of the source system and can develop the rules to convert between the database or web-services interface of the source system and a set of HLDOs.
  2. Having a different data analyst who knows the technical details target system and can develop the rules to convert between a set of HLDOs and the database or web-services interface of the target system.
  3. Having a business analyst who can develop the rules and/or code to translate data between HLDOs from the source to the target systems.

In this way, we only need experts in different parts of the interface problem and not someone who knows the details of all the systems involved.

MilramX comes with a standard set of interface adaptors for a variety of databases, as well as for systems such as QuickBooks and BellHawk.  It is an open architecture system enabling users to develop their own adaptors, if needed, and also to define their own HLDOs and to develop their own DTOs.

Please click here to learn about the MilramX Systems Architecture