Scribd
Upload
7 views1 page

Power BI: Install ODAC Driver Guide

The document discusses connecting Python to an Oracle database and connecting an Oracle database to Power BI. It provides instructions on downloading and installing Oracle client software, setting system variables, and importing Oracle libraries in Python. It also includes a link to instructions on connecting Oracle to Power BI.

Uploaded by

Santiago
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views1 page

Power BI: Install ODAC Driver Guide

The document discusses connecting Python to an Oracle database and connecting an Oracle database to Power BI. It provides instructions on downloading and installing Oracle client software, setting system variables, and importing Oracle libraries in Python. It also includes a link to instructions on connecting Oracle to Power BI.

Uploaded by

Santiago
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1. Connection from Python to SIRA ([Link]

be/yFO-3dCegJA)

- Download and Install Oracle


Client->[Link]
[Link]
- Version 19 (More reliable). Saved in D according to installation TIGO path

- Set up 'System Variables'. Help: Service Desk to enable administrator permissions

- Device/Advanced System Configurations/environment Variables:

TNS_ADMIN: path of the client folder D\\:...\BIN


Path: Edit|New .. Copy Path - client folder D\\:...\BIN

Restart PC

Start Python. Import Oracle Libraries

# Now query the rows back


for row in [Link]('select description, done from todoitem'):
if (row[1]):
print(row[0], "is done")
else:
print(row[0], "is NOT done")

-----------------------------------------------------------------------------------
-------------

[Link] Oracle SIRA to Power BI

Instructions:
[Link]

Installation ODAC. Microsoft´s Guide-> [Link]


LinkID=272376

You might also like