Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

New Source: Salesforce Marketing Cloud #4933

Open
sherifnada opened this issue Jul 23, 2021 · 31 comments
Open

New Source: Salesforce Marketing Cloud #4933

sherifnada opened this issue Jul 23, 2021 · 31 comments
Assignees
@marcosmarxm @harshithmullapudi
Labels
area/connectors Connector related issues autoteam connectors/source/salesforce connectors/sources-api Icebox new-connector team/connectors-python team/extensibility

Comments

@sherifnada
Copy link
Contributor

Tell us about the new connector you’d like to have

https://www.salesforce.com/products/marketing-cloud/overview/

Describe the context around this new connector

Describe the alternative you are considering or using
@sherifnada sherifnada added area/connectors Connector related issues new-connector labels Jul 23, 2021
@igrankova igrankova self-assigned this Aug 10, 2021
@igrankova
Copy link
Contributor

igrankova commented Aug 12, 2021 •
edited
Loading

Webhook-based? (no/partially/yes)
partially:
Webhooks - Read, Write
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/data-access-permissions.html#webhooks

Available authentication modes (API key/Oauth/other)
The Marketing Cloud offers a REST and SOAP API that share a common authentication mechanism based on OAuth 2:
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/create-integration-enhanced.html#related-items
API :
As of August 1, 2019, Marketing Cloud has removed the ability to create legacy packages. All new packages are enhanced packages. You can still use legacy authentication and API requests with existing legacy packages.
Marketing Cloud Production Support (sandbox) environment:
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/requestToken.html#example-request-for-testing

Has Sandbox environment?
No

How to populate the account with data
UI,
API:
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/walkthrough_upload_data.htm

Available streams for sync
https://docs.google.com/spreadsheets/d/140Ow-EwGhed3Y14fKbzKU5SoH5MQxcjNzi40-beaZx0/edit?usp=sharing
This source was developed on Singer. Creds: "source salesforce test creds" in LastPass

Integration supports incremental sync?
Yes:
https://developer.salesforce.com/docs/atlas.en-us.noversion.mobile_sdk.meta/mobile_sdk/entity_framework_native_inc_sync.htm

Other information/blockers
Marketing Cloud Production environment:
https://mc.exacttarget.com
Rate Limits:
https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/rate-limiting-best-practices.html#what-happens-if-you-are-rate-limited

@igrankova
Copy link
Contributor

Blocker:
"Developer Edition is a special development license that does not allow the conversion to production. The same is true for Sandbox. You cannot upgrade Sandbox, but you can purchase additional or different types of Sandbox if you have Enterprise, Unlimited or Force.com Edition." Also, one has to purchase licenses for each Sandbox types such as full,partial copy,developer pro and developer. Please refer the below sites:
https://developer.salesforce.com/page/An_Introduction_to_Environments
https://help.salesforce.com/HTViewHelpDoc?id=create_test_instance.htm&language=en_US (https://help.salesforce.com/HTViewHelpDoc?id=create_test_instance.htm&language=en_US)

@sherifnada
Copy link
Contributor Author

from #6678:

Tell us about the new connector you’d like to have

  • Which source and which destination?
    Salesforce Marketing Cloud
  • Do you need a specific version of the underlying data source e.g: you specifically need support for an older version of the API or DB?
  • Nope!

Describe the context around this new connector

  • Why do you need this integration? How does your team intend to use the data? This helps us understand the use case.
    Campaign performance evaluation

  • How often do you want to run syncs?
    At least daily

  • If this is an API source connector, which entities/endpoints do you need supported?
    https://developer.salesforce.com/docs/apis

  • If the connector is for a paid service, can we name you as a mutual user when we subscribe for an account? Which company should we name?
    No, I don't have the permissions to do that ... :(

Describe the alternative you are considering or using

What are you considering doing if you don’t have this integration through Airbyte?
Look into Stitch data

Are you willing to submit a PR?

I don't feel comfortable, but if you want me to try things out I will help in any way possible.

Link to singer tap: https://www.singer.io/tap/salesforce-marketing-cloud/

@sherifnada sherifnada mentioned this issue Oct 19, 2021
Closed
@marcosmarxm
Copy link
Member

@igrankova there is a community contribution adding this connector, is it possible to get the credentials?

@marcosmarxm marcosmarxm mentioned this issue Dec 23, 2021
Closed
39 tasks
@harshithmullapudi
Copy link
Contributor

@igrankova any update here ? cc: @karinakuz is there anything we can do ?

@karinakuz
Copy link
Contributor

karinakuz commented Jan 10, 2022 •
edited
Loading

@harshithmullapudi @marcosmarxm to use Salesforce Marketing Cloud Partner program is required (@igrankova mentioned this in the comments above). The Case #41868893 "Sign up for Partner Developer Edition" is submitted on 5 January and we are waiting Salesforce Support expert will get back to us. For now this case still has status "New".

@schlattk
Copy link
Contributor

Hey let me know if I can be of assistance in setting up this test account. We have some people at the Salesforce that might be able to help.

@igrankova igrankova moved this to Done in GL Roadmap Feb 3, 2022
@igrankova
Copy link
Contributor

Hi, @schlattk, I'm trying to get the CI creds for the Marketing Cloud, but received the answer from the support: Marketing Cloud does not have a sandbox environment like Salesforce.
Can you help us to get the account to the Marketing Cloud? I see we now have dev and sandbox accounts, but there's no access to Marketing Cloud.

@igrankova igrankova mentioned this issue Feb 16, 2022
Closed
40 tasks
@schlattk
Copy link
Contributor

schlattk commented Feb 21, 2022 •
edited
Loading

Hi, @igrankova when you say you have sandbox and dev accounts you presumably mean for Salesforce? SFMC is independent from SF so I suppose what we are looking for is a test account for SFMC? I suppose it doesn't need to be a "sandbox" it could just be a normal account with some sample data in it.

@igrankova
Copy link
Contributor

Hi, @schlattk, yes, that's correct. As I understand, there's no sandbox in SFMC, so we can use just a normal account to create the oauth application.

@schlattk
Copy link
Contributor

schlattk commented Feb 21, 2022 •
edited
Loading

ok @igrankova but they don't want to give you an account?

@igrankova
Copy link
Contributor

@schlattk SFMC can only talk about the paid account, they are sending me to the sales representative.
image

@schlattk
Copy link
Contributor

schlattk commented Feb 21, 2022 via email

@igrankova
Copy link
Contributor

@schlattk, it would be very helpful, thank you.

@schlattk
Copy link
Contributor

schlattk commented Feb 21, 2022 via email

@igrankova
Copy link
Contributor

@schlattk, Oh, sorry, yes, I'll contact them.

@schlattk
Copy link
Contributor

schlattk commented Mar 3, 2022

Hi @igrankova where do we stand on this? Is it a matter of not having a budget to pay for a licence?

@sherifnada
Copy link
Contributor Author

sherifnada commented Mar 4, 2022 •
edited
Loading

@schlattk apologies for the delay here - iryna is impacted by the Ukraine situation so we are experiencing a delay. Will respond soon!

@schlattk
Copy link
Contributor

schlattk commented Mar 5, 2022

@sherifnada oh ok sure nor problem really sorry to hear that.

@igrankova
Copy link
Contributor

@schlattk, hi, Konrad, last week we discussed the sandbox account configuration and price with the SFMC team and I asked Andy to step into and help with the financial questions, they also asked about the technical workflow and I sent a video of Salesforce connector as an example of account usage. I'm still waiting for their response. Today I've send a reminder.

@misteryeo
Copy link
Contributor

@schlattk as an update - we're still working with various folks on the Salesforce side to try and proceed here!

@schlattk
Copy link
Contributor

schlattk commented Apr 20, 2022 via email

@igrankova
Copy link
Contributor

The Business Plan is submitted (Partner Program) as a step to receive a sandbox

@igrankova igrankova added the unblockers Defines Unblockers Team label May 12, 2022
@igrankova
Copy link
Contributor

Please, find creds for the SFMC sandbox in the LastPass: Salesforce Marketing Cloud sandbox

@igrankova igrankova removed the unblockers Defines Unblockers Team label May 17, 2022
@misteryeo
Copy link
Contributor

@schlattk FYI, we've finally managed to secure a sandbox so @harshithmullapudi will be able to move forward with you here!

@misteryeo misteryeo added team/tse Technical Support Engineers and removed team/connectors-python labels Jun 9, 2022
@jbsilva
Copy link

jbsilva commented Jan 16, 2023

Any updates on the Salesforce Marketing Cloud connector?

@dduran28
Copy link

Any work being done in this connector?

@schlattk
Copy link
Contributor

schlattk commented Jul 31, 2023 via email

@dduran28
Copy link

@schlattk How can I go about using this in my Airbyte OSS env?

SFMC reports and the FTP source connector.

@shmf
Copy link
Contributor

shmf commented Oct 10, 2023

Hi, i am also interested in this connector - is there any update?
Thanks

@wwfch-cyrill
Copy link

wwfch-cyrill commented Apr 16, 2024 •
edited
Loading

We're looking into creating such a connector. Here are some useful resources:

Anyone started implementation or found another way of extracting data from SFMC?

@marcosmarxm marcosmarxm removed the team/tse Technical Support Engineers label Jul 12, 2024
@girarda girarda added the Icebox label Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@marcosmarxm marcosmarxm

@harshithmullapudi harshithmullapudi

Labels
area/connectors Connector related issues autoteam connectors/source/salesforce connectors/sources-api Icebox new-connector team/connectors-python team/extensibility
Projects
No open projects
GL Roadmap
Status: Done
Milestone
No milestone
Development

No branches or pull requests