Oracle Client for Microsoft Tools

Connect Microsoft Tools to Oracle Databases

Oracle Client for Microsoft Tools installs and configures Oracle Data Provider for .NET (ODP.NET) to support 32-bit and 64-bit Microsoft tool connections with Oracle on-premises and cloud databases, including Oracle Autonomous Database. It supports connecting with Power BI Desktop, Power BI service, Excel, SQL Server Analysis Services, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, and BizTalk Server.

Get the Details

Documentation

Using Oracle Client for Microsoft Tools
HTML   /   PDF

Tutorials

Power BI Desktop: Connect to Oracle Database* (PDF)

Power BI Desktop: Connect to Oracle Database using Microsoft Entra ID*

Power BI Service: Connect to Oracle Database* (PDF)

SQL Server Integration Services and Microsoft SQL Server Data Tools: Connect to Oracle Database (PDF)

SQL Server Analysis Services: Connect to Oracle Database (PDF)

SQL Server Reporting Services: Connect to Oracle Database (PDF)

*Oracle Client for Microsoft Tools 19.18, released April 21, 2023, adds support for Azure Active Directory authentication with Power BI Desktop and service. Version 19.18 no longer requires appending the install directory to the Windows SYSTEM path for Power BI service.