Skip to Content
0

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

Jan 05, 2017 at 03:06 PM

107

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Port 39013 is the right one :-)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Luca!

I was looking for this solution one weekend :)

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

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 !!!

Share
10 |10000 characters needed characters left characters exceeded