Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

ModuleNotFoundError: No module named 'cx_Oracle' -- to connect Oracle Database from python

pvemula
6 - Meteoroid

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 

 

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.

2 REPLIES 2
geraldo
13 - Pulsar

@pvemula 

 

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

 

geraldo_0-1682695179273.png

 

pvemula
6 - Meteoroid

Thanks, Geraldo. it worked.

Labels