How to connect to Oracle Database from Python tool

[pvemula]

Hi ,

I need to connect to Oracle database through Pyton tool to pull the data from database. However I am getting the below error through Alreryx. I have installed Oracle cline and even the cx_Oacle in Alteryx Python . 

Need help fixing it 

The command used to Python tool

import cx_Oracle   

ModuleNotFoundError Traceback (most recent call last) <ipython-input-2-ff1521013889> in <module> ----> 1 import cx_Oracle ModuleNotFoundError: No module named 'cx_Oracle'

C:\Windows\System32>pip install cx_ORACLE
Requirement already satisfied: cx_ORACLE in c:\users\pavan\appdata\local\alteryx\bin\miniconda3\lib\site-packages (8.3.0)

Thanks in advance.

[geraldo · Accepted solution]

@pvemula 

The correct thing is to do the installation according to the print inside the python tool. You have to be machine administrator