Stripe 3rd Party OAuth Setup
Below we outline how to connect Matillion ETL to your Stripe account using a simple OAuth setup. The process can be understood in 2 parts - collecting details from your Stripe account and then entering those details into Matillion ETL. This process is necessary before beginning to use the Stripe Query component.
Method 1: Collecting Data From A Single Account
Log into your Stripe Account and browse to Developers → API Keys along to left-hand menu of your Stripe dashboard.
Click Reveal Live Key Token. The revealed code is your Client Secret, make a note of it.
Now go to your Matillion ETL instance and make a blank (unconfigured) Stripe OAuth via Project Menu → Manage OAuth
Use this unconfigured OAuth in the Stripe Query component's Authentication property.
Now edit the Connection Properties of the component and set the oauthaccesstoken property to your Client Secret we gained earlier. This alone should now be enough for the component to connect to your Stripe account.
Method 2: Collecting Data From Another Account
To configure your OAuth for Stripe, you will need 2 pieces of information from your Stripe account; a Client ID and a Client Secret. Ensure you are logged into the Stripe dashboard of the account you wish to connect to Matillion, then follow the below sections to gather the necessary information.
From your Stripe dashboard, browse to Settings then to Connect Settings. Scroll down the page until you find the section 'Development'. Take note of the 'client_id' code as your Client ID.
You are also required to change the 'Redirect URIs' field to point to your Matillion ETL instance. The URI should have the following format:
https://<Matillion ETL Instance Address>/oauth_redirect.htmle.g.
https://instance.matillion.com/oauth_redirect.htmlIf you are unsure, Matillion ETL will give you the correct URI later in this process and you can return here to complete this field later. Note that it may be required that your redirect address is a secured HTTP to be accepted using this method.
Browse to Developers → API Keys along to left-hand menu of your Stripe dashboard and click Reveal Live Key Token. The revealed code is your Client Secret, make a note of it.
Note: If you wish to use test data, ensure that 'View Test Data' if selected (orange) before revealing your Secret ID as it will be different to the one used for your live data.
Configuring the Matillion ETL Instance
Log into your Matillion ETL instance and from the Project Menu select 'Manage OAuth'. Use the + button at the lower-left of the Manage OAuth window to add a new OAuth method.
From the 'Service' dropdown menu select 'Stripe' and name the entry whatever you please. Now find that same entry from the list in the Manage OAuth window and select the green cogwheel icon beside it to edit the OAuth details.
Fill in the Client ID and Client Secret that we found in the previous section. Hit 'Next'. On the next screen you will find your Callback URL. If you did not complete your 'Redirect URI' in the previous section, copy the Callback URL and paste it into that field on the Stripe dashboard.
When all is complete, click the 'Authorization link'. Wait a few moments and if all has succeeded, you should be presented with an 'Authorization successful' message.
You are now free to close the window. If the OAuth was unsuccessful, ensure your Stripe account is set up correctly and that the details entered are correct. If this still fails, do not hesitate to contact Matillion ETL support for hands-on help.
For more information in how to set up OAuths in Matillion ETL, see Setting up OAuth in Matillion ETL.
Now that your OAuth is configured, it can be used by selecting the entry name from the Stripe Query component's 'Authentication' property.