Setting up OAuth in Matillion ETL

When importing data into a table from a number of services it is necessary to use OAuth as the authentication mechanism. Matillion ETL abstracts the OAuth setup for all OAuth API’s to make this process as easy as possible. Currently supported OAuth API’s are.
To get started with any of the above API’s first perform the Third Party OAuth setup for the relevant API provider. Then follow the instructions below:-
  • Select Project -> Manage Oath
  • On the Manage OAuth Screen select New.
  • On the Create OAuth Entry screen select the service and enter a friendly name for the connection then select OK
  • Enter the Client ID and Client Secret from the Third party service.
  • Click Next, Matillion ETLwill generate an Authorisation link. If you click this link you will be redirected to the service which will prompt you to log in if required and authorise the Matillion ETL Application to access your data.
Note: Google OAuth may request access to multiple Google services such as YouTube, Adwords, Analytics and Sheets, even though you might not use such services yourself. This is because the Google 3rd Party OAuth is responsible for authorising many different components in Matillion ETL at once.
 
  • Once this process is complete you should see “Authorisation successful”
  • This credential will now be available for use in Components related to this service.