3

I was trying to follow along the tutorial for Salesforce integration to Redshift on https://www.astronomer.io/guides/salesforce-to-redshift/. I have successfully setup Amazon S3 connection on Apache-Airflow like the answer here. But there is no Conn Type of Salesforce. enter image description here

Does anyone know what the steps are to create a Salesforce connection on the Apache-Airflow UI?

Don't know if it helps but my Airflow is installed on an Ubuntu Amazon EC2 environment.

HighAbove
  • 329
  • 4
  • 9

1 Answers1

4

I figured it out. The trick is to leave the Conn Type empty. I started by filling out the Host, Login and Password. Then on Extra, I added a dictionary that had my login's security token. It will look like the screenshot below. enter image description here

HighAbove
  • 329
  • 4
  • 9
  • hey @HighAbove , how did you manage to leave the ' Conn Type' empty? when I try to do it, the field already contains a default value. also, according to Airflow documentation, we should use the 'HTTP' connection. https://airflow.apache.org/docs/apache-airflow-providers-salesforce/1.0.0/connections/salesforce.html thanks – Itay Av Jun 27 '22 at 10:36
  • This response need more information about connection string. – Gurudev Kumar May 03 '23 at 15:52