View profile

New ETL integrations for PostgreSQL, Zendesk, and S3 CSV files

Revue
 
 
August 6 · Issue #23 · View online
Stitch
//Product Updates
New PostgreSQL integration offers support for logical replication
We’ve released an updated PostgreSQL integration that provides support for log-based logical replication. You can now perform incremental replication on a table without using a replication key, and the new integration captures and persists deletes in your tables. It’s equivalent to MySQL’s binary log replication, which Stitch began supporting a few weeks ago.
To take advantage of the new features, add a new PostgreSQL integration in your Stitch account. Read more about it in our docs.

New Zendesk integration brings several new features
We’ve also released a new, open source version of the Stitch Zendesk integration, based on the Singer standard. You can now replicate only the tables and columns you want, and you can choose to replicate ticket descriptions when you want to analyze the text of your Zendesk tickets. The new release also provides enhanced extraction logs and improved notifications.
Learn more about the new Zendesk integration in our documentation, and give the new Zendesk integration a try.
New S3 integration lets you replicate data from CSV files
Stitch’s latest integration can connect to an Amazon S3 bucket and replicate CSV files to any Stitch destination. It supports column selection for choosing which columns you want to extract from your CSV file, and incremental updates based on new or modified CSV files.
// From our blog
Data analytics architecture: Integrated stack or best-of-breed components?
As businesses pursue better data analytics, should they turn to a single platform that provides a data warehouse, ETL, and business intelligence, or will using individual tools provide a better result? Guest blogger Akash Agrawal, CEO of Nupanch BI Consulting, covers the pros and cons of each approach.
Dress code as values
CEO Jake Stein talks about Stitch’s dress code as a window into our values: “I want our team to care deeply about the things that matter (building a great product, providing great service, leveling up their careers, etc.) and not all about the things that don’t.”
Tutorial: Connecting Tableau to your data warehouse for analytics
How to start from scratch and use your data to create a report in Tableau.
How revamping our reporting with dbt and Zuora saved us 10 hours a week
Stitch revamped its financial reporting with help from partner Fishtown Analytics – and we’re making our dbt data models available for other Zuora users who want to do what we did.
How and why our customers use Stitch
Over the last several months, we’ve added dozens of customer stories to our Customers page. Here’s a summary of some interesting ones.
And more to come!
You should subscribe to our blog RSS feed to see all of our upcoming posts, including one on connecting Power BI to your data warehouse for analytics.
// Company updates
We’re hiring!
Stitch is growing. We’re looking to hire software engineers. Read about what it’s like to work at Stitch on our Careers page.
Did you enjoy this issue?
If you don't want these updates anymore, please unsubscribe here
If you were forwarded this newsletter and you like it, you can subscribe here
Powered by Revue