Skip to Content
avatar image
Former Member

pyhdb on OS X fails to connect to SAP HANA2 Express running on VirtualBox

Jan 05, 2017 at 03:06 PM | 118 Views

Dear all,
on Mac OSX I have virtualBox with SAP HANA2 Express running very smoothly.
Eclipse on the MacOSX with the SAP HANA tools configured and running fine.
Tutorials worked well, including the PAL using an R server (that I deployed on the mac), and several TextAnalysis and TextMining tutorials (that is what I have most interest into).

In order to load HANA2 with XML content and try out the new XPATH capabilities, I wanted then to use python from Mac OSX to push data into HANA2. For this reason I've installed the pyhdb however I always get "fails to connect" error message. I am using port 39015, however if I do a nmap against the hana2 express 39015 is found as closed.

Has there perhaps any change on the port to be used ?
Or is there any limitation specific due to my configuration due to the lack of HANA Clients for OS X ?

Looking forward your advice

development tools for SAP Cloud Platform
python | osx | pyhdb
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 09, 2017 at 10:34 AM

    Port 39013 is the right one :-)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 02:13 PM

    I confirm, using python from Mac OS X (El Capitan) the pyhdb works perfectly well, against HANA2.0 running on virtual box .
    Using python version 2.7.12 and pyhdb (0.3.2) the following 3 lines works very well

    import pyhdb
    connection = pyhdb.connect('hxehost',39013,##user##,##pass##)
    print connection.isconnected()

    Thank you !!!

    Add comment
    10|10000 characters needed characters exceeded