How to setup data pipes for stripe dot com

Authorizing pipes vNext to access your stripe.com account

Before you can use pipes vNext to copy billing information into your data warehouse, you have to grant the application read only access to your data.

1. Direct your browser to https://dashboard.stripe.com/login.
2. Login using your stripe.com credentials.
3. Open your account settings (Your account > Account Settings).
4. Retrieve the API keys for your account.
   • Open the API Keys tab.
   • Copy the values shown for Test Secret Key and Live Secret Key into a text file.
5. Configure the stripe platform settings for pipes vNext.
   • Open the Connect tab.
   • Select the Platform Settings tab.
   • Click Register your platform.
   • In the standalone accounts section enter the following information
     1. Name (of the application, which can be any unique identifier, such as Simple Data Pipes)
     2. Website URL (optional)
     3. Redirect URIs for Development and Production environments. The URIs are the same for both: https://your_pipes_host_name.mybluemix.net/authCallback, where your_pipes_host_name refers to your running instance of pipes vNext.
   • Copy the client_id values displayed for production and development into a text file. You will need to provide this information later when you configure your stripe data pipes.
   • Click Done.

Copying data from stripe.com to dashDB

1. Direct your web browser to https://your_pipes_host_name.mybluemix.net/, where your_pipes_host_name refers to your running instance of pipes vNext.
2. Create a new pipe
   • Expand the Pipes drop-down menu on the upper right hand side.
   • From the Create new Pipe drop-down menu select Stripe.
3. Enter a unique pipe name and description.
4. In the Connect tab enter the following information:
   • Consumer key (client_id field from the stripe.com platform settings)
   • Consumer secret (API key from the stripe.com platform settings) Note: Use the information you’ve collected during your stripe setup. Choose the development client id and API key to access any test data you might have defined on stripe.com or the production client id and API key for live data.
5. Click Connect to Stripe to start the authorization process. You will be redirected to stripe.com.
6. If prompted, enter your stripe user credentials.
7. If the following dialog is displayed, click Skip this account form to grant pipes vNext read-only access to your billing data.
8. You will be redirected to the pipes vNext application. Click Save and continue. Note: After you complete this step, your instance of Pipes vNext has read-only access to all data your in your stripe account. This is reflected your account settings:
   • Open a web browser to https://dashboard.stripe.com/login.
   • Login using your stripe.com credentials.
   • Open your account settings (Your account > Account Settings).
   • Select the Connect tab.
   • Select the Connected Applications tab. You can revoke access at any time.
9. Pick a specific stripe object type (customer etc) or all object types (All Tables) in the Pick Tables tab.
10. Click save and continue.
11. Enter a time when to run the pipe or click Skip.If you decided to skip, click Run now on the next tab, called Activity.
12. Wait for the data transfer to complete. This will take several minutes.
13. After data has completed, click View details to open the summary. In this example, 52 stripe objects were transferred to dashDB.
14. Click Details to review the exact record count and important messages.