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.

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.

Stitch offers various plans to meet your data needs, including free plans. Sign up for your account and plan at https://www.stitchdata.com

Scroll down or search for Deputy in the list of integrations and add this to your account.

Set the name for your integration and then configure the remaining options according to your data needs and click Authorize.

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.

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.

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.

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.

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.

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.