Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Data Sources / Integrations

JUMP TO

Now that we understand how a data warehouse works, let's talk about how we get data into the data warehouse. In Stitch, data sources are called integrations, which is where data is pulled from. Data can be pulled in through a direct connection or via a piece of software called an API, or Application Programming Interface. APIs allow for more security, control, and flexibility over the data sent through the Stitch.

In most cases, setting up an integration in Stitch is as easy as simply entering your account credentials. After setup is complete, all available tables will begin syncing to your data warehouse.

There are two types of data sources: databases and SaaS. Databases are sources like MySQL, Microsoft SQL, and PostgreSQL.

SaaS sources are integrations like Google Adwords, Salesforce, and Zendesk. It’s important to note that because third-party data lives on the vendor’s server, you cannot directly access it.

So, what does the entire data process, from event to exploration, look like in Stitch? This won't look the same for everyone, but here's a general overview:

  1. Raw data is created or updated in a data source
  2. The Stitch integration framework, or API, “talks” to the source’s server to retrieve the data you request
  3. The requested data is pushed into the Import API
  4. The Import API pushes data into the data warehouse - in our case, Amazon Redshift
  5. Data populates the data warehouse. Here you can view the status of your integrations and flag tables and columns for tracking.
  6. After connecting your Redshift instance to your tool of choice, you can create visual analyses, perform statistical analyses, and more

Now that you understand where your data comes from, let's move on to the interesting things you can do with the data that lives in your data warehouse.

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!