TrustRadius: an HG Insights company

Stitch, a Qlik product

Score8.4 out of 10

17 Reviews and Ratings

What is Stitch, a Qlik product?

Stitch, or Stitch Data, now from Qlik is an ETL tool for developers; the company was spun off from RJMetrics after that company's acquisition by Magento. Qlik recommends users try Qlik Talend Cloud, though the Stitch platform is still available for data pipeline management to those who prefer it.

Stitch is a great tool, very cheap and simple to use for Data Ingestion

Pros

  • Automate data ingestion.

Cons

  • Better error messages so you can determine what the problem is.

Return on Investment

  • Good ROI in terms of being able to monitor cost performance from Google, Facebook, etc.
  • Easy to have Salesforce data and Intercom data for dashboards.

Alternatives Considered

Fivetran

Other Software Used

Tableau Desktop, Intercom, Snowflake, Trello

Great price for easy ETL

Use Cases and Deployment Scope

We use Stitch from Talend to get data from a variety of platforms into our data warehouse without having to deal with APIs (as I am not a developer). There are many integration options and data is able to be imported into our data warehouse without the need for heavy lifting on the development side. We then use the integrations within Stitch from Talend to get data from the data sources to our data warehouse, GCP BigQuery.

Pros

  • Integrations
  • Customer Support
  • Set up and management
  • Pricing
  • Transparency

Cons

  • Annual vs. Monthly Contracts
  • Version control for Integrations
  • Documentation
  • Communication of deprecations/upgrades that require work/adjustments

Return on Investment

  • KPI Management
  • Data Visualization
  • Data sanitization/normalization
  • Ease of ETL process

Alternatives Considered

Fivetran

Other Software Used

Zapier, Apple Numbers, Microsoft Excel, Adobe Illustrator CC

Stitch your Data ingestions

Pros

  • Easy integration with many sources
  • Extensible
  • Not as expensive as fivetran

Cons

  • Users feel the UI is not as friendly

Return on Investment

  • Freed up data engineers to work on transformations
  • Bought us some time to migrate from our ETL tool

Alternatives Considered

Fivetran

Other Software Used

Jira Software, Terraform, The Okta Identity Cloud

Inflexible, but fully-managed

Pros

  • Stitch is good at replicating relational databases. It manages the conversion of data types and schemas, and it is capable of incremental replication.
  • Stitch's UI makes it easy to configure which tables should be replicated, and how they should be replicated.

Cons

  • Stitch is not good at replicating document stores like MongoDB to relational databases. To be fair, this is a difficult task. Stitch flattens the objects, but the result is unwieldy.
  • Stitch cannot replicate the same source to multiple sinks, which is inconvenient if you want to replicate some of a datastore's tables to Redshift and others to Redshift Spectrum, for instance.

Return on Investment

  • Stitch manages replication of transactional datastores to our data warehouse. Our data and business intelligence teams need this data to be replicated. Stitch allows our data engineers to focus on our product.

Other Software Used

Amazon API Gateway, Amazon CloudWatch, Amazon DynamoDB, Amazon ElastiCache