TrustRadius
Stitch in Philadelphia offers their flagship ETL tool to developers; the company was spun off from RJMetrics after that company's acquisition by Magento, and is an independent entity.StitchInflexible, but fully-managed2018-09-12T18:42:43.321ZWe use Stitch to periodically replicate transactional datastores to an analytics warehouse. The transactional datastore are primarily PostgreSQL and MongoDB databases for microservices. Both the engineering and data teams use Stitch. The transactional datastores are not suitable for running analytics queries; they are tuned for different types of queries and access patterns. Extracting data from the transactional stores, transforming it to a different schema and data types, and loading it into a different datastore is not trivial work, and it is necessary to support the data and BI teams.,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.,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.,7,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.,,Amazon API Gateway, Amazon CloudWatch, Amazon DynamoDB, Amazon ElastiCache,4Verified UserA time saver2018-01-31T19:05:31.521ZStitch is used by the data team which is mainly the BI analyst, the lead developer, the CFO and the web analytics person. We all need the data from our third-party tools but do not have the time/skills/will to build and manage integrations.,Stitch does one thing and does it well: turn the data ingestion from third-party APIs into a one-click task
It makes all that data into a proper schema as a bonus,One of our integrations had to be re-synced on a regular basis. I still don't know why.,9,It has enabled the company to get new insights by joining together datasets that were previously stored in different places.
It has saved weeks of work that were used to do more profitable activities than building intregations.
It has allowed us to import in the company's data warehouse all the conversations that the customer service agents have had with the customers in case of a potential argument.,,Treasure Data, Looker,9,No,On a daily basis, I do not have a lot of interaction with Stitch customer service since using the product does not really require any assistance.
The main interaction I had was to ask them not to get charged when doing a full re-sync of one of the integrations. I never had any trouble with this.Verified User
Unspecified
Stitch
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
