Database Module

The Redix Database Module provides direct database access through OLE-DB and the Microsoft Data Access Module (MDAC) 2.0 and above. The Redix Database Module, while working in conjunction with the Redix AnyToAny XML Format Converter Engine, provides a consistent data model to interface with existing database systems or file systems, such as spreadsheets or e-mail systems.

The following shows a list of the Redix Database Module's features:

• AnyToAny Conversion in ONE-Pass. This includes: 
  
  Flat File -> Database
  CSV -> Database
  EDI -> Database
  HIPAA -> Database
  NCPDP ->Database
  XML ->Database
  Database ->Flat File
  Database -> EDI
  Database -> HIPAA
  Database -> NCPDP
  Database -> CSV
  Database ->XML
   

• The Self-DB automatic map utility allows users to select a message name and automatically create a database map that will extract the data from the input message and directly write to the database.
  

• The Database Module provides a drag-and-drop operation to allow the user to easily implement a map.
   

• The Database Module will generate the appropriate SQL statements inside the OFD that allow the Redix engine to directly interface with the database systems.
  

• Combines data security, translation, mapping, and database access into ONE process to eliminate unnecessary file I/O (Input/Output). The unique Redix ONE-PASS approach is much faster than the traditional approach, making it ideal for real-time EDI applications.
  

• Supports Microsoft ActiveX/COM/OLE-DB technology. This product also comes with an ActiveX Control. With the Microsoft OLE-DB interface, the Redix AnyToAny Format Converter presents a consistent data model to interface with the user's existing database systems.
   

Database Map Example

Following is an example which extracts data from HIPAA 837 Professional to a SQL Server.  The left-hand panel in the picture below represents the 837 Professional tree structure, and the right-hand panel are tables in SQL Server. Two highlighted items are the mapping fields. 

The above map will generate SQL statements as below:

insert into TblRD8372000CPatient (TRN_ID,Patient_Id,PAT0109_Response_Code,PAT0108_Weight,PAT0107_Unit_Measurement,PAT0106_Date_Period,
PAT0105_Date_Format,PAT0101_Ind_Relation_Code,HL0104_Hierar_Child_Code,HL0103_Hierar_Level_Code,HL0102_Hierar_Parent_ID,
HL0101_Hierar_ID_Num) VALUES (,1,'','146','GR','19970314','D8','19','0','23','2','3')
 

Native Driver Supported

The Redix database module supports native driver for Oracle and SQL Server for performance reason.  For example, if users prefer to use the Oracle native driver for Oracle, the user can simply turn on the Oracle driver without using the default ODBC driver.

Database Supported

The Redix database module supports any ODBC-compliant systems, which include: