How to connect Intel Edison to Oracle database server using python in Yocto linux

LLim5 · ‎08-07-2016

I need to access the Oracle database data by using Intel Edison board (Poky (Yocto Project Reference Distro) 1.7.3 piot005ai ttyMFD2), i686 GNU/Linux.

I try to install http://www.oracle.com/technetwork/topics/linuxpower-101193.html Instant Client for Linux on Power Big Endian (32-bit) Version 11.2.0.4 and cx_Oracle-5.1.3. But when I want to import cx_Oracle, I receive error as below:

>>> import cx_Oracle

Traceback (most recent call last):

File "", line 1, in

ImportError: No module named cx_Oracle

What is the error mean? or Is there any other way I can connect intel Edison to Oracle database?

Thank you!

idata · ‎08-09-2016

Hi,

What steps are you following to install the client? Have you already tried to use sqlite https://www.sqlite.org/about.html https://www.sqlite.org/about.html ? SQLite is a library that implements an SQL database engine. You can get sqlite from AlexT's repo http://alextgalileo.altervista.org/edison-package-repo-configuration-instructions.html http://alextgalileo.altervista.org/edison-package-repo-configuration-instructions.html . Follow the instructions to configure your Edison and install sqlite. Also notice that python-sqlite3 is also available, you can download this as well to use this Python module.

Let us know your results.

-Sergio

LLim5 · ‎08-11-2016

Thanks Sergio advice, but I no need to create database. I just need to retrieve data from Oracle database to trigger alarm sound. Because there is a existing project that keep all the data in Oracle database already. Is they any way I can access Oracle using Intel Edison?

idata · ‎08-12-2016

Take a look at this thread /thread/62092 https://communities.intel.com/thread/62092 . This thread has information about testing the connection to an existing database, as well as the code used and the packages the user had to use to test his configuration. Follow the suggestions in the thread and adapt them to your project.

Let us know your results.

-Sergio

LLim5 · ‎08-13-2016

I am using python in my scrip already, therefore I give up to try node.js. I create csv file from database, then remote access to the csv file using WinSCP.