Add custom Salesforce connection type

[eladkal]

Description

Airflow has SalesforceHook but it doesn't have a defined connection.

In order to create a Connection one must expose it's secret token as text :

https://stackoverflow.com/questions/53510980/salesforce-connection-using-apache-airflow-ui

Also it's not very intuitive that the Conn Type should remain blank.

It would be easier and also user friendly if there will be salesforce connection in the UI which has a security_token field that is encrypted.

moved from https://issues.apache.org/jira/browse/AIRFLOW-6429

[feluelle]

Also it's not very intuitive that the Conn Type should remain blank.

That's true. At least there should be a howto docs guide on how to set up the connection properly.

[kaxil]

That can be a good first-issue to add docs :) what to create that issue @feluelle ?

Also it's not very intuitive that the Conn Type should remain blank.

That's true. At least there should be a howto docs guide on how to set up the connection properly.

[feluelle]

Sure! I am creating one.

[gtossou]

I would like to work on this issue

[eladkal]

@gtossou are you still working on this?

[gtossou]

@gtossou are you still working on this?
@eladkal i'm still working on it. just figuring out the testing part before publishing a PR

[potiuk]

@gtossou -> Just FYI, We just merged the first of the series of "auto-discovery" of Provider's capabilities, And we have defined a way how Providers can expose such connections to the Airflow Core (just in time for 2.0).

The most important (connection type discovery) is here 2037303

But few more are coming (see in progress items here: https://github.com/apache/airflow/projects/5)

I will soon also add a description on the "Discovering provider capabilities" (Connection Types, Connection Forms, Extra Links for now). Just wanted to you to be aware that this are is still going through some latest refinements before 2.0 release.

[eladkal]

@gtossou are you still working on this issue?

[cmarteepants]

@kaxil If nobody is working on this, would love to take this on!

[kaxil]

Assigned this to you @cmarteepants :) thanks

(Looks like @gtossou might be busy since they have responded yet)

[eladkal]

@cmarteepants are you still working on this?
If you need some references you can check:
#14724
#15159

[cmarteepants]

I am! Sorry. Will hurry up. Client Engagement has been bleeding me dry 😃 From: eladkal ***@***.***> Sent: Tuesday, April 13, 2021 5:08 AM To: apache/airflow ***@***.***> Cc: Constance Martineau ***@***.***>; Mention ***@***.***> Subject: Re: [apache/airflow] Add custom Salesforce connection type (#8766) @cmarteepants<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fcmarteepants&data=04%7C01%7CConstance.Martineau%40chrobinson.com%7Ce1f9c37efeda4027a7ce08d8fe5b96a9%7Cd441ad83623546d6ab1a89744a91b1d8%7C1%7C0%7C637539016626925069%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=FokrMzS%2FYnswgIWU83b8d2SDrY5oCdtHMQ3CLCZyP90%3D&reserved=0> are you still working on this? If you need some references you can check: #14724<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fairflow%2Fpull%2F14724&data=04%7C01%7CConstance.Martineau%40chrobinson.com%7Ce1f9c37efeda4027a7ce08d8fe5b96a9%7Cd441ad83623546d6ab1a89744a91b1d8%7C1%7C0%7C637539016626925069%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=iMArCdqwxjosiF0Y8peZPBdN85bTF9NaSVwj5ze6ihQ%3D&reserved=0> #15159<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fairflow%2Fpull%2F15159&data=04%7C01%7CConstance.Martineau%40chrobinson.com%7Ce1f9c37efeda4027a7ce08d8fe5b96a9%7Cd441ad83623546d6ab1a89744a91b1d8%7C1%7C0%7C637539016626935064%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=bzbK1%2Fn1FBBd%2FLPN9dRHJntjs30p5pwXZL%2FampaqVCI%3D&reserved=0> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fairflow%2Fissues%2F8766%23issuecomment-818578772&data=04%7C01%7CConstance.Martineau%40chrobinson.com%7Ce1f9c37efeda4027a7ce08d8fe5b96a9%7Cd441ad83623546d6ab1a89744a91b1d8%7C1%7C0%7C637539016626935064%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=22eccl0sKgS7h4N9MYabkSo4B9SB7V%2F6G5avkMPubGI%3D&reserved=0>, or unsubscribe<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAIEWSHTTLT45CUSFY7APUBTTIQCVNANCNFSM4M3JG27Q&data=04%7C01%7CConstance.Martineau%40chrobinson.com%7Ce1f9c37efeda4027a7ce08d8fe5b96a9%7Cd441ad83623546d6ab1a89744a91b1d8%7C1%7C0%7C637539016626945060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=lIk0HbJDktSirzh87e%2FPSEOtFwZWhBcYRrZxsZJRUEc%3D&reserved=0>. ************************************************************************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the sender of the e-mail. The sender of the e-mail accepts no liability for any damage caused by any virus transmitted by this email. (IP) *************************************************************************************************************************

[eladkal]

hi @cmarteepants rechecking you are still working on this issue?

[cmarteepants]

Hi @eladkal , thanks for checking. Please feel free to reassign. I should have let you know sooner, sorry if this causes any problems

[josh-fell]

@eladkal I'm happy to take this on if still available.

[potiuk]

assigned