This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
If non-admin – Reach out to your license admin to obtain/install the Simba Salesforce Driver
If an admin
Go to licenses.alteryx.com and log in via your Alteryx SSO account
In the left menu, navigate to Drivers and download the Salesforce driver installer
Set up ODBC connection DSN connection
Add Input tool to canvas
Click “Connect a File or Database” dropdown of tool and select Data sources
On the bottom right menu, click “ODBC” under “Generic connection”
On the ODBC connection pop-up, access the ODBC Admin at the bottom left of the pane. This will open up a new window outside of Designer
Go to the User DSN tab and click Add on the right
if multiple users will use the machine and SF connection or you are configuring the connection within an Alteryx Server environment, go to System DSN instead.
Select the "Simba Salesforce ODBC Driver" you installed previously and click Finish.
Provide a data source name of your choosing and enter in your security token (leave username and password blank as this will be entered in Designer) and check the "Save Security Token" box in order to utilize the token with Designer.
Click Ok and restart Designer. Navigate back to the Generic ODBC connection menu and select the new DSN you just created and enter your username and password to connect
. DSN-less connection
You can also utilize a DSN-less connection string if preferred directly in the Input tool. Below is an example template (replacing anything with curly brackets with your respective information):
You’ll also notice that the DSN-less connection will allow you to specific a particular API version.
Salesforce reports within the Visual Query Builder. Stored procedures would be the equivalent of Reports within Salesforce and stored procedures are not supported within the Visual Query Builder for the Salesforce Driver
OAuth. While OAuth is supported with the driver itself, it is currently not supported within the Alteryx software