Pydev Anaconda

Although PyDev is available through Eclipse Marketplace, I had some problems making it work from there. After a few hit and trials, I found a way to integrate the plugin in Eclipse without going through the marketplace. With this blog, I would like to share the steps for how to install Python PyDev plugin in Eclipse. PyDev is a plugin that enables Eclipse to be used as a Python IDE (supporting also Jython and IronPython). It uses advanced type inference techniques which allow it to provide things such as code completion and code analysis, besides providing a debugger, interactive console, refactoring, tokens browser, django integration, etc.

Anaconda

Hi gurus!

As a SAP technical architect by trade and Python developer at heart, I have been wanting to try out the capabilities of pyHANA for a while now. pyHANA is an open source-maintained fork of the PyHDB project, a 100% Python client for HANA, based on the SAP HANA SQL Command Network Protocol.

Disk drill recovery software review

Pydev anaconda ipython

In this post, I will detail, step by step, how to connect pyHANA to a HANA database and fetch a few records from the TABLES table. Let’s go!

First, let’s setup SAP HANA Studio so that we can write Python code with it. I am aware that SAP HANA Studio is not the best IDE for writing Python, and I personally prefer vi and PyCharm, but I thought it would make sense to work from the official HANA IDE for this. Why not?

(In this post, I am using SAP HANA Studio 2.3.41.)

In HANA Studio, let’s install pyDev. Go to Help > Install New Software.

Then Work with: http://www.pydev.org/updates. Select all and install all the PyDev packages.

When it’s all installed, open the PyDev perspective.

Then create a new PyDev project.

Time to install pyHANA!

After making sure that git is set in your PATH, use the following command to pip install it (in my case I am using Anaconda):

Then in HANA Studio, create a .py Python file within your project and run the following code. The function pyhdb.connect creates a new database session and returns an instance of the Connection class. As a port, you must select 3<instance number>15; if your instance number is 00, your port should be 30015.

Then, with the cursor method of your connection object, you can create an instance of Cursor that is able to query the database using SQL.

And then you get:

That’s all folks! We connected pyHANA to our HANA database and run a simple SQL query on it. Watch this space for more content about leveraging the power of Python and the HANA platform!

IDLE is a very small and simple cross-platform IDE that is included free withPython and is released under the open-source Python Software Foundation License.

Anaconda

Anaconda and Miniconda include IDLE.

To use IDLE:

Pydev Anaconda Virtualenv

Pydev anaconda release

Pydev Anaconda School District

  1. Find the IDLE program file:

    EXAMPLES for Miniconda with Python 3 and user name “jsmith”:

    • On macOS, the full path may be /Users/jsmith/miniconda3/bin/idle3.5
    • On Windows, the full path may be C:UsersjsmithMiniconda3Scriptsidle
  2. Run IDLE from file explorer or from the command line by entering the full path.

Pydev Anaconda

Tip

Pydev Anaconda Release

You can make a shortcut to the IDLE program fileon your desktop.