Stitch Integration Quickstart
How to get started syncing your SaaSquatch program data to a Data Warehouse using Stitch.
Please Note: The Stitch integration with SaaSquatch can be configured on a per-tenant basis. Your programs contain a separate Live and Test tenant, and each can be connected to Stitch independently. Additional details about when to use your Test vs. Live tenant can be found in our article on testing best practices.
🔗 Add the SaaSquatch Integration
1. Retrieve SaaSquatch Program Info
From the SaaSquatch Admin Portal navigate to Settings > General. Make note of the tenant alias and API key on this page.
2. Open Stitch Account
Navigate to the Stitch website and create an account if you don't already have one.
3. Add SaaSquatch Integration
Search for, and select, the SaaSquatch integration to add to your Stitch account.
4. Configure your Referral SaaSquatch Integration
| Field | Description | Example |
|---|---|---|
| Integration Name | A name to give to this Stitch Data Source | SaaSquatch Live Tenant |
| Tenant alias | The identifying value for the SaaSquatch tenant you're using | test_bpinhag9gag |
| API Key | The API key for your SaaSquatch tenant, found on the General page under the Settings section | TEST_AGFVazAMTsxti2S8s9ZxxIe0GYcMV0F5 |
| Sync Historical Data | Default is to sync one year of historical SaaSquatch program data. This can be modified to a custom data value. | 17/03/2017 |
| Replication Frequency | How often Stitch will attempt to replicate data from your SaaSquatch program. The default value is every half hour. | Every 6 hours |
Congratulations, your SaaSquatch program is now successfully connected to Stitch! Your SaaSquatch data is now ready to be synced into the data destination of your choice.
🔗 Data Destination
To begin importing your SaaSquatch data make sure that you have configured a data warehouse as your Stitch data destination.
Stitch provides support for, among others, Amazon Redshift, Google BigQuery, and Postgres.
🔗 Already have a Data Destination configured?
That's great! You are all set! Your SaaSquatch data will be available to be synced into the data destination you have already configured in your Stitch account.
🔗 New to Stitch?
Are you just getting started with Stitch? Not a problem, you can easily setup a free data warehouse as a Stitch data destination to get started.
The easiest data destination to get started with is Panoply. With just a few clicks you can have a Panoply account configured directly through Stitch. This will automatically provision a new Amazon Redshift data warehouse for you to use. Follow Stitch's guide to get setup with your free Panoply account.
Once your data destination is setup Stitch will begin importing your SaaSquatch program data at the cadence you configured in the SaaSquatch integration setup.
🔗 Additional Resources
See Choosing a Destination to learn more about connecting your Stitch account to a Data Warehouse.
See the Stitch + Saasquatch guide for connecting your SaaSuqatch Program to your Stitch account.
Further technical details about the data that Stitch syncs across from SaaSquatch is also available.