RevenueStory lets you replicate the underlying and historical data into your BI-based warehouse using Stitch. It uses Stitch to establish secure connections between your data in RevenueStory servers and your destination sources for reliable and rapid movement of data.
Intended audience
The information described in this document is specific (but not limited) to developers responsible for Freshworks backend integration with Chargebee. This includes developers and administrators with the appropriate authorization to Freshworks' database and related resources.
How it works?
RevenueStory data model configuration with Stitch enables it to listen and process your data easily.
Once the pipeline is established, RevenueStory then leverages Stitch's import API feature to push your data.
This capability creates a secure ecosystem to transfer data from source to destination.
Steps to establish a pipeline
Step 1: Generate an API Key
Generate a Chargebee API Key for Stitch. This will allow Stitch to read data from your Chargebee account using the Chargebee API.
On your Stitch Data Loader UI, click Add Integrations.
On the Add and Integration search box, search for "Import API" and select it.
On the Configure your Import API Integration screen, enter an Integration Name. For example, "sample-integration". Use an easily identifiable name specific for your Chargebee site. It is recommended that you follow a convention.
Click Save and Generate Tokens. This creates a Stitch API token which is used to authenticate data transfer from your Chargebee site to Stitch.
Copy the Stitch API Token and click Close and Continue. This adds the Stitch Import API integration to your account
Click All Done.
Configuring your warehouse
The following steps describe how you can configure your warehouse.
For the documentation purpose, we have taken the example of Amazon S3 server. If you wish to integrate Stitch for other storage resources, the settings may vary. Refer to the related documentation in Stitch to know more. Learn about details of choosing a destination for smooth data transfer.
Note:
Values in resource_updated_at column are in user timezone but stitch automatically adds a UTC text to its end.
At present, RevenueStory cannot capture deleted records. Once a record is synced to the Destination, there is no way to remove this record if it is deleted from RevenueStory.
On the Stitch Data Loader main menu, click Destination
On the Select a destination for your data screen, choose your destination server (in this case, Amazon S3)
On your destination storage resource, create a new Bucket (or Host end point), say stitch-sample-demo-docs
Enter the name of the storage resource (or Host end point).
(Optional) Under Store Data in this Format, select CSV.
Grant Stitch access to write to your storage resource (Host end point)
Click Copy Code
Navigate to your Amazon S3 instance, Buckets > stitch-sample-demo-docs > Permissions > Bucket Policy and enter the code copied to your clipboard.
Click Save.
Verify the connection, by uploading a test file.
Click Check and Save.
This will establish your Pipeline through which Stitch writes into your storage resource.
Change your Destination
If you wish to change your destination, follow the below steps:
On the Stitch Data Loader main menu, click Destination .
Under the Historical Data section, choose:
Replicate new data only: This will enable stitch to only receive new data from your Chargebee Site
Replicate historical data: This will initiate a full resync from the date specified at the Integration stage.
Click Continue. This will delete the current destination.
Click Remove.
This will remove the current destination and you can set up a new one from the configuring your warehouse step.
Installation
Copy and paste the following code snippet and save it as install.sh