Stripe

Stripe is a way to accept payments online and in mobile apps. It handles billions of dollars every year for forward-thinking businesses around the world. 

How to Connect

There are two ways to connect to Stripe: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Stripe button in the list of connectors or type ‘stripe’ in the search field and select it:

3. Click the button, enter your API key, and click Connect:

Usage 

The Stripe API connector introduces a new virtual schema stripe that contains the following stored procedures:

In addition to these public API procedures, there are a couple of views in another virtual schema stripe_examples that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping stripe_examples.