Skip to content

Salesforce Output authentication guide

Overview

This is a step-by-step guide to creating an OAuth entry, acquiring credentials and authorising the Salesforce Output component for use in Matillion ETL.

Important Information

  • The Salesforce Output component uses either a username and password or an OAuth for third-party authentication. This guide will only explain the OAuth method.
  • While component properties may differ between Cloud Data Warehouses, the authentication process remains the same.

Creating an OAuth Entry in Matillion ETL

  1. In Matillion ETL, on the top left of the screen, click ProjectManage OAuth.

    Please Note

    If a Salesforce Output component has already been added to an Orchestration Job, the Manage OAuth window may also be accessed using the following method:

    1. Click the component icon to open the Properties panel at the bottom of the screen.
    2. Then, click ... next to the Authentication Method input, and select OAuth from the dropdown.
    3. Then, click ... next to the Authentication input, and finally click Manage in the pop-up window.
    Project dropdown menu

    Project dropdown menu

  2. Copy the Callback URL in the field at the top of the window as this will be required in Acquiring Third-Party Credentials.

  3. Click + in the bottom left of the window to open the Create OAuth Entry window.

    New OAuth entry

    New OAuth entry

  4. Click the Service dropdown menu and select Salesforce. Then, provide a name for the OAuth in the Name field and click OK.

    Create OAuth Entry window

    Create OAuth Entry window

  5. On returning to the Manage OAuth window, check the list of OAuths to ensure the new entry is listed.

    Please Note

    This entry is Not Configured. Configuration of the OAuth entry will be discussed in Authorising for use in Matillion ETL.

    New Entry listed on Manage OAuth window

    New Entry listed on Manage OAuth window


Acquiring Third-Party Credentials

  1. Navigate to the Salesforce Output website. Enter valid login credentials to continue. The browser will then redirect to the Salesforce Output landing page. Click the account dropdown menu next to your Account name on the top-right corner of the page and then, click Setup from the dropdown.

    Salesforce Output homepage

    Salesforce Output homepage

  2. The browser will redirect to the Setup page, scroll down on the left to the Build section and click CreateApps on the sidebar to open the Apps window.

    Setup-Build-Create New App

    Setup-Build-Create New App

  3. In the Apps window, scroll down to the Connected Apps section and click the New tab to open New Connected App window.

    Create New Connected App

    Create New Connected App

  4. Next, in the New Connected App window, provide the details required in the Basic Information and API (Enable OAuth Settings) sections.

    • Fill in the required fields of Basic Information section as shown below.

      • Connected App Name – provide a name for the App to be connected.
      • API Name – provide a name to the API.
      • Contact Email – provide the email adress to be connected.
      Connected App-Basic details

      Connected App-Basic details


    • Fill in the required fields of API (Enable OAuth Settings) section as shown below.

      • Enable OAuth Settings – click the checkbox to enable the OAuth settings.
      • Callback URL – paste the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier).
      • Selected OAuth Scopes – select the required OAuth scopes from the list of available scopes.
        • Access and manage your data (api)
        • Provide access to your data via the Web (web)
        • Full access (full)
        • Perform requests on your behalf at any time (refresh_token, offline_access)

      Connected App-API(Enable OAuth Settings)

      Connected App-API(Enable OAuth Settings)

      Once you have completed all the details then, click Save.

  5. Browser will redirect to the New Connected App window once again, with a message " Allow from 2-10 minutes for your changes to take effect on the server before using the connected app ", click Continue tab on the window.

    New Connected App-Continue

    New Connected App- Continue

  6. The browser will returns to the App window you have created, with the codes. Scroll down to the API(Enable OAuth Settings) section, copy the codes next to the Consumer key and Consumer Secret as they will be required in Authorising for use in Matillion ETL.

    Please Note

    • Before the Consumer Secret can be copied, click Click to reveal to make it visible.
    • Copy the Consumer key and Consumer Secret value. You might not be able to retrieve them after your perform another operation or close this blade.
    • Additionally, when copying the codes, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.

    Copy Codes

    Copy codes


  7. Authorising for Use in Matillion ETL

    1. Return to the Manage OAuth window in Matillion ETL and click next to the previously created OAuth entry. This will open the Configure OAuth window.

      Manage OAuth

      Manage OAuth

    2. On the Configure OAuth window in Matillion ETL, provide the details for the following fields:

      • Client ID – provide the Consumer Key copied earlier from the Salesforce Output website.
      • Client Secret – provide the Consumer Secret copied earlier from the Salesforce Output website, then click Next.
      • Use Sandbox – Select No, if you are using real environment and select Yes, if you are using a Sandbox environment for OAuth.

      Configure OAuth settings

      Configure OAuth settings

    3. The next window will have an Authorization Link. Click on this link to authorise Matillion ETL to use the acquired credentials.

      Authorization Link

      Authorization Link

    4. The Salesforce Output SigIn page will appear immediately, click Sign In on the screen. Then, the browser will redirect to a Salesforce Output Screen requesting confirmation of the permissions associated with the app. Click to Allow to confirm.

      Confirm Salesforce output User

      Confirm Salesforce Output User

    5. If all is successful, the browser will return to Matillion ETL with a window stating Authorization Successful.

      OAuth Authorization Successful

      OAuth Authorization Successful


    Contact Us

    If any help is needed configuring the Salesforce Output component for use in Matillion ETL, please read the Getting Support article.