Skip to main content
September 26, 2023
Solved

Need to connect Appian Cloud Database from localhost

  • September 26, 2023
  • 3 replies
  • 0 views

Our Appian DB has setup for Enhanced Data Pipeline, follow the guide.
We have a Python app that run through airflow to query data with a service account, and trying connect to Appian Dev Cloud Database.

We're debugging right now on the connection and got this error
pymysql.err.OperationalError:(1045, "Access Denied for user 'appianViewer'@xx.xxx.xx.xxx' (using password: ***)")

Is there anyway to connect to the dev DB through local machine to debug on the python library issue?

Best answer by stefanhelzle0001

I am not sure how we can help you. There seems to be a successful connection and login, but the user does not have access to the selected resource.

3 replies

stefanhelzle0001
Brainy
September 26, 2023

I am not sure how we can help you. There seems to be a successful connection and login, but the user does not have access to the selected resource.

mathieud0001
Brainy
September 27, 2023

Did you put the service account in the group that has access to the connected system?

September 27, 2023

thanks for helping, it was due to TLS version issue that causing the issue.