ODBC Driver Oracle
How DataDirect's Oracle ODBC Driver Surpasses the ODBC Driver Oracle Provides
For ODBC connectivity to an Oracle database, using the ODBC driver Oracle itself makes it a seemingly convenient option. But the ODBC driver Oracle provides with its DB distributions is not the best performing solution, and all things considered it's not the simplest solution either. Progress DataDirect, the data connectivity specialists, offers an ODBC driver for Oracle that outperforms the ODBC driver Oracle distributes and is easier to administer – while still fully leveraging Oracle-specific DB functionality.
Better Performance than the ODBC Driver Oracle Distributes
When it comes to performance in an ODBC driver, Oracle's own driver can't keep pace with the Progress DataDirect Connect ODBC Oracle driver. That's because the DataDirect ODBC driver for Oracle eliminates the need for Oracle SQL *Net client libraries by instead employing a unique wire protocol that directly uses TCP/IP to communicate with the database. Throughput and response time both benefit from this more direct line of communication.
DataDirect's ODBC Oracle driver also improves your overall Oracle performance with an unrivalled degree of in-driver functionality including connection pooling, statement pooling, and load balancing. And unlike the ODBC driver Oracle provides, which requires the Oracle SQL Loader in order to perform bulk loading operations, DataDirect ODBC drivers support Oracle bulk load without requiring use of external loading tools.
Simpler Administration than the ODBC Driver Oracle Distributes
Using the DataDirect ODBC Oracle driver in your data access architecture is simpler than using the ODBC driver Oracle packages with its DB, particularly if your organization is using multiple Oracle DB versions. With its own ODBC driver, Oracle requires that you separately install the Oracle SQL *Net client libraries on each machine that hosts a driver. With DataDirect drivers, there's no need to install or maintain these client libraries.
Further, with the ODBC driver Oracle provides, you need a different driver version for each version of the Oracle DB that you're running. With DataDirect's ODBC Oracle driver, by contrast, a single driver can simultaneously work with Oracle DB versions 8i, 9i, 10g, and 11g.
And while gaining the better performance and easier administration that the DataDirect ODBC Oracle driver provides, you don't sacrifice anything in Oracle DB-specific functionality: DataDirect drivers support key Oracle DB features including server-side result set caching, transparent data and tablespace encryption, and Oracle RAC (Real Application Clusters).