TL;DR: Yes, you can do it. And no, you don’t need a separate tool for it. “Reverse ETL” is a fairly recent addition to the data engineer’s dictionary. While you can read articles upon articles about it (there’s a pretty good ‘primer’ in the Memory Leak blog), it can be summarized as being the art and science of taking data from your data warehouse and sending it somewhere other than BI - generally into other tools and systems where it becomes operational.

Transferring data is a hassle if you don't have the right tools, particularly when you're transferring from multiple sources or in various formats. Fortunately, you can use tools to make the entire ETL process simpler and less prone to error. Platforms like Teradata make it easy to get your data where it needs to go.

The Talend Product Suite tries to be a one-stop-shop for everything data. Whether you need an ESB, iPaaS, API Gateway, or ETL platform, Talend has a tool for it. Xplenty, on the other hand, is a targeted solution that focuses on ETL only. It's an enterprise-grade ETL solution that empowers non-tech-savvy users to build sophisticated data integrations. Both Talend and Xplenty are powerful ETL solutions with excellent reputations and high functionality.

Don’t make costly mistakes as your business strives to make better use of data.

Heroku is a cloud platform as a service (PaaS) for efficiently building, deploying, monitoring, and scaling applications. Originally created to work with the Ruby programming language, Heroku is now part of the Salesforce platform and supports languages such as Java, Node.js, PHP, Python, and Scala. While Heroku makes it easy to develop production-ready applications fast, one question remains: how can you integrate your Heroku app data with the rest of your data infrastructure and workflows?

Ever since Salesforce acquired Heroku back in 2010, the two services have worked exceptionally well together. Businesses can use Heroku to build flexible and scalable applications while utilizing Salesforce to manage customer data and drive sales. And when you need to share data between these two platforms, there’s a dedicated add-on: Heroku Connect.

Personally identifiable information (PII) and protected health information (PHI) are two types of sensitive data that fall under one or more data privacy regulations. HIPAA and GDPR are examples of the regulations that govern what organizations can and need to do with PII and PHI. When you work with large data sets, it can be challenging to maintain compliance with these regulations.

The faster you can extract, transform, and load data from MongoDB, the better it is for your business processes and business intelligence systems. The problem is, most ETL solutions struggle to manage MongoDB’s dynamic schemas, NoSQL support, and JSON data types. That’s not the case with Xplenty – which was optimized for easy, no-fuss MongoDB integrations with ease: no custom code, no delays, no confusion.

Data integration has been around for decades in some form or fashion, as organizations are always looking for ways to combine their enterprise data and collect it in a centralized location. The most commonly used and dominant type of data integration is ETL (extract, transform, load). ETL first extracts data from one or more source systems, transforms it as necessary, and then loads it into a target warehouse or data lake.

Reverse ETL is an emerging piece of the modern data stack that enables you to productionize your analytics.