Database Module

The Redix Database Module is an optional software add-on to the Redix AnyToAny and Network Server-Based AnyToAny Format Converter Engines. It allows the Redix software engine to interact with any ODBC-compliant databases during the conversion process. Users can use the Redix Database Module to convert messages of any type to/from a database (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, and MySQL). The Redix Database Module also supports the native API of the target DBMS (database management system), e.g., Oracle/oci and SQL Server/OLE-DB, so applications developed with the Redix Database Module can run more swiftly.

Users can access ODBC-compliant databases with Redix software by entering OFD (Output File Descriptor) statements. Users can use standard SQL statements, views, and stored procedures to interact with a database.

Users With the GUI Mapper or HIPAA Package

For enterprises that use the Redix GUI Mapper or HIPAA Package, the Redix Database Module allows users to:

Perform drag-and-drop operations to easily create a map between a message and a database
Create the database schema, as well as a map between a message definition and the created database. The Redix GUI Mapper and HIPAA Package allow users to create a “self-mapping” database map that automatically generates a database schema and map from a message definition.

After the map is defined, the Redix GUI Mapper or HIPAA Package with Database Module will generate a Redix OFD file with the appropriate SQL statements that will allow the Redix engine to interface with the database directly.

With Additional RMAP Module

For enterprises that already use the Redix RMAP Module, the Redix Database Module includes predefined database maps for all twelve RMAP transaction types. The predefined database maps are for use with Microsoft SQL Server and Oracle databases.