- What is Stitch?
- How does the Deputy > Stitch integration work?
- How to set up your Deputy > Stitch data integration
- Sign up for a Stitch account
- Add the Deputy integration to your account
- Configure your Deputy integration
- Authorize Stitch to access your Deputy account
- Select the data tables you wish to sync to your data warehouse
- Select the data fields in each table you wish to sync to your data warehouse
- Select your destination (data warehouse)
- Configure your data warehouse integration
- Sync your data
What is Stitch?
Stitch is a cloud-first, open-source platform for rapidly moving data. Stitch acts as an ETL process data pump to extract from data sources and transform and load into target applications. Stitch developed the Singer protocol, to help integrate sources and targets with help from the open source community.
How does the Deputy > Stitch integration work?
Deputy has created a “data tap,” a type of integration with Stitch, a platform to easily extract data from "taps" such as Deputy and transfer it to "destinations" such as a data warehouse. This will allow Deputy customers to easily grab their account data and pull it into their data warehouse to use it for whatever purpose they wish. The tap will be created using an open-source protocol called Singer.
The data tap functions by calling the Deputy API using your account credentials and querying all Resource endpoints for data. The data is then transformed and synced into your data warehouse.
How to set up your Deputy > Stitch data integration
Step 1 - Sign up for a Stitch account
Stitch offers various plans to meet your data needs, including free plans. Sign up for your account and plan at https://www.stitchdata.com
Step 2 - Add the Deputy integration to your account
Scroll down or search for Deputy in the list of integrations and add this to your account.
Step 3 - Configure your Deputy integration
Set the name for your integration and then configure the remaining options according to your data needs and click Authorize.
Step 4 - Authorize Stitch to access your Deputy account
Sign in to your Deputy account and grant access to Stitch. If you have multiple Deputy accounts, you will be asked to select the account your wish to configure then click Authorize.
Step 5 - Select the data tables you wish to sync to your data warehouse
Select which data tables you want to sync to your data warehouse. We suggest you select all available tables until you become familiar with the data you need to access.
Step 6 - Select the data fields in each table you wish to sync to your data warehouse
Select the field names for each table you will sync. We suggest you select all available data fields until you become familiar with the data you need to access.
Once you have selected all of your data tables and the relevant field then click Finalize your selection and then Yes, continue
Step 7 - Select your destination (data warehouse)
Choose from the list of available data warehouse integrations where you will send your Deputy data.
If you do not have a Stitch supported data warehouse, you may want to consider creating a custom data integration using our Singer data tap.
Step 8 - Configure your data warehouse integration
Enter the relevant settings for your chosen data warehouse and test the connection.
Stitch will test the connection to your data warehouse and if this is successful you are done.
Sync your data
Your Deputy data will undergo an initial sync into your data warehouse. After that, your data will sync according to the replication frequency settings you choose when you set up the Deputy integration in Stitch.
After the initial data sync, you will be able to run queries inside of your data warehouse against your Deputy data. If you have a data visualization tool (such as Tableau) connected to your data warehouse, you will also be able to access your Deputy data in that tool, as long as you configure the new Deputy data tables and fields to pull into your visualization tool.
If you have questions about how Deputy data tables and fields relate to each other, you should review the Deputy API resource documentation. If this is not sufficient, please contact Deputy Support.