Hello,
Thanks in advance for any assistance. I tried to find a previous Community post or other guidance with a solution to my problem but failed. I am trying to set up a connection between Designer Desktop and Salesforce. I've tried a "Salesforce ODBC" data source via the Input Tool (and Simba Salesforce ODBC Driver DSN) as well as a "Salesforce" quick connect data source via the Salesforce Input Tool. I have provided my Salesforce credentials (login, password, security token) in both the Alteryx "Connection Manager" and the configuration settings of the Simba Salesforce ODBC Driver DSN Setup tool.
When testing the connection for the "Salesforce" data source in the Salesforce Input Tool, I get a simple "authentication failure" error message within the tool's configuration pane.
When testing the connection for the "Salesforce ODBC" data source in the Input Tool, I get the following error message: "Internal Error SQLDriverConnect: [Simba][Salesforce] (148) INVALID_SSO_GATEWAY_URL: the single sign on gateway url for the org is invalid." This leads me to believe the SSO gateway URL present within the Simba Salesforce ODBC Driver DSN configuration settings does not match my company's Okta/Salesforce SSO gateway URL. However, I cannot seem to find a URL field where I could make a change within the configuration settings. [Note: I know the attached screenshot of the Simba Salesforce ODBC Driver DSN configuration settings has blank fields for authorization credentials but they go away each time I unsuccessfully test the connection.]
Screenshots attached for reference. Apologies if I did not include some information that would be needed for you all to help. Just let me know. Thanks!
