ODBC Driver for Progress
The Multi-Tier ODBC Drivers for Progress consists of the generic ODBC client driver and the Progress Database agent on the server utilising the built in database independant network layer for communication between the client and server.
The OpenLink? Multi-Tier Drivers for Progress are a Type A class driver developed using the ESQL/C and SQL-92 call level interface.
These drivers are currently available for Progress versions 7.x, 8.x, 9.x and beyond.
[[/images/aodbcmtprog.gif|]]
/Progress Multi-Tier Architecture Diagram Image scaled down; Click to enlarge./
This driver is available for Windows, Linux, Unix(most flavours) Operating systems.
| Platform Support | Support for client, server, and application server operating systems |
| 32- and 64-bit components | Enables the development and utilization of 32- or 64-Bit DBMS independent applications. | Broad Operating System Support | Enables the development of ODBC compliant applications and the utilization of ODBC Drivers on non Windows platforms such as; Linux (x86, PPC, Itanium, Opteron), Mac OS X, Mac OS Classic, FreeBSD? , Solaris, AIX, HP-UX, HP True64 UNIX, IRIX, Altix, SCO UnixWare? , and others. |
| Database Engine Support | Backend database engine support |
| Broad backend Database Support | Enables DBMS independent application utilization and deployment across a vast array of industry leading DBMS engines that includes; Oracle (7.x - 10.x), SQL Server (6.x - 2005), DB2 (6.x - 8.x), Sybase (10.x - 12.x), Progress (7.x - 10.x), Ingres (6.4 - II family), Informix (5.x - 9.x & IDS 2000), MySQL? , and PostgreSQL? .
| Performance |
| Blistering Performance | Delivery of data access performance levels across ODBC, JDBC, ADO.NET and OLE DB that don't compromise viability of DBMS independent application development and deployment. | Network Aware Record Retrieval | Enabling the retrieval and insertion of multiple DBMS records in batches over the network with a minimal number of network hops. |
| Security |
| Rules Engine Based Security | Alignment and enforcement of data access policies across facets of enterprise IS infrastructure. This includes any combination of; users, user roles, applications, operating systems, databases, machine aliases, and networks. | Secure Data Transmission | Enables development and utlization of encrypted data transmission between DBMS independent applications and backend databases. |
| Administration | Configuration and Management |
| Zero Configuration for ODBC DSNs | Provides a Cross Platform implementation of the Rendezvous service discovery protocol.
This enables the configuration of ODBC Data Sources Names (DSNs) to be completely server based with no client side configuration whatsoever.
You simply pick a DSN configuration associated with your OpenLink? Request Broker from combo-box hosted list of OpenLink? Services.
| Usability |
| Array Column Type Support | Enables the use of data access standards compliant services, applications, tools, and development environments alongside a PROGRESS DBMS without modifying or reinventing DBMS Schema.
| Administration | Configuration and Management |
| Version Independence | Provides standards compliant data access tools, services, applications, and development environments across all PROGRESS DBMS versions (6.x and higher).
You don't need a Progress DBMS upgrade in order to take advantage of standards compliant data access technology.
| Usability |
| Network Ready | Enables usage of DBMS independent applications on any platform without installation of additional DBMS specific networking products. | Generic Drivers | Install one, as opposed to several, client components per data access standard and driver combination for your database independent applications. |
| Administration | Configuration and Management |
| Centralized Configuration & Management | A single point of focus when administering the data sources that serve the data access standards compliant applications.
| Standards Compliance |
| International character support | Enables the development and deployment of international applications that are independent of underlying database engine.
| Standards Compliance |
| ODBC 3.5 Compliance | Enables broad compatibility between an extensive collection of older and newer ODBC Applications across an array of platforms.
| Performance |
| Multithreaded | Enables exploitation of scalability benefits arising from the use of multiple CPUs or Clusters while developing or using DBMS independent applications.
| Usability |
| Distributed Database Support | Enables a standards compliant data access connection to be made to serveral Progress Databases concurrently | Hyphenated Column Name support | Enables the use of existing Progress DBMS schemas with standards compliant data access tools, services, applications, and development environments. |
| Standards Compliance |
| Supports Advanced Data Access API functionality | Enables the development and utilization of DBMS application with DBMS independent granularity that extends to challenging areas such as scalar function calls, dates and timestamps manipulation, outer join handling, and SQL stored procedure invocation etc. | Complete ODBC Scrollable Cursor Model Support | Provides ODBC compliant applications with a flexible model for handling sensitivity to data changes using the following scrollable cursor models: Forward-Only, Static, KeySet? , Dynamic, and Mixed. |