SQL Up Leveling/ Full ANSI SQL Support
SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.
Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant
We keep our SSL version upto date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy
Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)
Support for Advanced Azure features
Our SQL Server ODBC driver supports authentication via Azure Active Directory (AD). Azure AD authentication is an alternative to SQL Server Authentication for Azure SQL Database that allows you to centrally manage identities of database users
Support for Always On Feature for Availability Groups
Introduced in SQL Server 2012, Always On Availability Groups is a replica-database environment that provides a high-level of data availability, protection, and recovery.
TSANet Multi-Vendor Support Channel
We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.
Day 1 Support for any new versions
Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.
High-performing Type 5 JDBC Driver
Type 5 JDBC drivers offer the same client-side, single-tier, 100% Java architecture of Type 4 JDBC drivers, but address the limitations of many of the Type 4 JDBC drivers. Unlike a type 4 JDBC driver, our type 5 JDBC driver maximizes data throughput while using minimal amount of CPU and memory resources. You can learn more over here
Codeless Bulk Load / Export
Progress DataDirect JDBC drivers support bulk load through JDBC batch inserts or the DDBulkLoad object. This means existing applications, such as Apache Sqoop, can get bulk insert performance without any code changes or external tools such as bcp for SQL Server or SQL*Loader for Oracle. Refer to this blog for more details.