The reverse ETL is the process of copying data from data storage into operating systems, including SaAS for marketing, sales and support. This allows any team of specialists, from sellers to engineers, to gain access to the necessary data in the systems that they use. There are 3 main options for using the reverse ETL:
• Operating analytics - the provision of analytical information in business teams in their usual work processes and tools in order to make decisions based on data
• Automation of data - automation of special data requests from other commands, for example, when financiers request data on the use of products to issue accounts
• Personalization of interaction from customers in different applications.
Today, the most popular means of the reverse ETL can be called the following:
• Hightouch - a data platform that allows you to synchronize data from storage facilities with CRM, marketing and client support
• Census - a platform of operational analytics, which synchronizes the data storage with different applications
• Octolis - a cloud service that allows marketing and sales departments easily deploy use scenarios, activating its data in its operating tools, for example, CRM or software for automation of marketing
• Grouparoo - an open source return, which is easily launched on a laptop or in a cloud, allowing you to develop locally, fix the changes and deploy
• Polytomic-an ETL solution that allows you to create in real time all the necessary customer data in Marketo, SalesForce, Hubspot and other business systems
• RUDDERSTACK-Client data platform for developers, where the TRU Tools simplify the deployment of conveyors collecting customers from each application, website and SAAS platforms to activate them in DWH and in application systems
• Workato-a means of automation of business processes in cloud and local applications
• Omnata - tool integration tool for modern architectures
• Smart ETL Tool from Rivery-Autlic process automation platform using any cloud DBMS, including Redshift, Oracle, Bigquery, Azure and Snowflake
Reverse ETL is one of the popular trends in the West.
Briefly about what this is the class of tools. The reverse ETL allows you to pick up data from DWH and load it to various CRM / Sales / Support systems (usually they are called Destination in the Reverse ETL interface), providing constant synchronization. Thus, for example, in the tools of marketers, entries about leads are created or updated (various properties and parameters of the Lida).
The release of Data Engineering podcasts is just about one of the Grouparoo tools.
But there are other well -known solutions on the topic:
▪ Hightouch [commercial]
▪ Grouparoo and their article about Reverse ETL [Opensource]
▪ Airbyte [OpenSource]
#machinelearning #artificialintelligence #ai #datascience #programming #Deechnology #Deeuplearning #bigData #bigdata