Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We've recently installed a new piece of software that uses an Oracle Database to store the data. My goal is to connect to that database and pull the data from the back end to do analysis on. I'm having the world's most difficult time connecting to it.

I need to access it two ways:

  1. ODBC - I would like to setup an ODBC connection in Windows 7, so that I can pull the information using Excel. I know how to setup the connection, but I cannot for the life of me manage to setup the Oracle Drivers correctly. All the links from documentation for this piece of software go to dead/changed pages. Apparently the Oracle website has changed since this documentation was written.

  2. Python - From what I can tell, cx_Oracle seems to be the best module, but again I can't seem to set it up correctly. And again, most documentation refers to sections of the Oracle website that has since changed. I'm not sold on using cx_Oracle if someone has a better recommendation.

Thanks for looking over this, and I appreciate your help.

share|improve this question
What is your actual problem? Do you get errors when trying to set up the drivers? – dezso Aug 30 '13 at 18:43
The best way to connect to Oracle from within Oracle is cx_Oracle. However, you might want to consider using Jython instead which you could call easily from within Oracle... – Ben Sep 18 '13 at 21:05

Are you installing the 32 bit drivers or the 64 bit drivers on Windows 7?

I have to install the 32 bit drivers on all of our Windows 7 machines (even those running 64 bit).

After that I have to set up ODBC using: c:\windows\syswow64\odbcad32.exe instead of through the control panel.

Your issue may very well be different.

share|improve this answer

You can pull cx_Oracle from

I can verify that these packages have worked for me in the past:

share|improve this answer

If you are using cx_Oracle, you will need to have the oracle client installed and your database connections setup already such that you can use them with sqlplus via command line.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.