Oracle Odbc 2021 Guide

For an Oracle Database, the acts as the translator. It allows an application that speaks "ODBC" (like Microsoft Excel, Tableau, or a custom C++ application) to communicate efficiently with an Oracle Database.

Oracle provides two main ODBC drivers:

Once installed, you typically configure a DSN through the ODBC Data Source Administrator: oracle odbc

import pyodbc

Create an ODBC data source to connect to your Oracle database. For an Oracle Database, the acts as the translator