What is the best way to access the salesforce marketing cloud data using SOAP? How do I generate username/password in salesforce automate for SOAP as opposed to Oauth?

Matillion ETL
1

Hello I m trying to access Salesforce marketing cloud data using SOAP protocol - salesforce marketing cloud query component (as some of the views that I wanted to access is only available via SOAP protocol)

 

List of dataviews that I want to access : https://sfmarketingcloudhome.files.wordpress.com/2021/02/dataviews_2021_v2.pdf

 

Matillion version : 1.66.20

However, when we generate the credentials in salesforce automate, we only get Client ID, Client Secret for SOAP as opposed for user name /password that you have in "Salesforce Marketing cloud" query component.

 

2

Hi @vikram.s2​

I hope you are well and welcome to the Matillion Community. As this is related to security and access, I would recommend reaching out to our support team at support@matillion.com

they will be able to support and help you with this and of course, get it resolved.

If you need anything else, please do not hesitate to ask.

Kind regards, Joe