topic Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud in Connectivity & Data Prep

QlikSense Enterprise Connector for Salesforce Marketing Cloud

Francesco_Xodo — Fri, 19 Jan 2024 09:23:21 GMT

Hello,

does anybody know a way to connect to Salesforce Marketing Cloud through the Enterprise version of QliKSense? I was able to connect to Salesforce Service Cloud through the native "Salesforce" connector, but it seems there is no way to connect to Salesforce Marketing Cloud (unless using the cloud version of Qlik).

Thank you

Kind regards

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

steeefan — Mon, 29 Jan 2024 07:41:59 GMT

I'm using the native Qlik Sense Salesforce connector in QS Nov 2023 and can't see a differentiation between Marketing and Service. I seem to able to see all the tables available in the Salesforce database of our Sandbox and Prod tenants, both from marketing and service perspectives.

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

Francesco_Xodo — Mon, 29 Jan 2024 16:40:57 GMT

Hello @steeefan,

did you do any configuration Salesforce side to ensure that Marketing tables are visible in the native connector?

Thank you

Kind regards

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

steeefan — Mon, 29 Jan 2024 16:48:50 GMT

Not to my knowledge, no. I'm using a functional user that apparently has specific rights to access these tables. I don't know how it's configured or where to access the settings.

If you give me the name of one or two tables, I can see if I can actually access that.

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

Francesco_Xodo — Mon, 12 Feb 2024 09:20:48 GMT

Hello @steeefan,

I talked with my colleague who manages Salesforce and he is not able to provide any table name. What we would like to get is the number of email sent and delivered, I don't know if this is of any help. The only solution we found at the moment is an export in .csv format of the Journey send log.

Thank you

Kind regards

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

steeefan — Mon, 12 Feb 2024 10:03:41 GMT

I'm not that familiar with Salesforce as well. My guess is to have a look at the EmailMessage table. It contains fields that look relevant to what you are looking for:

CreatedDate, FromName, FromAddress, ToAddress, CcAddress, BccAddress, Incoming, MessageDate,

I am able to access that table using the internal Qlik Sense Salesforce connector and external tools such as SOQL Studio.

Re: QlikSense Enterprise Connector for Salesforce Marketing Cloud

Francesco_Xodo — Mon, 12 Feb 2024 13:13:18 GMT

Hi @steeefan,

I can access that table but it contains emails about customer care cases (so "Service" side), not about Marketing campaigns.

Thank you

Kind regards