You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "zoomingrocket (via GitHub)" <gi...@apache.org> on 2024/12/04 14:39:22 UTC
[I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
zoomingrocket opened a new issue, #4657:
URL: https://github.com/apache/hop/issues/4657
### What would you like to happen?
### Feature Request: OAuth Authentication Support for Salesforce Integration
**Summary:**
To enhance security and comply with evolving Salesforce policies, we propose adding OAuth authentication support for Salesforce Input/Output operations in our product.
**Background:**
Many companies are adopting stricter security measures for their Salesforce Organizations, requiring all API access to be conducted via a Connected App using OAuth. This policy renders the standard SOAP API login() call with username, password, and security token ineffective. Instead, an OAuth handshake must be performed to generate a bearer token, which is then used in the SOAP "sessionID" header for all Salesforce SOAP calls.
**Proposed Solution:**
1. **OAuth Authentication Mechanism:**
- Implement OAuth as an authentication option within Salesforce Input/Output operations.
- Allow users to perform the OAuth handshake and generate a bearer token.
2. **REST Client Integration:**
- Enable the REST Client to generate an OAuth bearer token.
- Allow the insertion of the "sessionID" SOAP header parameter for Salesforce Input/Output operations without requiring additional username/password setup.
**References:**
- Salesforce OAuth and SOAP API: https://developer.salesforce.com/blogs/developer-relations/2011/03/oauth-and-the-soap-api
- Other ETL Vendors Reference: https://knowledge.informatica.com/s/article/515185?language=en_US
This feature will align our product with current security practices and ensure seamless integration with Salesforce for our users.
### Issue Priority
Priority: 2
### Issue Component
Component: Hop Gui
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #4657: [Feature Request]: Support OAuth Authentication for Salesforce Input/Output
URL: https://github.com/apache/hop/issues/4657
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #4657:
URL: https://github.com/apache/hop/issues/4657#issuecomment-2525275611
Absolutely. A first stab at that will be included in 2.11, but there are a lot of possible options and configurations. We'll need to work on this for a couple of releases.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #4657:
URL: https://github.com/apache/hop/issues/4657#issuecomment-3357566391
.take-issue
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
Posted by "CatalyseRichard (via GitHub)" <gi...@apache.org>.
CatalyseRichard commented on issue #4657:
URL: https://github.com/apache/hop/issues/4657#issuecomment-2525242220
Would it be good to have this as a separate 'generate OAuth token' transform to enable it to be more generic, not just limited to salesforce?
The input would be the parameters required to obtain the JWT and the output would be a field containing the token which can then be used as required (generally by concatenating with a known bearer to create an authentication string).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Feature Request]: Support OAuth Authentication for Salesforce Input/Output (hop)
Posted by "zoomingrocket (via GitHub)" <gi...@apache.org>.
zoomingrocket commented on issue #4657:
URL: https://github.com/apache/hop/issues/4657#issuecomment-2528251330
@CatalyseRichard @bamaer - A dedicated OAuth Token generator will help, but the current problem is passing the generated bearer token to Salesforce SOAP (WSDL) based API, which requires the sessionID header.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org