Trying to establish a connection from Matillion to Salesforce using OAuth

Matillion ETL
1

I am currently trying to establish a connection from Matillion to Salesforce using OAuth.
Here is what I’ve done so far and the current situation:

  1. I followed the instructions in the following documentation to create an application in Salesforce and obtained the client_id and client_secret:
    Salesforce Query authentication guide - Matillion Docs
  2. In the Matillion OAuth configuration, I selected Salesforce and entered the client_id and client_secret obtained in step 1.
  3. The “Authorization Successful” message briefly appears, and the screen returns to Matillion, but it remains stuck at “Waiting for response from service…” indefinitely.

The relevant settings are as follows:

  • The Salesforce application was created as a standard Connected App, not as an “External Client Application”.
  • The OAuth scope is set to Full access, and the Callback URL matches the one shown in Matillion.
  • Both Require Secret for Web Server Flow and Require Secret for Refresh Token Flow are enabled.
  • The domain is properly set to a registered FQDN and SSL is successfully configured.

What other possible causes could there be?
If anyone has encountered a similar issue, I would appreciate your insights.

2

Hello @kuroiwa

Thank you for your post, and welcome to the Matillion Community! We took a look at this and cannot seem to replicate it.

We would suggest the following:

  • have the Perform requests at any time (refresh_token, offline_access) scope configured in their app
  • Try refreshing the browser cache or try incognito mode

This should resolve that for you. If not, please let me know, and we can investigate further.

Kind regards, Joe

3

Dear Joe

Hi.
Thank you for your response!!

As per your comment, I changed the full access permission to the specified one and tried it in incognito mode — and it worked!
Thank you so much for your precise and helpful advice.

2 Likes
4

I am really happy to hear that, @kuroiwa. If you need anything else, please feel free to post here on the Matillion Community.

Kind regards, Joe