Connecting to Stripe via SQL

You can use SQL to connect to Stripe in the CData Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need the apikey.

How to Connect

Before you start retrieving data, you need to run the connector script for Stripe in the CData Virtuality Studio or the Web UI and input your credentials in the following line:

SQL

CALL SYSADMIN.createConnection (
    name => 'stripe_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=https://api.stripe.com/v1'
);;
 
CALL SYSADMIN.createDataSource (
    name => 'stripe_src'
    ,translator => 'stripe'
    ,modelProperties => 'API_key=<API_key>,Version=<Version>,cleanupMethod=DELETE'
    ,translatorProperties => ''
);;

Version parameter may be omitted, and in this case the default value will be 2017-05-06. Please check out https://stripe.com/docs/upgrades#api-changelog for the list of available versions. If newer version introduces a bugfix, which does not change the structure of the output, you may modify the version, and address the API bugfix without modifying the connector code. If a more significant change is introduced, a connector modification will be required. ListSubscriptions procedure will not support any version earlier than 2016-07-06, though there is no obvious reason to specify an earlier version than current, only the newer. Successful result of connector's operations is not guaranteed when you specify versions earlier than 2017-05-06.