User`s guide

Choosing Between ODBC and JDBC Drivers
2-11
Depending on your environment and what you want to accomplish, you need to decide
whether using an ODBC driver or a JDBC driver suits your needs the best. Use the
following to help you decide.
Use native ODBC for:
• Fastest performance for data imports and exports
• Memory-intensive data imports and exports
Use JDBC for:
• Platform independence allowing you to work with any operating system (including
Mac and Linux
®
), driver version, or bitness (32-bit or 64-bit)
• Using Database Toolbox functions not supported by native ODBC (such as
runstoredprocedure and metadata functions tables or columnnames)
• Working with complex or long data types (e.g., LONG, BLOB, text, etc.)
Tip: On Windows systems that support both ODBC and JDBC drivers, pure JDBC
drivers and the native ODBC interface provide better connectivity and performance than
the JDBC/ODBC bridge. First, use the native ODBC or JDBC drivers to connect to your
database. Use the JDBC/ODBC bridge only after trying to connect through native ODBC
or JDBC drivers.