ODBC TUTORIAL

How to Build Power BI reports on Oracle Data using the DataDirect Oracle Driver for ODBC

Updated: 10 Nov 2022

Introduction

Progress DataDirect’s Oracle ODBC Driver offers a high-performing, secure and reliable connectivity solution, for ODBC applications to access Oracle data. If you want to use our ODBC Oracle Driver with the Power BI Desktop application, Progress DataDirect has you covered. In this article, you will learn how you can use Progress DataDirect Oracle ODBC drivers to import the data from Oracle Database.

Install and Configure Progress DataDirect Oracle ODBC driver

  1. Download the Progress DataDirect Oracle ODBC driver from here.
  2. Install the Oracle driver by running Setup.exe. This is a simple installation if you go through with default installation settings.
  3. After the DataDirect Oracle ODBC driver has been installed, open ODBC Administrator to configure the connection and click on Add.
    odbc data source administration window; user data sources list dbase files selected
  4. Choose the “DataDirect X.X Oracle Wire Protocol” and click on “Finish.”
    create new data source window; datadirect 8.0 oracle wire protocol selected from list of drivers
  5. The ODBC Oracle Wire Protocol Driver Setup window will pop up.
    odbc oracle wire protocol driver setup window; general tab; description input empty; host set to hostname; port number set to 1521; SID set to ASC

    6. Enter your credentials, click on “Apply” and then click on “Test Connect.” 

  6. The Oracle Logon screen will pop up. Provide logon credentials and click on “OK.”
    logon to oracle wire protocol window; host set to hostname; port number set to 1521; sid set to ASC; user name set to username; password input filled
  7. A dialog box will confirm that the connection is established. 
    test connect dialog saying connection established

Connect to an ODBC Data Source using DataDirect Oracle ODBC driver

  1. In Power BI, click on Get Data -> More -> All and search for ODBC. Choose it and click “Connect”.
    2. get data window; odbc selected
  2. A popup menu will appear. From the following dropdown menu select the DSN name. Make sure you select the same driver that you installed. In this case it is Oracle. Click “Ok”.
    3. from odbc window; oracle option focused from the data source name (DSN) dropdown

    Note: To make it easy remember the Data Source name given during driver setup.

    odbc oracle wire protocol driver setup window; general tab; data source name input is set to oracle
  3. Authenticate using your credentials and click on Connect.
    4. login dialog with empty username and password fields
  4. A navigator will open displaying the data in the data source. Choose your database, select table, and click on Load to continue.
    5. navigator window showing the example CTX_CLASSES table
  5. You should now see the data
    6. PowerBI; visualizations open; fields category; the activity_bounceback table fields are available

Conclusion

We hope this article helped you with how you can import data into Microsoft Power BI from Oracle database using Progress DataDirect Oracle ODBC drivers. Get started today with a free 15-day trial of Progress DataDirect Oracle ODBC drivers, and connect Tableau to all your data! Contact Us for assistance with any questions you may have, and we will be happy to help!

Contents

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support