Database Connectors enable seamless translation of COBOL file I/O statements to SQL instructions operating against a modern relational database management system. Database Connectors support Microsoft SQL Server, Oracle, IBM DB2, and other RDBMS platforms.
Database Connectors use data dictionaries, also called eXtended File Descriptors (XFDs), which are based on standard COBOL file descriptors (FDs). These data dictionaries map COBOL data items directly to database fields. XFDs are used at runtime to map records and fields onto database tables and columns. XFDs can be customized using Micro Focus COBOL compiler directives to give complete control over field naming and data type.
Database Connectors use low-level RDBMS APIs to achieve the best application performance. Where application data storage has moved from local data files to a networked RDBMS, applications may expect to see a small reduction in I-O performance. Such overheads can be addressed by updating performance critical sections of code to reduce access times.
Use standard tables and columns for COBOL data storage and enable easier data access using familiar tools such as Excel or Crystal Reports. Take advantage of real-time BI and data analytics.
Database Connectors improve application resiliency and recovery by leveraging the inherent benefits of RDBMS. Deliver higher levels of reliability, availability, and scalability to your COBOL applications. Increase business continuity and accelerate data recovery during system failure.