Skip to main content
New Participant
Sep 26, 2023 12:40 PM UTC
Solved

Need to connect Appian Cloud Database from localhost

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?

stefanhelzle0001
Brainy
Sep 26, 2023 3:06 PM UTC

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
Sep 26, 2023 3:06 PM UTC

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
Genius
Sep 27, 2023 12:17 AM UTC

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

New Participant
Sep 27, 2023 6:42 AM UTC

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