Connecting To SalesForce Marketing Data
This connector uses cdata jdbc driver found here:
https://www.cdata.com/drivers/salesforcemarketing/jdbc/
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
C:\Program Files\CData\CData JDBC Driver for Salesforce Marketing Cloud 2019\lib
TO HERE:
C:\ProgramData\Sisense\DataConnectors\jdbcdrivers\SalesForceMarketing
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:
SalesForceMarketingDriver's Class Name:
cdata.jdbc.sfmarketingcloud.SFMarketingCloudDriverFrom Salesforce Marketing Cloud Console:
Follow these instructions:
http://cdn.cdata.com/help/FEE/jdbc/pg_connrest.htm
Make Sure it's "Server to Server"
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.
Updated 03-02-2023
