Connecting to Stripe

The Sisense Stripe connector is a standalone connector that allows you to import data from Stripe’s API into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who connect to the Stripe APIs. To obtain a connection string, you will need to create a Stripe app.

Once you have connected to Stripe, you can import a variety of tables from the Stripe API.

This page describes how to install the Stripe connector, how to connect to Stripe with a connection string, and what tables you can import into the ElastiCube Manager:

Installing the Stripe Connector

Sisense provides the Stripe connector as a standalone connector that you can download and add to your list of default Sisense connectors.

To install the Stripe connector:

  1. Download the Stripe installation file.
  2. Open the installation file and click Install.
  3. After the installation process is complete, click Close.
    The Stripe connector is displayed in the ElastiCube Manager under Add Data > Web Services.

Connecting to the Stripe REST API

To access Stripe’s REST API from the ElastiCube Manager, you must provide valid Oauth Stripe credentials through a connection string. These credentials are provided by Stripe when you create an application.

After you receive your credentials from Stripe, you can create the connection string and provide Sisense with it to connect to your data.

Registering an App

Follow the steps below to obtain the OAuth client credentials, the OAuthClientId and OAuthClientSecret:

  1. Log into your Stripe dashboard and click Your Account > Account Settings > Connect > Platform Settings.
  2. Enter a name, description, and other information to be displayed to users when they log in to grant permissions to your app.
  3. If you are making a desktop application, set the Redirect URL to http://localhost:33333 or a different port number of your choice.
    If you are making a Web application, set the Redirect URL to a page on your Web app you would like the user to be returned to after they have authorized your application.

Adding Stripe Tables to your ElastiCube

Sisense uses connection strings to connect to Stripe and import data into the ElastiCube Manager. Each connection string contains a authentication parameters that the data source uses to verify your identity and what information you can export to Sisense.

TThe connection string to Stripe is in the following format:

jdbc:stripe:APIKey=xxxxxxxxxxxxxxxxxxxxxx;

For example:

jdbc:stripe:InitiateOAuth=GETANDREFRESH;Instance=xxxxxxxxxx;OAuthClientId=xxxxxxxxxxxx;

OAuthClientSecret=xxxxxxxxx;

Your Stripe connection string should include the following parameters, separated by a semicolon ';'.

If you have any issues connecting to your data source, see Troubleshooting JDBC Data Connectors.

To add Stripe data:

  1. In ElastiCube Manager, click Add Data and then, Stripe. The Connect to Stripe window is displayed.
  2. In Datasource Connection String, enter your connection string.
  3. Click Connect to Server. Stripe is displayed in the Select Database list.
  4. Click OK. Sisense connects to Stripe and displays a list of tables available for you to import.
  5. Select the relevant tables and click Add.
  6. The tables are displayed in the ElastiCube Manager.

Stripe Tables

Stripe’s RESTful APIs expose the following Stripe tables that you can import into the ElastiCube Manager through the Sisense Stripe connector:

Available Tables

Name Description
Accounts Create, update, delete, and query the Accounts you manage in Stripe.
BankAccounts Create, update, delete, and query the available Bank Accounts in Stripe.
BankAccountTokens Insert and query the available Bank Account Tokens in Stripe.
Cards Create, update, and query the available Cards in Stripe.
CardTokens Create and query the available Card Tokens in Stripe.
Charges Create, update, and query the available Charges in Stripe.
Coupon Get and delete the available discount of a Subscription
Customers Create, update, delete, and query the available Customers in Stripe.
CustomerDiscounts Get and delete the available discount of a Customer.
Disputes Update and query the available Disputes in Stripe.
Plans Create, update, delete, and query the available Plans in Stripe.
Refunds Query the available refunds in Stripe.
SubscriptionDiscounts Get and delete the available discount of a Subscription.
SubscriptionItems Create, update, delete, and query the available subscription items in Stripe.
TransferReversals Query the available categories in Stripe.
Transfers Query the available transfers in Stripe.

Available Views

Name Description
AvailableBalance Query the Available Balance in Stripe.
BalanceHistory Query Balance History in Stripe.
CountrySpecs Query the available Country Specs in Stripe.
Events Query the available events in Stripe.
Orders Query the available orders in Stripe.
PendingBalance Query the available balance in Stripe.
Products Query the available products in Stripe.
Skus Query the available SKUs in Stripe.

Versions

Version Release Date Improvements
6.6.1.57 May 18, 2017 New Objects supported: Coupons, CustomerDiscounts, Plans, SubscriptionDiscounts, SubscriptionItems
6.6.0.37 March 16, 2017 General Release
6.5.1.10 December 15, 2016 General Beta release

Limitations