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

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.

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.

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.

Check out our documentation, then start replicating your S3 CSV files.

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.

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.”

How to start from scratch and use your data to create a report in Tableau.

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.

Over the last several months, we’ve added dozens of customer stories to our Customers page. Here’s a summary of some interesting ones.

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.

Stitch is growing. We’re looking to hire software engineers. Read about what it’s like to work at Stitch on our Careers page.