cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
This connector uses cdata jdbc driver found here:
https://www.cdata.com/drivers/salesforcemarketing/jdbc/
After you run the installer, the files you are going to want to copy is found here:
C:\Program Files\CData\CData JDBC Driver for Salesforce Marketing Cloud 2019\lib
 
Make a folder called SalesForceMarketing to this path:
C:\ProgramData\Sisense\DataConnectors\jdbcdrivers

Copy all the files inside here:
C:\Program Files\CData\CData JDBC Driver for Salesforce Marketing Cloud 2019\lib
 
TO HERE:
C:\ProgramData\Sisense\DataConnectors\jdbcdrivers\SalesForceMarketing

After this Go to Sisense WebECM, create new elasticube (or use existing one),
Use the Generic JDBC Connector:
Use these are the parameters:
Connection String:
jdbc:sfmarketingcloud:User="YOURUSERNAME";Password="YOURPASSWORD";Subdomain="YOUR-SUBDOMAIN";Initiate OAuth="GETANDREFRESH";OAuth Client Id="YOURCLIENTID";OAuth Client Secret="YOURCLIENTSECRET";OAuth Grant Type="CLIENT";Schema="SOAP";SSLServerCert=*;
JDBC JARs Folder:
SalesForceMarketing
Driver's Class Name:
cdata.jdbc.sfmarketingcloud.SFMarketingCloudDriver
From Salesforce Marketing Cloud Console:
Follow these instructions:
http://cdn.cdata.com/help/FEE/jdbc/pg_connrest.htm
Make Sure it's "Server to Server"
After all of this is done, you will be able to pull data, the one table I used which I found very useful is the "Send" table. 
Rate this article:
Version history
Last update:
‎03-02-2023 08:43 AM
Updated by:
Contributors