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 setup 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 ("Deputy" works just fine) and then configure the remaining options according to your data needs.
Step 4 - Authorize Stitch to access your Deputy account
Sign into 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.
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.
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 data warehouse and test the connection.
Stitch will test the connection to your data warehouse and if this is successful you are done.
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 setup 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 firstname.lastname@example.org or start a live chat inside of your Deputy account.