creds = json.loads(os.getenv('VCAP_SERVICES', '{}'))['hana'][0]['credentials']
connection = dbapi.connect(
    port=int(creds['port']),
    address=creds['host'],
    user=creds['user'],
    password=creds['password'],
    sslTrustStore=creds['certificate'],
    sslCryptoProvider='openssl',
    currentSchema=creds['schema'],
    encrypt=True
)