Whats the Difference Between DataDirect Technologies Implementation of this Technology and Other Alternatives?
You have two choices when deciding how to implement data access: • Custom code to the database’s native interface, such as Oracle’s OCI (Oracle Call Interface) • Use third-party ODBC drivers such as DataDirect Technologies wire protocol ODBC drivers Custom coding data access to the native proprietary interface of each database results in non-portable code. This approach requires you to re-program your application every time you change databases or even database versions; making it difficult to maintain the application and reducing cost-effectiveness. When compared to the use of wire protocol ODBC drivers, custom coding offers no performance advantage. See Ken North’s report, which benchmarks the performance of SQL queries using wire protocol ODBC and Oracle’s OCI. DataDirect Technologies ODBC drivers provide the following advantages over other ODBC drivers: • DataDirect Technologies offers a Wire Protocol ODBC driver for every major database – Oracle, DB2, Microsoft SQL Server, Sybase
Related Questions
- What is the difference between the Kalina Cycle® power cycle technology and other power cycle technologies? What is the relevance of those differences?
- Whats the Difference Between DataDirects Implementation of ADO.NET Data Provider Technology vs. Competing Alternatives?
- Whats the Difference Between DataDirects Implementation of JDBC and Other Alternatives?