Connecting To SalesForce Marketing Data

[intapiuser]

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.