title: How to connect to SAP Hana Express with PyHDB
body: <p>I have the following Python Code [pyhdb] to connect to SAP Hana Express:
  Is there an error in my code? or has it something to do with the SYSTEM user?</p>
  
  <p>Error Message is: 
  Could not find table/view TABLE in schema APP: line 1 col 19 (at pos 18)</p>
  
  <pre><code>import os
  import random
  import platform
  from constant import *
  import pyhdb
  
  def is_rpi():
      return 'arm' in platform.uname()[4]
  
  if is_rpi():
      import Adafruit_DHT
  
  def read_dht():
      if is_rpi():
      sensor = Adafruit_DHT.DHT22
      humidity, temperature = Adafruit_DHT.read_retry(sensor, DHT_PIN)
  
      if humidity is not None and temperature is not None:
          print('Temp={0:0.1f}*C  Humidity={1:0.1f}%'.format(temperature, humidity))
          return int(humidity), int(temperature)
      else:
          return None, None
  else:
      return random.randint(20, 30), random.randint(40, 70)
  
  if __name__ == '__main__':
  
  connection = pyhdb.connect(host=SAP_HOST, port=39015, user=SAP_USER, password=SAP_PWD)
  cursor = connection.cursor()
  
  temp, humi = read_dht()
  query = "INSERT INTO \"{}\".\"{}\" VALUES(\'{}\', {}, {}, \'{}\')".format(
      SAP_SCHEMA, SAP_TABLE, DEVICE_ID, temp, humi, ROOM_NAME)
  print("Executing query: "), query
  cursor.execute(query)
  
  print("New Row count: "), cursor.rowcount
  connection.close()
  </code></pre>
  
  <p>And here is the constant code:</p>
  
  <pre><code>DHT_PIN = 4
  DEVICE_ID = '0ada9de4-bc4f-4e53-990a-cbcfccaed4c4'
  ROOM_NAME = 'room 101
  SAP_HOST = 'hxehost'
  SAP_USER = 'SYSTEM'
  SAP_PWD = 'XXXXXXXXXXXX'
  SAP_SCHEMA = 'APP'
  SAP_TABLE = 'TABLE'
  </code></pre>