Skip to content

Stripe Query authentication guide

This is a step-by-step guide to acquiring third-party credentials for authorizing the Stripe Query connector for use in Matillion ETL.

The Stripe Query connector uses either an OAuth or an API token for third-party authentication. Both methods are described in this guide.

While connector properties may differ between cloud data warehouses, the authentication process remains the same.

Warning

When copying information from a portal as required by this process, some browsers may add a space to the end of the copied string. Watch out for this as it will cause the credentials to fail.

Prerequisites

Begin the OAuth entry process as described in Manage OAuth. You should then configure this OAuth entry using the Stripe credentials, obtained as described below.

Acquiring third-party credentials: OAuth

  1. Log in to the Stripe dashboard. Once logged in, the browser will open on the Home page.
  2. Click Developers in the upper-right to open the Developers dashboard, and then click the API keys tab.

  3. In the Standard keys section, click Reveal live key in the Secret key field. Copy the revealed code. This is the Client Secret you will use to configure the OAuth in Matillion ETL.

    Note

    • The secret key can only be viewed once. If you can't see the option to reveal the key, you must create a new one. Click + Create secret key, enter a name for the key, and click Create. The newly created secret key must be copied immediately.
    • When copying the key, some browsers may add a space to the end of the string. Watch out for this, as it will cause the credentials to fail.

  4. Click the settings (cog wheel) icon in the top-right of the screen to open the Product settings page.

  5. Click Settings under the Connect heading.

  6. On the Connect settings page, scroll down to the Integration section. Copy the code to the right of Live mode client ID. This is the Client ID you will use to configure the OAuth in Matillion ETL.

    Note

    When copying the ID, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.

  7. Click + Add URI next to the Redirects field to open the Add redirect URI dialog.

  8. Paste the Callback URL (copied from the Manage OAuth dialog in Matillion ETL) into the Redirect URI field, and then click Add URI.

    Note

    • This must be a https URL.
    • When copying the Callback URL, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.

  9. Now return to the Manage OAuth dialog in Matillion ETL to complete the OAuth configuration.

Acquiring third-party credentials: API key

  1. Log in to the Stripe dashboard. Once logged in, the browser will open on the Home window.
  2. Click Developers in the top-left to open the Developers dashboard and then click the API keys tab.

  3. In the Standard keys section, click Reveal live key in the Secret key field. Copy the revealed code. This is the Client secret you will need to authorize the connector in Matillion ETL.

    Note

    • The secret key can only be viewed once. If you can't see the option to reveal the key, you must create a new one. Click + Create secret key, enter a name for the key, and click Create. The newly created secret key must be copied immediately.
    • When copying the key, some browsers may add a space to the end of the string. Watch out for this, as it will cause the credentials to fail.

This key is the only information you need to authorize the component with the Authentication Method property set to API key. You can enter the key directly into the component's API Key property, or use the Password Manager.