Application Development Costs Reduction

Application Development Costs Reduction enables more experimentation and faster improvement

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.

Application Development Costs Reduction

Application Development Costs Reduction enables more experimentation and faster improvement

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.

Controlled Access to Data Assets

Controlled Access to Data Assets prevents unauthorised changes

Connection Pooling

Enables efficient management of resources associated with database sessions

Controlled Access to Data Assets

Controlled Access to Data Assets prevents unauthorised changes

Multiple Active Result Sets (MARS)

Enables applications developers to work concurrently against multiple query result sets

Controlled Access to Data Assets

Controlled Access to Data Assets prevents unauthorised changes

SSL Support

Secure data transmission between applications and DBMS server

Cost-Savings

Reducing costs of deployment

Instant Client Support

Direct access to Oracle DBMS Server without requiring additional networking middleware

Cost-Savings

Reducing costs of deployment

Single Sign On including Windows NTL Mv2

Single Sign-On (including Windows NTLMv2 authentication support). Reduces data costs for administrators, developers, and end-users

Ease of Integration

Ease of integration speeds deployment and enhances utility

Managed ADO.NET Data Provider

The use of the PostgreSQL wire-protocol facilitates direct connectivity from Database Agent  to Database Server. This alleviates the need to install any additional client side networking software as part of the driver installation and configuration process

Ease of Integration

Ease of integration speeds deployment and enhances utility

Wire Protocol Based Driver

The use of the TDS wire-protocol facilitates direct connectivity from Driver to Database Server. This alleviates the need to install any additional client side networking software as part of the driver installation and configuration process

Ease of Integration

Ease of integration speeds deployment and enhances utility

Zero Config based Auto-Discovery of instances

Zero Config based Auto-Discovery of SQL Server instances across local area networks Simplifies configuration and administration of database connections

IT Infrastructure Investment Preservation

Preserves previous investments in IT infrastructure, by embracing and extending rather than ripping and replacing.

Real Application Cluster (RAC) Support

Enables Driver use with Oracle Clustered Configurations

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Database mirroring compatibility

Provides developer with DBMS server topology flexibility

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Deferred Fetching of Blob Data

The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Distributed Database Support

Enables one standards-compliant data access connection to query over several Progress Databases at once. (Only applicable to SQL-89 modality of Progress 6.x-9.x.)

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Expose INGRES TID value in SQLSpecialColumns

Expose INGRES TID value in SQLSpecialColumns(ROWID) API calls.  Provides developers with access to DBMS-system-level identity values.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Hyphenated Column Name support

Enables the use of existing Progress DBMS schemas with standards-compliant data access tools, services, applications, and development environments.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Multithreading support

Enables development, deployment, and use of multithreaded client applications.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Reference Cursors Support in Stored Procedures

Support for advanced DBMS Server functionality.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Snapshot transaction isolation level

Enabling additional transaction isolation granularity to application developers.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Support for SQLCancel() API call support

Provides the ability to cancel long running queries.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Support for Serial Data Type

Provides application developers with access to last serial values for a given table.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Transaction Isolation Levels configuration

User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

Transaction Isolation mode discovery

Enables developers to determine if DBMS instance is transactional or non-transactional.

Sophisticated Application Functionality

Supports data access, integration and management, from the simplest to the most sophisticated functionality

XML and Native Large Value data types support

Provides developers with increased range of data types for developing new-generation applications.